::: newtype의 지식창고 :::

 




 


   

     

        
    
   
   

     
    
          필링 CVS Commit 목록
   
   

     

         
   
 
 
 


	

 		
 시작일
		

			 
		
		
 종료일
		

			 
		
	
	

		
 User ID
		

			  
			
		
	
	

		
 프로젝트
		

			 
			
		
	
	

		
 기타 옵션
		

			
                        중복 문서 제거
		
 
		

			
			  
			
		
 	

 



 

<%@page import="WDMS.Common.ConvUtil"%>
<%@ page language="java" contentType="text/html;charset=euc-kr"  import="java.sql.*" %>
<%
	// 연결 정보
	String ORA_IP = "ORACLE_ID";
	String ORA_SID= "ORACLE_SID";
	String ORA_USER= "ORACLE_USER";
	String ORA_PWD= "ORACLE_PWD";

	Connection conn = null;
	PreparedStatement pstmt = null;
	ResultSet rs = null;
	ResultSetMetaData rsmd = null;
    
	int i;
    
	String strData ="";
	int nCol=0;
	int nRow=0;
	int numIndex =1;
	StringBuffer szQuery = new StringBuffer();
    
	String method=ConvUtil.nullToSpace(request.getParameter("method"));
	String start_date=ConvUtil.nullToSpace(request.getParameter("start_date"));
	String end_date=ConvUtil.nullToSpace(request.getParameter("end_date"));
	String user_id=ConvUtil.nullToSpace(request.getParameter("user_id"));
	String project=ConvUtil.nullToSpace(request.getParameter("project"));
	String distinct=ConvUtil.nullToSpace(request.getParameter("distinct"));

	if ( method.equals("GetUserID") )  {
		szQuery.append("SELECT DISTINCT USERID FROM CVS_COMMIT");
	} else if (method.equals("GetProject")) {
		szQuery.append("SELECT DISTINCT PROJECT FROM CVS_COMMIT");
	} else if (method.equals("GetCvs")) {
		if(distinct.equals("0")){
			szQuery.append("SELECT USERID, ");
			szQuery.append("TO_CHAR(REG_DATE, 'YYYY-MM-DD hh24:mi:ss') REG_DATE,)";
			szQuery.append("PROJECT,FILENAME FROM CVS_COMMIT");
		}else{
			szQuery.append("SELECT DISTINCT FILENAME FROM CVS_COMMIT");
		}
		
		if(start_date.equals("")&&end_date.equals("")){
			if(!user_id.equals("All")&&!project.equals("All") ){
				szQuery.append(" where USERID=? AND PROJECT=?");
			}else if(!user_id.equals("All")&&project.equals("All") ){
				szQuery.append(" where USERID=?");
			}else if(user_id.equals("All")&&!project.equals("All") ){
				szQuery.append(" where PROJECT=?");
			}
		
			if(distinct.equals("0")){
				szQuery.append(" order by REG_DATE");
			}
		}else{
			if(!user_id.equals("All")&&!project.equals("All") ){
				szQuery.append(" where USERID=? AND PROJECT=?");
			}else if(!user_id.equals("All")&&project.equals("All") ){
				szQuery.append(" where USERID=?");
			}else if(user_id.equals("All")&&!project.equals("All") ){
				szQuery.append(" where PROJECT=?");
			}else{
					szQuery.append(" where 1=1");
			}
			
			if(!start_date.equals("")&&end_date.equals("")){
				szQuery.append(" and REG_DATE BETWEEN ? AND SYSDATE");	
			}else if(!start_date.equals("")&&!end_date.equals("")){
				szQuery.append(" and TO_CHAR(reg_date, 'YYYY/MM/DDHH24:MI') ");
				szQuery.append("BETWEEN ? AND ?");
			}
			
			if(distinct.equals("0")){
				szQuery.append(" order by REG_DATE");	
			}
		}
	}else if (method.equals("")) {
			out.println("Unkwon method!!");
		return;
	}

	try {
     
        //1.드라이버선택
        Class.forName("oracle.jdbc.driver.OracleDriver");
        
        //2.db연결
        conn = DriverManager.getConnection("jdbc:oracle:thin:@"
                     +ORA_IP+":1521:"+ORA_SID, ORA_USER, ORA_PWD);
        
        //3.Statement객체및 쿼리생성
        pstmt = conn.prepareStatement(szQuery.toString());
        if(method.equals("GetCvs")){
        	if(start_date.equals("")&&end_date.equals("")){
	        	if( !user_id.equals("All") && !project.equals("All") ) {
		        	pstmt.setString(numIndex++,user_id);
		        	pstmt.setString(numIndex,project);
	        	} else if(!user_id.equals("All")&&project.equals("All") ){
	        		pstmt.setString(numIndex,user_id);
	        	} else if(user_id.equals("All")&&!project.equals("All") ){
	        		pstmt.setString(numIndex,project);
	        	} else{
	        		if(!start_date.equals("")&&end_date.equals("")) {
	        			pstmt.setString(numIndex,start_date);
	        			} else if(!start_date.equals("")&&!end_date.equals("")){
	        				pstmt.setString(numIndex++,start_date+"00:00");
	        				pstmt.setString(numIndex,end_date+"23:59");
	        			}
				}
        	}else{
        		if(!user_id.equals("All")&&!project.equals("All") ){
                	pstmt.setString(numIndex++,user_id);
                	pstmt.setString(numIndex++,project);
                	}else if(!user_id.equals("All")&&project.equals("All") ){
                		pstmt.setString(numIndex++,user_id);
                	}else if(user_id.equals("All")&&!project.equals("All") ){
                		pstmt.setString(numIndex++,project);
                	}
        		//
        		if(!start_date.equals("")&&end_date.equals("")){
        			pstmt.setString(numIndex,start_date);
       			}else if(!start_date.equals("")&&!end_date.equals("")){
       				pstmt.setString(numIndex++,start_date+"00:00");
       				pstmt.setString(numIndex,end_date+"23:59");
       			}
	        }
        }
        
        //4.실행
        rs = pstmt.executeQuery();
        
        //5.처리
            // 헤더 
        rsmd = rs.getMetaData();
        nCol = rsmd.getColumnCount();
        strData = "{\n\t\"title\": \"Feelring CVS Commit Log\",\n\t\"item\": [\n\t\t";
            
            // 데이타
        while(rs.next())
        {
            strData += "\t{\n\t\t";
        
            for(i=1; i<=nCol; i++)
            {
                strData += "\"" + rsmd.getColumnName(i) 
                            + "\" : \"" + rs.getString(i) + "\",";
            }
            strData = strData.substring(0, strData.length() -1 );
            
            strData += "\n\t},\n";
            nRow++;
        }
        rs.close();
        
        strData = strData.substring(0, strData.length() -2 );
        strData += "\t]\n}";
        
        out.println(strData);
        
        //6.연결해제
        pstmt.close();
        conn.close();
        
    } catch (Exception e) {
    
        if(rs!=null){ try{rs.close();}catch(SQLException se){} }
        if(pstmt!=null){ try{pstmt.close();}catch(SQLException se){} }
        if(conn != null){ try{conn.close();} catch(SQLException se){}} 
        out.println(e);
        
    }

%>

<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>
    	인생을 하루로 계산하면...
    </title>
    <script src="../lib/jquery.js" type="text/javascript"></script>
    <script src="../lib/common.js" type="text/javascript"></script>
    <script>
        $(document).ready(function(){
			function d2d(d) {
				var g=80*365/(24*60);
				var h=Math.floor(d/g/60);
				var m=Math.ceil((d/g)-(h*60));
				var am;
				if(m==60) {h++; m=0;}
				m=(m==0)?"정각":(m+"분");
				am=(h<12)?"오전 ":"오후 ";
				h=(h>12)?(h-12):h;
				$("#result").html("당신의 인생 시간은 <span class='dt'>"
					+am+h+"시 "+m+"</span> 입니다.");
			}

			function doDay() {
				var y=$("#year").attr("value");
				var m=$("#month").attr("value");
				var d=$("#day").attr("value");
				
				if(y<1800){$("#result").text("태어난 해가 올바르지 않습니다."); return;}
				if(m<1||m>12)
					{$("#result").text("태어난 달이 올바르지 않습니다."); return;}
				if(d<1||d>31)
					{$("#result").text("태어난 날이 올바르지 않습니다."); return;}

				var b=new Date(y,m-1,d);
				var t=new Date();
				var diff=Math.ceil((t.getTime()-b.getTime())/1000/60/60/24);

				if(diff>(80*365)){$("#result").text("다음 생을 기약해요..."); return;}
				d2d(diff);
			}
		
			$("input[type=button]").click(doDay);
			$("input[type=text]").keyup(function(e){
				if(e.keyCode==13) doDay();
			});
		});
    </script>
    <style type="text/css">
         * { font-family:돋움 }
		.dt { font-weight:bold; font-color=blue }
		.cp { font-size:9pt; color=gray }
    </style>
</head>
<body>
	<h2>인생을 하루로 표현 하면..</h2>
	<p>
	    생일을 입력하세요 : <input type="text" id="year" size=4 />년 
		<input type="text" id="month" size=2 />월
		<input type="text" id="day" size=2 />일 생입니다. 
	    <input type="button" value="계산"/>
	</p>
	<span id="result"></span>
	<br/><br/><br/><br/><br/>
	<span class="cp">by <a href="http://newtype.pe.kr">newtype</a></span>
</body>
</html>