설악단(설재구)

window 오라클 11g 설치(악단이껀 xp 32bit)

1. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html 
   자신의 pc 에 맞는 파일 다운로드

2. windows(32-bit) file1/file2 다운

Microsoft Windows (32-bit)

File 1, File 2  (2GB)  See All

3. file2 다운받은 폴더에서 (database\stage\Components ) 
  전부복사해서 file1 (database\stage\Components ) ==> 요기로 copy

4. file1 에서 setup 

참조 : http://gseducation.blog.me/20108786501

출처 : kfmes's blog   http://blog.kfmes.com/137

SELECT *
FROM ( SELECT MIN ( CASE WHEN TO_CHAR (dt + LEVEL - 1, 'd') = '1' THEN LEVEL
ELSE NULL END ) AS sun
,MIN ( CASE WHEN TO_CHAR (dt + LEVEL - 1, 'd') = '2' THEN LEVEL
ELSE NULL END ) AS mon
,MIN ( CASE WHEN TO_CHAR (dt + LEVEL - 1, 'd') = '3' THEN LEVEL
ELSE NULL END ) AS tue
,MIN ( CASE WHEN TO_CHAR (dt + LEVEL - 1, 'd') = '4' THEN LEVEL
ELSE NULL END ) AS wed
,MIN ( CASE WHEN TO_CHAR (dt + LEVEL - 1, 'd') = '5' THEN LEVEL
ELSE NULL END ) AS thu
,MIN ( CASE WHEN TO_CHAR (dt + LEVEL - 1, 'd') = '6' THEN LEVEL
ELSE NULL END ) AS fri
,MIN ( CASE WHEN TO_CHAR (dt + LEVEL - 1, 'd') = '7' THEN LEVEL
ELSE NULL END ) AS sat
FROM ( SELECT TO_DATE(200809,'YYYYMM') AS dt
FROM dual) t_dt
CONNECT BY LEVEL <= LAST_DAY (dt) - dt + 1
GROUP BY TRUNC (dt + LEVEL , 'iw')
ORDER BY sat )


출처 http://valenny.tistory.com/entry/오라클-달력-SQL

http://www.nudejava.net/

http://www.java2s.com/Code/Java/CatalogJava.htm

http://www.w3schools.com

IE에서 잘 되던 스크립트가 Firefox에서 안되는 이유 하나
1.document.all ==> document.getElementById("id이름")

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

/*
 * 자바 프로세스 죽이는 기능
 * 
 */
public class SlkJavaProcess {
    public SlkJavaProcess(){}
 
 public static void main(String args[]){
     try{
  new JavaProcess().start();
     }catch (Exception e) {
  System.err.println("Exception " + e);
  System.exit(1);
     }
 }
}

class JavaProcess extends Thread{

    public JavaProcess(){
     System.out.println(" ***************                      ********* ");
            System.out.println(" ***************  JavaProcess  find   ********* ");
            System.out.println(" ***************                      ********* ");
    }

    public void run(){
        System.out.println(" ***************   run  ********* ");
      
        try{
            processKill();
        }catch(Exception e){
            e.printStackTrace();
        }
       
    }

    public void processKill(){
 Process p_start = null;
 Map map = null;
 try {
            System.out.println(" ***************   processKill  start ********* ");
           
            map = new HashMap();
           
            Iterator it = getPid().iterator();
            while(it.hasNext()){
         map = (HashMap) it.next();
  
         String pid = (String)map.get("pid");
         
         //System.out.println(" pid === " + pid);
         p_start = Runtime.getRuntime().exec("kill -9 "+pid);
         Thread.sleep(500);
         p_start.destroy();
         
            }
           
           
            System.out.println(" ***************   processKill  end ********* ");
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    private List getPid(){
        String output = null;
        Process p_start = null;
        String pid = null;
       
        List list = new ArrayList();
        Map map = null;
        try{
            p_start = Runtime.getRuntime().exec("top");
            BufferedReader br = new BufferedReader(new InputStreamReader(p_start.getInputStream()));
           
           
            while ( (output = br.readLine()) != null) {
         System.out.println(output.indexOf("root") + "|"+output.lastIndexOf("java") + "|"+output);
         
         //이부분은
         if((output.indexOf("root") > 0) &&  (output.lastIndexOf("java") > 0)){
             pid = output.substring(0, output.indexOf("root"));
             map = new HashMap();
            
             map.put("pid", pid);
             list.add(map);
         }
         
            }
            p_start.destroy();
           
     
        }catch (Exception e) {
            e.printStackTrace();
 }
        return list;
    }

}

server.xml 에 아래와 같이 추가
<!-- 1 -->
<Context path="/test" docBase="C:\Tomcat\webapps\test" debug="0" reloadable="true">
  <ResourceLink name="jdbc/test" global="jdbc/test" type="javax.sql.DataSource"/>
</Context>

<!-- 2 -->   
<Context path="/test/image" docBase="D:\test\image" debug="0" reloadable="true">
  <ResourceLink name="jdbc/test" global="jdbc/test" type="javax.sql.DataSource"/>
</Context>


1.서비스할 context 디렉토리이고(톰켓홈)
2.이미지 파일을 톰켓홈 디렉토리에 저장하지 않고 , d:test/image 폴더 안에 저장하고 싶을때

윈도우에서 자바프로세스 알아내기.
(예: tomcat 서버 , 자바어플 두개의 프로세스가 있을때 , tomcat 프로세스(PID) 알기)



import java.io.*;
import java.util.StringTokenizer;

public class ProcessList {
  public ProcessList() {
  }
  public static void main(String[] args) {
    try { 
    /*====================================================      
      * 톰켓 프로세스 id 알기  [  start ]
      *===================================================/
      String output = null;
      Process p_start = null;
      p_start = Runtime.getRuntime().exec("tasklist -v");

      BufferedReader stdout = new BufferedReader(new InputStreamReader(p_start.getInputStream()));
     
      StringBuffer sb = null;
      try {
       sb = new StringBuffer();
     while ( (output = stdout.readLine()) != null) {
         System.out.println(output.toLowerCase() + " " +output.startsWith("java.exe") + " " + output.trim().endsWith("Tomcat"));
         
         if(output.toLowerCase().startsWith("java.exe") &&  output.toLowerCase().trim().endsWith("tomcat"))sb.append(output.trim());
         
        }
     p_start.destroy();
     
       System.out.println(" ########################## "); 
       System.out.println(sb.toString());
       System.out.println(" ########################## ");
      
       String str = sb.toString();
       int len = sb.toString().length();
      
       char disData = 'j';
       sb = new StringBuffer();
       for(int i=0; i<len; i++){
        if(str.charAt(i) == '\u0020'){
        if(disData != '#') sb.append("#");
        disData = '#';
       }else{
        sb.append(str.charAt(i));
        disData = str.charAt(i);
       }
       
       }
       System.out.println(sb.toString());
      
       int stCount = 0;
       String pid = null;
       StringTokenizer st = new StringTokenizer(sb.toString() , "#");
       while(st.hasMoreElements()){
        pid = st.nextToken();
        stCount++;
        if(stCount>1)break;
       }
       System.out.println(pid);
       
       /*====================================================      
      * 톰켓 프로세스 id 알기  [  end ]
      *===================================================/

       /*====================================================      
      * 톰켓 콘솔창 죽이기 
      *===================================================/
      p_start = Runtime.getRuntime().exec("tskill "+pid); 
   
       
      }
      catch (IOException e) {
        System.exit(0);
      }
    }
    catch (IOException e1) {
      System.err.println(e1);
      System.exit(1);
    }

  }

}