Posts

Showing posts from September, 2015

youtube download

Image
https://www.youtube.com/watch?v=6jKqov6_zww ========================================================================= https:// ss youtube.com/watch?v=6jKqov6_zww http://www.clipconverter.cc/ http://en.savefrom.net/
Read more

case when then

Image
--DROP TABLE BUILDING_MANAGER; CREATE TABLE BUILDING_MANAGER    (BUILDING_NO1 VARCHAR2(3) NOT NULL ENABLE,   BUILDING_NO2 VARCHAR2(5) NOT NULL ENABLE,   MANAGER_NAME VARCHAR2(30) NOT NULL ENABLE,   SAFE_APPOINT_DE VARCHAR2(8) NOT NULL ENABLE,   SAFE_LICENSE_NO VARCHAR2(30),   REGIST_DT DATE NOT NULL ENABLE,  CONSTRAINT PK_BULDING_MANAGER PRIMARY KEY (BUILDING_NO1, BUILDING_NO2, SAFE_LICENSE_NO)  );  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('100','200','lisa','20150923','00100123F',sysdate);  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('100','875','tyra','20150722','00109921I',sysdate);  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('315','123','emma'
Read more

group by having

Image
--DROP TABLE BUILDING_MANAGER; CREATE TABLE BUILDING_MANAGER    (BUILDING_NO1 VARCHAR2(3) NOT NULL ENABLE,   BUILDING_NO2 VARCHAR2(5) NOT NULL ENABLE,   MANAGER_NAME VARCHAR2(30) NOT NULL ENABLE,   SAFE_APPOINT_DE VARCHAR2(8) NOT NULL ENABLE,   SAFE_LICENSE_NO VARCHAR2(30),   REGIST_DT DATE NOT NULL ENABLE,  CONSTRAINT PK_BULDING_MANAGER PRIMARY KEY (BUILDING_NO1, BUILDING_NO2, SAFE_LICENSE_NO)  );  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('100','200','lisa','20150923','00100123F',sysdate);  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('100','875','tyra','20150722','00109921I',sysdate);  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('315','123','emma'
Read more

dispatcher-servlet.xml egovframework

<?xml version="1.0" encoding="UTF-8"?> <!--     - DispatcherServlet application context for Application's web tier. --> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context"         xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd                 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd">     <!--         - The controllers are autodetected POJOs labeled with the @Controller annotation.     -->     <context:component-scan base-package="kr">         <context:include-filter type="annotation" expression="org.springframework.stereotyp
Read more

web.xml egovframework

<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"> <display-name>ask</display-name> <filter> <filter-name>httpsCookieFilter</filter-name> <filter-class> kr.com.htt.cmm.HttpsCookieFilter </filter-class> </filter> <filter-mapping> <filter-name>httpsCookieFilter</filter-name> <url-pattern>*.do</url-pattern> </filter-mapping> <filter-mapping> <filter-name>httpsCookieFilter</filter-name> <url-pattern>*.jsp</url-pattern> </filter-mapping> <filter> <filter-name>encodingFilter</filter-name> <filter-class> org.springframework.web.filter.CharacterEncodingFilter </filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf-8</param-value> </init-pa
Read more

rank() oracle

Image
--DROP TABLE BUILDING_MANAGER; CREATE TABLE BUILDING_MANAGER    (BUILDING_NO1 VARCHAR2(3) NOT NULL ENABLE,   BUILDING_NO2 VARCHAR2(5) NOT NULL ENABLE,   MANAGER_NAME VARCHAR2(30) NOT NULL ENABLE,   SAFE_APPOINT_DE VARCHAR2(8) NOT NULL ENABLE,   SAFE_LICENSE_NO VARCHAR2(30),   REGIST_DT DATE NOT NULL ENABLE,  CONSTRAINT PK_BULDING_MANAGER PRIMARY KEY (BUILDING_NO1, BUILDING_NO2, SAFE_LICENSE_NO)  );  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('100','200','lisa','20150923','00100123F',sysdate);  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('100','875','tyra','20150722','00109921I',sysdate);  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('315','123','emma'
Read more

row_number() oracle

Image
--DROP TABLE BUILDING_MANAGER; CREATE TABLE BUILDING_MANAGER    (BUILDING_NO1 VARCHAR2(3) NOT NULL ENABLE,   BUILDING_NO2 VARCHAR2(5) NOT NULL ENABLE,   MANAGER_NAME VARCHAR2(30) NOT NULL ENABLE,   SAFE_APPOINT_DE VARCHAR2(8) NOT NULL ENABLE,   SAFE_LICENSE_NO VARCHAR2(30),   REGIST_DT DATE NOT NULL ENABLE,  CONSTRAINT PK_BULDING_MANAGER PRIMARY KEY (BUILDING_NO1, BUILDING_NO2, SAFE_LICENSE_NO)  );  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('100','200','lisa','20150923','00100123F',sysdate);  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('100','875','tyra','20150722','00109921I',sysdate);  INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('315','123','emma'
Read more

index

create CREATE INDEX index_mnt_cp_cd ON BUILDING_MANAGER(mnt_cp_cd); CREATE INDEX index_SUBCNTR_CP_CD ON BUILDING_MANAGER(SUBCNTR_CP_CD);
Read more

javascript 한번만 클릭 체크

var flag = false; function fn_excel(noData){ if ( flag!=true ) { flag = true; document.Form.action = "<c:url value='#'/>"; document.Form.submit(); }else { alert("이미 실행중입니다."); } }
Read more

Create a sql query to excel

Image
--------------------------------------------------------------------------------------------------- ="UPDATE TB_SK_USER SET NAME='"&A2&"',EMAIL='"&B2&"' WHERE USER_ID = '"&C2&"'"
Read more

tomcat memory permsize

Image
open launch configuration > arguments tab > VM arguments --------------------------------------------------------------------------------------------------- -Dcatalina.base="D:\KESI\KESISRC\.metadata\.plugins\org.eclipse.wst.server.core\tmp0" -Dcatalina.home="D:\KESI\apache-tomcat-6.0.32" -Dwtp.deploy="D:\KESI\KESISRC\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps" -Djava.endorsed.dirs="D:\KESI\apache-tomcat-6.0.32\endorsed" -Xms512m -Xmx512m -XX:NewSize=256m -XX:MaxNewSize=256m -XX:PermSize=256m -XX:MaxPermSize=256m -XX:NewRatio=2 -XX:SurvivorRatio=5 -XX:ReservedCodeCacheSize=256m -XX:+DisableExplicitGC -XX:+UseConcMarkSweepGC -XX:+AggressiveOpts -Djava.net.preferIPv4Stack=true -Djava.awt.headless=true -Begin                                                                 -After   
Read more

Error creating bean with name 'exceptionTransfer' defined in file

Image
1.server clean 2. project clean 소스 수정한것도 없는데 잘 되다가 에러를 뿜는다. server, project clean 하니 잘 된다.
Read more

Jsp calculation

 ${100 + 300 }  <br /> ${100 - 300 }  <br /> ${100 * 300 }  <br /> ${100 / 300 }  <br /> ${100 div 300 }  <br /> ${100 % 300 }  <br /> ${100 mod 300 }  <hr />  ${100 == 200 }  <br /> ${100 eq 200 }  <br /> ${100 ne 200 }  <br /> ${100 != 200 }  <br /> ${100 lt 200 }  <br /> ${100 < 200 }  <br /> ${100 gt 200 }  <br /> ${100 > 200 }  <br /> ${100 le 200 }  <br /> ${100 <= 200 }  <br /> ${100 ge 200 }  <br /> ${100 >= 200 } ${true && false }  <br /> ${true || false }  <br /> ${true or false }  <br /> ${true and false }  <br /> ${not true}  <br /> ${!true}  <hr /> --------------------------------------------------------------------------------- <td scope="col" style="text-align:right;padding-right: 5px;">       <fmt:formatNumber value="${32/111111*100}" type="percent"  pattern=&q
Read more

quote symbol expected

quote symbol expected ------------------------------------------------- <tr> <td scope="col" style="text-align:right;padding-right: 5px;">2015년 6월</td> <td scope="col" style="text-align:right;padding-right: 5px;"><fmt:formatNumber value=11111 pattern="#,###"/></td> <td scope="col" style="text-align:right;padding-right: 5px;"><fmt:formatNumber value="32" pattern="#,###"/></td> <td scope="col" style="text-align:right;padding-right: 5px;"><fmt:formatNumber value="${32/ 11111*100}" type="percent"  pattern="0.0000"/>%</td> </tr> value 부분에 따옴표(")가 빠져서 난 에러
Read more

Binary search algorithm

Image
Binary search algorithm  wikipedia : https://en.wikipedia.org/wiki/Binary_search_algorithm public class binarySearch {  public static void main(String[] args){   Scanner in = new Scanner(System.in);     int[] quest = {1,5,6,9,12,17,20,29,38,60,61,68,81,90,95,99};   for( int i : quest){  System.out.print(i+" ");   }   System.out.print("\nkey? : ");   int answer = in.nextInt();   System.out.print("result : "+search(quest, answer,0, quest.length)+" ");  }  public static int search(int[] quest, int key, int min, int max){   if(min > max) return -1;   int mid = (min +max)/2;   if(key==quest[mid])    return mid+1;   else if(key>quest[mid])    return search(quest, key, mid+1,max);   else if(key<quest[mid])    return search(quest, key, min, mid-1);   else    return -1;  } }//class ----------------------------------------------------------------------------------------------- result :  1 5 6 9 12 17 20 29 38 60 61 68 81 90 95 99  key? : 61 resu
Read more

전자정부 프레임워크 서비스단

Controller.java --------------------------------------------------------------------------------------------- @Controller public class NationController { @Resource(name = "NationService") private NationService nationService; @RequestMapping(value="/test/ChkFind .do") public String chkfindresult (HttpServletRequest request, Model model) throws Exception { List<EgovMap> statList = null; try{ statList = (List<EgovMap>)  nationService.getStatFindList(); }catch(Exception e){ } } } NationService.java --------------------------------------------------------------------------------------------- public interface NationService { public List<?> getStatFindList() throws Exception; } NationServiceImpl.java --------------------------------------------------------------------------------------------- @Service("NationService") public class NationServiceImpl implements NationService { @Resource(name = "NationDAO") priva
Read more

HashSet Class

Image
public static void main(String[] args){ String[] tropical = new String[]{"사과", "배", "참외", "포도","사과", "바나나", "키위", "포도","귤", "바나나", "오렌지","포도"}; // Tropical 과일 12개 넣기 System.out.println("map size : "+getTropical(tropical)); } public static int getTropical(String[] tropical){ if(tropical==null) return 0;         if(tropical.length==1) return 1;   HashSet<String> hash= new HashSet<String>(); for(String tmp : tropical){     hash.add(tmp);       } printTropical(hash);   return hash.size();     } public static void printTropical(HashSet<String> hash){ for(String tmp :  hash){                             System.out.print(tmp+" / ");                     } System.out.println(); } ------------------------------------------------------------------------ result : 배 / 키위 / 사과 / 참외 / 포도 / 귤 / 바나나 / 오렌지 / m
Read more

TreeMap Class

public static void main(String[] args){    TreeMap<String, String> test = new TreeMap();     test.put("A","1" );     test.put("a","1" );     test.put("가","1" );     test.put("b","1" );     test.put("c","1" );     test.put("1","1" );     test.put("9","1" );     System.out.println(test.entrySet()); //     System.out.println("------------------------------");     Set<Entry<String, String>> Ttest = test.entrySet();     for(Entry tmp : Ttest){              System.out.print(","+tmp.getKey()+" = "+tmp.getValue()+"\t"); // 키와 값 확인     }//for     System.out.println();       System.out.println("------------------------------");     System.out.println(test.firstKey()); // 맨 앞에 키     System.out.println(test.lastKey());  // 맨 뒤의 키  
Read more

javascript HashMap

<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> <script type="text/javaScript" language="javascript" defer="defer"> var oMap = function(){ this.map = new Object(); } oMap.prototype = {         put: function (key, value) {this.map[key] = value;}, // key, value 값으로 구성된 데이터를 추가     get: function (key) {return this.map[key];}, // 지정한 key값의 value값 반환     containsKey: function (key) { return key in this.map;}, // 구성된 key 값 존재여부 반환     remove: function (key) {delete this.map[key];}, //  key에 해당하는 데이터 삭제     containsValue: function (value) { // 구성된 value 값 존재여부 반환         for (var prop in
Read more

google Blog 상단 네이게이션 바 없애기 (top navigation)

Image
1.템플릿>HTML 편집으로  들어가서 2. ctrl+f 누르고 </head> 검색 후 윗줄에  아래와 같이 추가하면 된다. ------------------------------------------------------ <style type='text/css'>   #navbar {display:none;} </style> 3. 템플릿 저장.
Read more

Oracle error code

ORA-00000 성공적인 정상 종료입니다. ORA-00001 유일성 제약조건(%s.%s)에 위배됩니다. ORA-00017 트레이스 이벤트 설정이 세션에 요구되었습니다. ORA-00018 최대 세션 수를 초과했습니다. ORA-00019 최대 세션 라이선스 수를 초과했습니다. ORA-00020 최대 프로세스 수(%s)를 초과했습니다. ORA-00021 세션이 다른 프로세스에 첨부되어 있음; 세션을 변경할 수 없습니다. ORA-00022 부적절한 세션 번호; 액세스가 거절되었습니다. ORA-00023 세션이 프로세스 고유의 메모리를 참조함; 세션을 분리할 수 없습니다. ORA-00024 단일 프로세스 모드에서는 하나 이상의 프로세스가 로그인할 수 없습니다. ORA-00025 %s에 메모리를 할당하는데 실패했습니다. ORA-00026 누락 혹은 부적합한 세션 번호 ORA-00027 현 세션을 제거할 수 없습니다. ORA-00028 세션이 제거되었습니다. ORA-00029 사용자 세션이 아닙니다. ORA-00030 사용자 세션 ID가 존재하지 않습니다. ORA-00031 세션이 중단될 것입니다. ORA-00032 부적합한 세션 MIGRATION PASSWORD ORA-00033 현세션이 MIGRATION PASSWORD를 갖고있지 않습니다. ORA-00034 PL/SQL 세션에서 %s를 할 수 없습니다. ORA-00035 LICENSE_MAX_USERS가 현재의 사용자 수보다 적을 수 없습니다. ORA-00050 엔큐를 하는 동안 O/S 오류가 발생했음. o/s 오류를 확인하십시오 ORA-00051 자원 대기 중 시간 초과입니다. ORA-00052 최대 엔큐 자원 수(%s)를 초과했습니다. ORA-00053 최대 엔큐 수를 초과했습니다. ORA-00054 자원이 사용중이고, NOWAIT가 지정되어 있습니다. ORA-00055 최대 DML 잠금 수를 초과했습니다. ORA-00056 개체 %s.%s에 대한 DDL 잠금이 비호환 모드로 되어 있습니다. ORA-00057 최
Read more