::: 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);
        
    }

%>