djmethod.java

个人办公平台,用JAVA开发的TOMCAT的服务器

package com.skyhawk.control;



import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.skyhawk.db.ConnectionFactory;
import com.skyhawk.db.DatabaseUtils;
import com.skyhawk.user.Depart;
import com.skyhawk.user.Emplyee;
public class Djmethod {
	//把数据库所有用户添加到数组里
	public List getEmplyee(String strSQL){
		List list1=new ArrayList();
		ResultSet rs=null;
		Connection conn=null;
		Statement stmt=null;
        conn=ConnectionFactory.getConnection();
		try {
			stmt=conn.createStatement();
			rs=stmt.executeQuery(strSQL);
			while(rs.next()){
				Emplyee emp=new Emplyee();
				
				emp.setempId(rs.getInt("empid"));
				emp.setdepId(rs.getInt("depid"));
				emp.setdirId(rs.getInt("dirid"));
				emp.setempName(rs.getString("empname"));
				emp.setdeleter(rs.getBoolean("deleter"));
				emp.setpurview(rs.getInt("purview"));
				System.out.println(emp.getempName() );
				list1.add(emp);
			}
		} catch (SQLException e) {
		
			e.printStackTrace();
		}finally{
		DatabaseUtils.closeObject(rs,stmt,conn);
	}
		
		return list1;
		
	}
	public List getDep(String strSQL){
		
		List list1=new ArrayList();
		ResultSet rs=null;
		Connection conn=null;
		Statement stmt=null;		
		conn=ConnectionFactory.getConnection();
		System.out.println(conn);
		
		try {
			
			stmt=conn.createStatement();
			System.out.println(stmt);
			rs=stmt.executeQuery(strSQL);
			System.out.println(rs);
		while(rs.next()){
			    Depart dep=new Depart();
				dep.setDepid(rs.getString("depid"));
			    System.out.println("depid111111:"+dep.getDepid());
				dep.setJuniorid(rs.getString("juniorid"));
				dep.setDepname(rs.getString("depname"));
				list1.add(dep);
			
		}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
		DatabaseUtils.closeObject(rs,stmt,conn);
	}
		
		return list1;
		
	}
	public List getDep1(String strSQL){
		
			List list1=new ArrayList();
			ResultSet rs=null;
			Connection conn=null;
			Statement stmt=null;		
			conn=ConnectionFactory.getConnection();
					
			try {
			
				stmt=conn.createStatement();
				rs=stmt.executeQuery(strSQL);
				Depart dep=new Depart();
			while(rs.next()){
		
					
					dep.setDepid(rs.getString("depid"));
					System.out.println("depid111111:"+dep.getDepid());
					list1.add(dep);

			
			}
			} catch (SQLException e) {
			
				e.printStackTrace();
			}finally{
		DatabaseUtils.closeObject(rs,stmt,conn);
	}
		
			return list1;
		
		}
	//判断时间冲突
	public boolean getTime(Date time,int id){
		boolean n=false;
		ResultSet rs=null;
		Connection conn=null;
		Statement stmt=null;
		conn=ConnectionFactory.getConnection();
		try {
			stmt=conn.createStatement();
			rs=stmt.executeQuery("select endtime from o_agentlist where endtime=to_date('"+time+"','yyyy-mm-dd') and empid='"+id+"'");
			System.out.println(rs);
			//System.out.println(stmt.executeQuery(strSQL));
			if(rs.next()){
				n=true;
				
			}
			else{
				n=false;
				
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
		DatabaseUtils.closeObject(rs,stmt,conn);
	}
		return n;
		
	}
	//对数据进行添加

	public int addAgentList(String strInsert){
		int n=0;
		
		ResultSet rs=null;
		Connection conn=null;
		Statement stmt=null;
		conn=ConnectionFactory.getConnection();
		try {
			stmt=conn.createStatement();
			//System.out.println(agent.getempId());
		    System.out.println(strInsert);
		    n=stmt.executeUpdate(strInsert);
		    System.out.println("update");
				} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
		DatabaseUtils.closeObject(rs,stmt,conn);
	}
		
		return n;
		
		
	}
	
	//验证登录
	public boolean getLogin(int id,String pasw){
		
		boolean n=false ;
		ResultSet rs=null;
		Connection conn=null;
		Statement stmt=null;
		conn=ConnectionFactory.getConnection();
		System.out.println("in the login");
		//int id1=Integer.parseInt(id);
		//int pasw1=Integer.parseInt(pasw);
		try {
			stmt=conn.createStatement();
			rs=stmt.executeQuery("select empid,password from o_myinfo1 where empid='"+id+"' and password='"+pasw+"'");
			if (rs.next()){
				n=true;
			}else{
				n=false;
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
		DatabaseUtils.closeObject(rs,stmt,conn);
	}
		System.out.println(n);
		return  n;
		
		
	   	    	
	}
	//获得今天日期

	public String nowTime(){
		
			   Date yy=new Date();
			   int year1=yy.getYear();
			   int mon1=yy.getMonth()+1;
			   int date1=yy.getDate();
			   int year=year1+1900;
			   String monstr1;
			   String datestr1;
			   if(mon1<10) 
				monstr1="0"+mon1;
			   else
				monstr1=""+mon1;
     
			   if(date1<10) 
				 datestr1="0"+date1;
			   else
				 datestr1=""+date1;
				 System.out.println(year+"-"+monstr1+"-"+datestr1);
			   return year+"-"+monstr1+"-"+datestr1;
		}
//	获得昨天日期
	  public String nowTime1(){
		
				 Date yy=new Date();
				 int year1=yy.getYear();
				 int mon1=yy.getMonth()+1;
				 int date1=yy.getDate();
				 int year=year1+1900;
				 int date=date1-1;
				 String monstr1;
				 String datestr1;
				 if(mon1<10) 
				  monstr1="0"+mon1;
				 else
				  monstr1=""+mon1;
     
				 if(date1<10) 
				   datestr1="0"+date;
				 else
				   datestr1=""+date;
				   System.out.println(year+"-"+monstr1+"-"+datestr1);
				 return year+"-"+monstr1+"-"+datestr1;
		  }
		 
	//部门里是否有数据
	public boolean getDep(){
		 
		 boolean n=false;
		 ResultSet rs=null;
		 Connection conn=null;
		 Statement stmt=null;
		 conn=ConnectionFactory.getConnection();
		 try {
			stmt=conn.createStatement();
			rs=stmt.executeQuery("select depid from O_DEPARTMENT");
			if(rs.next()){
				
				n=false;
				
			}else{
				n=true;
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
		DatabaseUtils.closeObject(rs,stmt,conn);
	}
		 
		System.out.println(n);

        return n;
	}
	public boolean getDepid(String strSQL){
		 
		 boolean n=false;
		 ResultSet rs=null;
		 Connection conn=null;
		 Statement stmt=null;
		 conn=ConnectionFactory.getConnection();
		 try {
			stmt=conn.createStatement();
			rs=stmt.executeQuery(strSQL);
			if(rs.next()){
				
				n=false;
				
			}else{
				n=true;
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
		DatabaseUtils.closeObject(rs,stmt,conn);
	}
		 
		System.out.println(n);

		return n;
	}
	public List getDepart(String strSQL){
		
		ResultSet rs=null;
		Connection conn=null;
		Statement stmt=null;
		conn=ConnectionFactory.getConnection();
		List list=null;
		try {
			stmt=conn.createStatement();
			rs=stmt.executeQuery(strSQL);
			while(rs.next()){
				Depart dep=new Depart();
				dep.setDepid(rs.getString("depid"));
				dep.setJuniorid(rs.getString("JUNIORID"));
				dep.setDepname(rs.getString("depname"));
				System.out.println(rs.getString("depname"));
				list.add(dep);
				
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
		DatabaseUtils.closeObject(rs,stmt,conn);
	}
		
		return list;
	}
	
	
	

	public static void main(String[] args) {
		Djmethod djm=new Djmethod();
		//djm.getEmplyee("select * from o_employee  where empid='1234'");
		
		//djm.getLogin(10021,"1");
		//Date d=null;
		//djm.getTime(,1223);
		//djm.getDep();
		//djm.nowTime1();
		//String tt="select depid from o_employee where empid='1004'";
		//djm.getDep1(tt);
		//djm.getLogin(1,"admin");
		//djm.getFile("select FILENAME from o_file where empid='10021'");
		djm.getDepid("select depid,depname from o_department where depid='1003' or depname='sdfasdfs'");
	}
}