by Nathan

DBA커뮤니티 그루비 http://www.gurubee.net/

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 // WiseGrid 조회 WiseGrid_Test.GetCellValue("컬럼명", row); // WiseGrid 수정 WiseGrid_Test.SetCellValue("컬럼명", rowNum, document.f1.컬럼명.value); // WiseGrid 추가 WiseGrid_Test.AddRow(); var rowNum = 0; if(WiseGrid_Test.GetRowCount() != 0){ rowNum = WiseGrid_Test.GetRowCount() - 1; } WiseGrid_Test.SetCellValue("컬럼명1", ..

1234567891011121314var aMap = new Map();aMap.set("aa", "value");aMap.set("bb", "value");aMap.set("cc", "value");aMap.size; // 3aMap.get("dd"); // undefinedaMap.has("dd"); // falseaMap.delete("aa");aMap.clear(); // 전체삭제 // 확인용aMap.forEach(function(value, key){ console.log(key + " = " + value);});Colored by Color Scriptercs

12$('#id').prop('readonly', true); // 속성 추가$('#id').prop('readonly', false); // 속성 cs

12345678910111213141516171819202122232425262728MERGE INTO TB_ABCDE a USING ( SELECT #{aaa} AS AAA , #{bbb} AS BBB FROM DUAL ) indata ON ( a.AAA = indata.AAA AND a.BBB = indata.BBB ) WHEN NOT MATCHED THEN INSERT ( AAA , BBB , CCC , DDD , EEE , REGDATE , MODDATE ) VALUES ( #{aaa} , #{bbb} , #{ccc} , #{ddd} , #{eee} , TO_CHAR(SYSTIMESTAMP,'yyyymmddhh24miss') , TO_CHAR(SYSTIMESTAMP,'yyyymmddhh24miss..

12345678CREATE TABLE ABC_TABLE( AAA VARCHAR2(10) NOT NULL, BBB NUMBER(2,0) NOT NULL, HTML CLOB NOT NULL, REGDATE VARCHAR2(14) DEFAULT TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'), MODDATE VARCHAR2(14) DEFAULT TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'), CONSTRAINT PK_ABC_TABLE PRIMARY KEY(AAA, BBB));Colored by Color Scriptercs

js123function excelDown(){ location.href = "/exceldownload";}Colored by Color Scriptercs controller12345@GetMapping("/exceldownload")public void excelDownload(VO vo, HttpServletResponse response) { List dataList = service.getList(vo); // 데이터 조회 service.downloadData(dataList, response); // 엑셀 생성 및 다운로드}Colored by Color Scriptercs service123456789101112131415161718192021222324252627282930313233343..

build.gradle12compile ('org.apache.poi:poi:3.7')compile ('org.apache.poi:poi-ooxml:3.7')cs js12345678910111213141516var formData = new FormData($("#formId")[0]);$.ajax({ type : 'post', url : "/excelupload", data : formData, processData : false, contentType : false, success : function(html) { alert("파일 업로드를 성공하였습니다."); }, error : function(error) { alert("파일 업로드에 실패하였습니다."); console.log(error); co..

12345678910111213141516var list = new Array(); var vo = new Object();vo.a = "aaa";vo.b = "bbb";vo.c = "ccc"; var vo1 = new Object();vo1.a = "aaa";vo1.b = "bbb";vo1.c = "ccc"; list[0] = vo;list[1] = vo1; console.log(list);cs

HTML12 AAA BBBcs JS12345678function setDisplay(){ if($('input:radio[id=aaa]').is(':checked')){ $('#divId').hide(); }else{ $('#divId').show(); }} Colored by Color Scriptercs