testdb.java

适应各种系统的项目管理功能

package com.statistics.util;

import java.io.File;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestDB {
	public static void main(String[] args) {
	/*String sql = "select * from project ";	
	
	System.out.println(new SimpleDateFormat("yyyy-mm-dd").format(new Date()));
	String sql1="insert into project(pstart) values("+new SimpleDateFormat("yyyy-mm-dd").format(new Date())+")";
		
		Connection conn = DB.getConn();
		Statement stmt=DB.getStmt(conn);
		ResultSet rs=DB.getRs(stmt, sql);
		try {
			while(rs.next()){
				if(rs.getInt("pfinish")==1){
					System.out.println("true");
				}
				else{
					System.out.println("fault");
				}
				System.out.println(rs.getDate("pstart"));
				
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
		//Statement stmt = DB.getStmt(conn);
		//ResultSet rs = DB.getRs(stmt, sql);
		System.out.println(conn);
			try {
				while(rs.next()) {
					System.out.println(rs.getString(1));
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
	}*/
		 /*Connection conn=null;
		 Statement stmt=null;
		 ResultSet rs=null;
		//String pname="项目1";
		//String person_name="张三";
		  String sql="select ps.person_name,p.pname,m.mname,(ppm.person_end-ppm.person_start) as a,ppm.person_finish " ;
		  sql+="from per_pro_mod ppm ,project p,module m,  person ps where ppm.pid=p.pid and ppm.mid=m.mid and ppm.person_id=ps.person_id and ppm.person_finish=1";
		 
		  if(pname!=""){
		  
		  sql+=" and p.pname='"+pname+"'";
		  }
		  if(person_name!=null){
		  sql+=" and ps.person_name='"+person_name+"'";
		  
		  }*/
		  /*System.out.println(sql);
		 conn=DB.getConn();
		 stmt=DB.getStmt(conn);
		 rs=DB.getRs(stmt,sql);
		 try{
				while(rs.next()){
					//System.out.println(rs.getInt(1))
					System.out.println(rs.getString(1)+","+rs.getString(2)+","+rs.getString(3)+","+rs.getInt(4)+","+rs.getInt(5));			
				}
		 }  catch(SQLException e){}*/
		 /*Connection conn=null;
		 Statement stmt=null;
		 ResultSet rs=null;
		 ResultSet rs1=null;*/
		/*String pname=null;
		String person_name=null;
		String sql = "select ps.person_name,p.pname,m.mname,ppm.person_start,ppm.person_end,ppm.person_finish,ppm.id ";
		String sql1=" from per_pro_mod ppm ,project p,module m,  person ps where ppm.pid=p.pid and ppm.mid=m.mid and ppm.person_id=ps.person_id";
		if (!"".equals(pname) && pname != null) {

			sql1 += " and p.pname='" + pname + "'";
		}
		if (person_name != null && !"".equals(person_name)) {
			sql1 += " and ps.person_name='" + person_name + "'";

		}
		sql=sql+sql1;
		System.out.println(sql);
	    String sql2="select count(*)" +sql1;
	    System.out.println(sql2);
		conn = DB.getConn();
		stmt = DB.getStmt(conn);
		rs = DB.getRs(stmt, sql);
		try {
			rs.last();
			System.out.println(rs.getRow());
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		
		try{
			rs.beforeFirst();
			while(rs.next()){
				System.out.println(rs.getString(1)+","+rs.getString(2)+","+rs.getString(3)+","+rs.getString(4)+","+rs.getString(5)+","+rs.getString(6));
				
			}
	 }  catch(SQLException e){}
		rs1=DB.getRs(stmt,sql2);
		try {
			if(rs1.next()){
			int totalRecords=rs1.getInt(1);
			System.out.println(totalRecords);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}*/
		  /*SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); 
		  java.util.Date now = df.parse("2004-03-26 13:31:40"); 
		  java.util.Date date=df.parse("2004-01-02 11:30:24"); 
		  long l=now.getTime()-date.getTime(); 
		  long day=l/(24*60*60*1000); 
		  long hour=(l/(60*60*1000)-day*24); 
		  long min=((l/(60*1000))-day*24*60-hour*60); 
		  long s=(l/1000-day*24*60*60-hour*60*60-min*60); 
		  System.out.println(""+day+"天"+hour+"小时"+min+"分"+s+"秒"); 
*/
		 /*
		  * 计算时间差
		  */
	/*	 Connection conn=null;
		 Statement stmt=null;
		 ResultSet rs=null;
		 ResultSet rs1=null;
		String pname=null;
		String person_name=null;
		String sql = "select ps.person_name,p.pname,m.mname,ppm.person_start,ppm.person_end,ppm.person_finish,ppm.id ";
		sql+=" from per_pro_mod ppm ,project p,module m,  person ps where ppm.pid=p.pid and ppm.mid=m.mid and ppm.person_id=ps.person_id";
		conn = DB.getConn();
		stmt = DB.getStmt(conn);
		rs = DB.getRs(stmt, sql);
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-mm-dd");
		
		try {
			if(rs.next()){
			Date start=(Date)rs.getDate(4);
			System.out.println(start);
			Date end=(Date)rs.getDate(5);
			System.out.println(end);
			Long diff=end.getTime()-start.getTime();
			long days = diff / (1000 * 60 * 60 * 24); 
			System.out.println(days+"天");

			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}*/
		/*
		 * 
		 * 
		 */
		
		
		
		
	}	 
}