'JAVA'에 해당되는 글 252건

우선 이거부터 불러와야됨

 if (typeof Object.assign != 'function') {
  // Must be writable: true, enumerable: false, configurable: true
  Object.defineProperty(Object, "assign", {
    value: function assign(target, varArgs) { // .length of function is 2
      'use strict';
      if (target == null) { // TypeError if undefined or null
        throw new TypeError('Cannot convert undefined or null to object');
      }

      var to = Object(target);

      for (var index = 1; index < arguments.length; index++) {
        var nextSource = arguments[index];

        if (nextSource != null) { // Skip over if undefined or null
          for (var nextKey in nextSource) {
            // Avoid bugs when hasOwnProperty is shadowed
            if (Object.prototype.hasOwnProperty.call(nextSource, nextKey)) {
              to[nextKey] = nextSource[nextKey];
            }
          }
        }
      }
      return to;
    },
    writable: true,
    configurable: true
  });
}
 

package excelupload;

import java.io.File;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFFont;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Row;

public class ExcelUtils {
 public static void main(String[] args) {
  HSSFWorkbook workbook = new HSSFWorkbook(); // 새 엑셀 생성
  HSSFSheet sheet = workbook.createSheet("시트명"); // 새 시트(Sheet) 생성
  HSSFRow row  = null;
  HSSFCell cell = null;
  for (int j = 0; j < 10; j++) {
   row = sheet.createRow(j); // 엑셀의 행은 0번부터 시작
   for (int i = 0; i < 10; i++) {
    cell = row.createCell(i); // 행의 셀은 0번부터 시작
    row.createCell(1, CellType.STRING);
    cell.setCellValue("테스트 데이터" + i); // 생성한 셀에 데이터 삽입
   }
  }

  try {
   FileOutputStream fileoutputstream = new FileOutputStream("C:\\Users\\k\\Desktop\\dd.xls");
   workbook.write(fileoutputstream);
   fileoutputstream.close();
   System.out.println("엑셀파일생성성공");
  } catch (IOException e) {
   e.printStackTrace();
   System.out.println("엑셀파일생성실패");
  }
 }

}

 출처 http://boxfoxs.tistory.com/304

$(document).ready(  function() {

 $("#print").click(function(){
  var printWindow = window.open("", "", "width=1000,height=500");
  printWindow.document.write("<img src='http://www.smotor.com/kr/images/event/cupon1.jpg' style='width:100%;'>");
 
  printWindow.document.write("<script>  setTimeout(function(){ window.print(); }, 1000); </script>");
  printWindow.document.close(); // IE >= 10에 필요
        printWindow.focus();

  return false; 
  
 });
});

(\d)(?=(?:\d{3})+(?!\d))

function addComma(n) {
 var reg = /(^[+-]?\d+)(\d{3})/;
 n += '';

 while (reg.test(n)) {
  n = n.replace(reg, '$1' + ',' + '$2');
 }

 return n;
}

function getCookie(key) {

var cook = document.cookie + ";";

var idx = cook.indexOf(key, 0);

var val = "";

if (idx != -1) {

cook = cook.substring(idx, cook.length);

begin = cook.indexOf("=", 0) + 1;

end = cook.indexOf(";", begin);

val = unescape( cook.substring(begin, end) );

}

return val;

}

function setCookie(name, value, expiredays) {

var today = new Date();

today.setDate(today.getDate() + expiredays);

document.cookie = name + "=" + escape(value) + "; path=/; secure=true ; httponly=true; expires=" + today.toGMTString() + ";";

}

$('#dialog').dialog({

modal:true

,title:'확인'

,dialogClass:'dialog'

,width:'auto'

,position: ({

  my: "center",

  at: "center",

  of: window

})

,buttons:{

'예': function(){

$(this).dialog("close");

if(fnObj1!=undefined && fnObj1!=null){

        $(fnObj1);

        }

}

,'아니오': function(){

$(this).dialog("close");

if(fnObj2!=undefined && fnObj2!=null){

        $(fnObj2);

        }

}

,'취소': function(){

$(this).dialog("close");

if(fnObj3!=undefined && fnObj3!=null){

        $(fnObj3);

        }

}

}

,open: function (event, ui) {

$(':button.ui-dialog-titlebar-close').focus();

        }

   });