subinto의 개발노트

 window.onload = function () {
  var aArr = document.getElementsByTagName("A");
  for(var i = 0 ; i < aArr.length ; i++){
   aArr[i].addEventListener("click", function(){
    aClick(this.href);
   });
  }
 }

SELECT 
            '메뉴ID' AS MENU_ID
          , 'NO' AS NO
          , '1 Depth' AS DEPTH_1
          , '2 Depth' AS DEPTH_2
          , '3 Depth' AS DEPTH_3
          , '4 Depth' AS DEPTH_4
          , '5 Depth' AS DEPTH_5
          , 'Url' AS MENU_URL
          , (SELECT USER_GROUP_NM FROM TB_USER_GROUP WHERE USER_GROUP_ID = '001') AS GROUP_001
          , (SELECT USER_GROUP_NM FROM TB_USER_GROUP WHERE USER_GROUP_ID = '002') AS GROUP_002
          , (SELECT USER_GROUP_NM FROM TB_USER_GROUP WHERE USER_GROUP_ID = '003') AS GROUP_003
          , (SELECT USER_GROUP_NM FROM TB_USER_GROUP WHERE USER_GROUP_ID = '004') AS GROUP_004
FROM DUAL
UNION ALL
SELECT
            A.MENU_ID
          , ROWNUM||'' AS NO
          , CASE WHEN A.MENU_LEVEL = '1' THEN A.MENU_NAME ELSE NULL END AS DEPTH_1
          , CASE WHEN A.MENU_LEVEL = '2' THEN A.MENU_NAME ELSE NULL END AS DEPTH_2
          , CASE WHEN A.MENU_LEVEL = '3' THEN A.MENU_NAME ELSE NULL END AS DEPTH_3
          , CASE WHEN A.MENU_LEVEL = '4' THEN A.MENU_NAME ELSE NULL END AS DEPTH_4
          , CASE WHEN A.MENU_LEVEL = '5' THEN A.MENU_NAME ELSE NULL END AS DEPTH_5
          , A.MENU_URL
          , GROUP_001
          , GROUP_002
          , GROUP_003
          , GROUP_004
FROM TB_MENU_INFO A
        , (
            WITH TUG AS (
                SELECT USER_GROUP_ID
                  FROM TB_USR_GRP
                WHERE USE_AT = 'Y'
            )
            SELECT
                        MENU_ID
                      , MAX(CASE WHEN GROUP_001 = USER_GROUP_ID THEN 'O' ELSE NULL END)  AS GROUP_001
                      , MAX(CASE WHEN GROUP_002 = USER_GROUP_ID THEN 'O' ELSE NULL END)  AS GROUP_002
                      , MAX(CASE WHEN GROUP_003 = USER_GROUP_ID THEN 'O' ELSE NULL END)  AS GROUP_003
                      , MAX(CASE WHEN GROUP_004 = USER_GROUP_ID THEN 'O' ELSE NULL END)  AS GROUP_004
              FROM TUG
              PIVOT(MAX(USER_GROUP_ID) FOR USER_GROUP_ID IN ('001' AS GROUP_001, '002' AS GROUP_002, '003' AS GROUP_003, '004' AS GROUP_004) )
                    , TB_GRP_MENU TGM
            WHERE TGM.USE_AT = 'Y'
            GROUP BY MENU_ID
          ) B
WHERE A.USE_YN = 'Y'
AND A.DEL_YN = 'N'
AND A.MENU_ID = B.MENU_ID
START WITH A.MENU_UPPER_ID IS NULL
CONNECT BY PRIOR A.MENU_ID = A.MENU_UPPER_ID

@Controller
public class PortalController extends BaseController{

@RequestMapping("/list.do")
 public String doList(@ModelAttribute("listVO")ListVO vo, HttpServletRequest request,
   RedirectAttributes redirectAttributes) throws Exception{

   redirectAttributes.addFlashAttribute("rMsg", "완료되었습니다.");
  return "redirect:/view.do";
 }

}

<mvc:annotation-driven />

import java.io.File;

import org.terracotta.agent.repkg.de.schlichtherle.io.FileOutputStream;

import com.itextpdf.text.Document;
import com.itextpdf.text.pdf.PdfPTable;
import com.itextpdf.text.pdf.PdfWriter;

public class TestPdfCreate {

 public void pdfCreate() throws Exception {
  String[] nameArr = {"Mr.Lee", "Mr.Kim", "Mr.Bae", "Mr.Hong"};
  String[] ageArr = {"41", "25", "16", "30"};
  String fileName = "";
  String dir = "E:/Test/Pdf";
  fileName = "testFile.pdf";
  
  File directory = new File(dir);
  if(!directory.exists()) directory.mkdirs();
  File file = new File(dir+"/"+fileName);
  file.createNewFile();
  
  Document document = new Document();
  FileOutputStream fos = new FileOutputStream(file);
  PdfWriter.getInstance(document, fos);
  
  document.open();
  PdfPTable table = new PdfPTable(2);
  
  for(int i = 0 ; i < nameArr.length ; i++){
   table.addCell("name : " + nameArr[i]);
   table.addCell("age : " + ageArr[i]);
  }
  
  document.add(table);
  document.close();
 }
 
 public static void main(String[] args) {
  try {
   TestPdfCreate pbv = new TestPdfCreate();
   pbv.pdfCreate();
   System.out.println("file success");
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
}

SELECT
            LAG(A.MENU_ID) OVER(ORDER BY A.MENU_ID ASC) AS PRE_MENU_ID --이전 메뉴ID
          , A.MENU_ID --현재 메뉴ID
          , LEAD(A.MENU_ID) OVER(ORDER BY A.MENU_ID ASC) AS NEXT_MENU_ID --다음 메뉴ID
FROM TB_SF_MENU_INFO A
ORDER BY MENU_ID ASC

--다중 LIKE 검색(오라클 10g부터 가능)

SELECT  * 
  FROM TB_MENU_INFO 
 WHERE  REGEXP_LIKE(MENU_NM, '참여업체|수집안내|메뉴정보')
 
--세번째 변수에 'i'를 추가하면 대소문자 구분하지 않고 검색
SELECT  * 
  FROM TB_MENU_INFO 
 WHERE  REGEXP_LIKE(MENU_URL, 'MYPAGE|user', 'i')

--시작하는 문자가 "전 or 지 or 스 or 마" 로 시작하는 데이터 검색
SELECT  * 
  FROM TB_MENU_INFO 
 WHERE  REGEXP_LIKE(MENU_NM, '^[전지스마]')
 
--"분석"으로 끝나는 데이터 검색
SELECT  * 
  FROM TB_MENU_INFO 
 WHERE  REGEXP_LIKE(MENU_NM, '분석$')

SELECT
ORA_ROWSCN AS SCN
, TO_CHAR(SCN_TO_TIMESTAMP(ORA_ROWSCN),'YYYY-MM-DD HH24:MI:SS') AS TM
, MENU_ID
FROM TB_MENU_INFO;

SELECT  * 
  FROM TB_MENU_INFO  AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '10' MINUTE) 
 WHERE  MENU_ID LIKE 'SC_%'

--특정 날짜 시간 데이터 조회
SELECT  * 
  FROM TB_MENU_INFO  AS OF TIMESTAMP(TO_TIMESTAMP('2018-11-12 08:30:10', 'YYYY-MM-DD HH24:MI:SS')) 
 WHERE  MENU_ID LIKE 'SC_%'

/*
 * MENU_ID가 PK임
 * MENU_CATE데이터가 'B', 'I', 'P' 인것의 MENU_TYPE별 개수 구하기
 */
WITH PV AS (
    SELECT MENU_ID
              , MENU_CATE
              , MENU_TYPE
      FROM TB_SF_MENU_INFO
)
SELECT *
  FROM PV
  PIVOT(COUNT(MENU_ID) FOR MENU_TYPE IN ('B' AS TYPE_B, 'I' AS TYPE_I, 'P' AS TYPE_P));

--Oracle version : 11g
SELECT LISTAGG(CODE, ',') WITHIN GROUP(ORDER BY CODE DESC) AS PLUS_COLUMN 
  FROM COM_CODE
WHERE ROWNUM < 5;

--Oracle version : 9i
SELECT SUBSTR(XMLAGG(XMLELEMENT(X, ',', CODE) ORDER BY CODE).EXTRACT('//text()'), 2) AS PLUS_COLUMN
  FROM COM_CODE
WHERE ROWNUM < 5;

--캐릭터셋 조회
SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

--CONVERT( '대상 문자열', '타겟 인코딩', '소스 인코딩')
SELECT COMMENTS
          , CONVERT(COMMENTS, 'AL32UTF8', 'KO16KSC5601') AS COMMENTS_CONVERT
    FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'COM_CODE';

--1시간전
SELECT * FROM TABLE_NAME AS OF TIMESTAMP((SYSDATE-1/24));

--특정시간
SELECT * FROM TABLE_NAME AS OF TIMESTAMP(TO_DATE('20181101140000', 'YYYYMMDDHH24MISS'));

SELECT * FROM v$version WHERE banner LIKE 'Oracle%';

<button type="button" class="btn btn-azure btn-sm btn-scroll btn-scroll-top ti-bookmark addScrap" data-type="customChart">
    <span>스크랩</span>
</button>
<!-- Modal -->
<div id="memoDialogModal" title="메모저장">
 <div>
  <textarea name="memo" id="memo" rows="5" cols="50">Test Memo</textarea>
  <button class="addScrapSave" data-type="customChart">저장</button>
 </div>
</div>

  $('.addScrap').on('click', function(){
   $('#memo').text('');
   $( "#memoDialogModal" ).dialog({
      resizable: false,
      height: 300,
      width: 500,
      modal: true,
      buttons: {
     "닫기": function() {
        $( this ).dialog( "close" );
     }
      }
    });
  });
  
  $('.addScrapSave').on('click', function(){
   var scrapUrl = window.location.pathname;
   var scrapParam = $('form[name=searchFrm]').serialize();
   var titleName =$('.mainTitle').text().trim();
   var subTitle = $('#tab-nav ul li') ? $('#tab-nav ul li.active-cr').text().trim() : '';
   var scrapAction = $(this).attr('data-type');
   var memo = $('#memo').text();

   if(subTitle)
    titleName += "-" + subTitle;

   var param = {scrapName : titleName, scrapUrl : scrapUrl, scrapParam : scrapParam, scrapAction : scrapAction , memo : memo};
   var url = '/myPage//addScrapAjax.do';

   $.ajaxSubmit(url, param, function(data){
    if(data.result){
     alert("스크랩 되었습니다.");
     $( "#memoDialogModal" ).dialog( "close" );
    }
    else
     alert("에러가 발생하였습니다.");
   });
  });

package com.collabi.red.sys.openapi.test;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.io.UnsupportedEncodingException;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;
import java.net.URLConnection;
import java.net.URLEncoder;
import java.nio.charset.Charset;
import java.util.Map;
import java.util.concurrent.ConcurrentHashMap;

import org.apache.commons.lang.builder.ToStringBuilder;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.collabi.red.ext.common.utils.StringUtil;

import net.sf.json.JSONObject;

public class OpenApiTest {

 private static final Logger logger = LoggerFactory.getLogger(OpenApiTest.class);

 public OpenApiTest() {

 }

 public Map<String, Object> setParamMap() {
  Map<String, Object> dataMap = new ConcurrentHashMap<String, Object>();
  dataMap.put("PARAM1", "APPLE");
  dataMap.put("PARAM2", "WOOD");
  return dataMap;
 }

 public void callApiCommon() {
  String defUrl = "subinto.test.com";
  String encodType = "UTF-8";
  StringBuffer sb = new StringBuffer();
  sb.append(defUrl);
  Map<String, Object> dataMap = this.setParamMap();
  this.getRedundancyInterLook(sb.toString(), this.setParamMapToJson(dataMap), encodType);
 }

 public String setParamMapToJson(Map<String, Object> dataMap) {
  JSONObject jsonParam = new JSONObject();
  jsonParam.putAll(dataMap);
  StringBuffer sbEqParam = new StringBuffer();
  try {
   sbEqParam.append("paramData=").append(URLEncoder.encode(jsonParam.toString().replaceAll("%", "%25"), "UTF-8"));
  } catch (UnsupportedEncodingException e) {
   logger.error(e.getMessage());
  }
  return sbEqParam.toString();
 }

 private void getRedundancyInterLook(String interLookUrl, String urlParameters, String encodType) {
  System.out.println("############################ : URL " + interLookUrl);
  System.out.println("############################ : urlParameters " + urlParameters);
  JSONObject jsonObj = this.concertFromHTTPtoJSON(interLookUrl, urlParameters, encodType);
  System.out.println(" :::::::::: interLookUrl : " + interLookUrl);
  System.out.println(" :::::::::: viewType   : " + encodType);
  System.out.println(" :::::::::: jsonObj   : " + ToStringBuilder.reflectionToString(jsonObj));
 }

 private JSONObject concertFromHTTPtoJSON(String xmlUrl, String urlParameters, String encodType) {
  URL url = null;
  HttpURLConnection httpUrlConnection = null;
  BufferedWriter bw = null;
  InputStream is = null;
  JSONObject jsonObj = null;

  try {
   url = new URL(xmlUrl);
   URLConnection urlConnection = url.openConnection();
   httpUrlConnection = (HttpURLConnection) urlConnection;

   String postData = urlParameters;

   httpUrlConnection.setDoInput(true);
   httpUrlConnection.setDoOutput(true);
   httpUrlConnection.setRequestMethod("POST");
   httpUrlConnection.setUseCaches(false);
   httpUrlConnection.setDefaultUseCaches(false);
   httpUrlConnection.setRequestProperty("Content-Length", "0");
   httpUrlConnection.setRequestProperty("Content-Language", encodType);

   bw = new BufferedWriter(new OutputStreamWriter(httpUrlConnection.getOutputStream(), "UTF-8"));
   bw.write(postData);
   bw.flush();

   is = httpUrlConnection.getInputStream();

   BufferedReader rd = new BufferedReader(new InputStreamReader(is, Charset.forName("UTF-8")));
   String jsonText = this.readAll(rd);
   jsonObj = JSONObject.fromObject(StringUtil.converterDecoding(jsonText, encodType));

   bw.close();
   is.close();
   is = null;
  } catch (MalformedURLException e) {
   logger.error(e.getMessage());
  } catch (IOException e) {
   logger.error(e.getMessage());
  } finally {

   if (httpUrlConnection != null)
    try {
     httpUrlConnection.disconnect();
     httpUrlConnection = null;
    } catch (Exception e) {
     logger.error(e.getMessage());
    }

   if (bw != null)
    try {
     bw.close();
    } catch (Exception e) {
     logger.error(e.getMessage());
    }

   if (is != null)
    try {
     is.close();
     is = null;
    } catch (Exception e) {
     logger.error(e.getMessage());
    }
  }

  return jsonObj;
 }

 private String readAll(BufferedReader rd) throws IOException {
  StringBuilder sb = new StringBuilder();

  String inputStr;
  while ((inputStr = rd.readLine()) != null) {
   sb.append(inputStr);
  }

  return sb.toString();
 }

 public static void main(String[] args) {
  new OpenApiTest().callApiCommon();
 }

}