userdao.java

人力资源信息管理系统！包含登录 员工管理 培训经历 用户管理 出勤管理等一系列人力资源的信息管理模块！

package com.buat.user;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import com.buat.connect.Connect;

public class UserDAO implements IUserDAO {
	
	public boolean addUser(User user) {
		boolean successful = false;
		Connection con = Connect.getConnect();
		StringBuffer sql = new StringBuffer();
		sql.append("insert into user (username,passwords,gender,birthday,createtime,brief,userlevel)");
		sql.append("         values  (     ?  ,   ?     ,  ?   ,   ?    ,   ?      ,   ? ,  ?  )");
		PreparedStatement pst = null;
		
		try{
			pst = con.prepareStatement(sql.toString());
			pst.setString(1,user.getUsername());
			pst.setString(2,user.getPassword());
			pst.setString(3,user.getGender());
			pst.setDate(4,(Date) user.getBirthday());
			pst.setDate(5,(Date) user.getCreatetime());
			pst.setString(6,user.getBrief().trim());
			pst.setInt(7,user.getUserlevel());
			
			 int result=pst.executeUpdate();
		
			 	if (result > 0){
			 		successful= true;
			 	}
			
		}catch(Exception e){
			
		}finally{
			try{
				if(con!=null){con.close();}
				if(pst!=null){pst.close();}
			}catch(Exception e){}
		}
		
		return successful;
	}
	

	public boolean deleteUserById(int id) {
		boolean successful=false;
		Connection con = null;
		con = Connect.getConnect();
		PreparedStatement pst=null;
		
		try{
			pst=con.prepareStatement("delete from user where id=?");
			pst.setInt(1,id);
		
			int result = pst.executeUpdate();
			if(result>0){
				successful=true;
			}
		
		}catch(Exception e){
			
		}finally{
			try{
				if(con!=null){con.close();}
				if(pst!=null){pst.close();}
				
			}catch(Exception e){
				
			}
		}
		return successful;
	}
	
	
	public ArrayList queryAllUserByPage(int beginIndex,int endIndex) {
		int maxLenght=endIndex-beginIndex+1;
		Connection con = null;
		con=Connect.getConnect();
		ArrayList list = new ArrayList();
		PreparedStatement pst=null;
		ResultSet rs = null;
		
		try{
			pst=con.prepareStatement("select * from user order by id desc limit ?,?");	
			pst.setInt(1,beginIndex);
			pst.setInt(2,maxLenght);
			rs=pst.executeQuery();
			
			while(rs.next()){
				User user = new User();
				user.setId(rs.getInt("id"));
				user.setUsername(rs.getString("username"));
				user.setPassword(rs.getString("passwords"));
				user.setGender(rs.getString("gender"));			
				user.setBirthday(rs.getDate("birthday"));
				user.setCreatetime(rs.getDate("createtime"));
				user.setBrief(rs.getString("brief"));
                user.setUserlevel(rs.getInt("userlevel"));
             
                list.add(user);
			}
			
		}catch(Exception e){
			
		}finally{
			try{
				if(con!=null){con.close();}
				if(pst!=null){pst.close();}
				if(rs!=null){rs.close();}
			}catch(Exception e){
				
			}
		}
		
		return list;
	}

	
	public boolean updateUserById(User user, int id) {
		boolean successful=false;
		Connection con = null;
		con=Connect.getConnect();
		PreparedStatement pst =null;
		
		try{
			pst=con.prepareStatement("update user set username=?,passwords=?,gender=?,birthday=?,createtime=?,brief=?,userlevel=? where id=?");			
		
			pst.setString(1,user.getUsername());
			pst.setString(2,user.getPassword());
			pst.setString(3,user.getGender());
			pst.setDate(4,(Date) user.getBirthday());
			pst.setDate(5,(Date) user.getCreatetime());
			pst.setString(6,user.getBrief());
			pst.setInt(7,user.getUserlevel());
			pst.setInt(8,id);
			
			int result = pst.executeUpdate();
			if(result>0){
				successful=true;
			}
			
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try{
				if(con!=null){con.close();}
				if(pst!=null){pst.close();}
				
			}catch(Exception e){
				
			}
		
		}
		return successful;
	}
	
	
	public User queryUserById(int id) {
		
		Connection con = null;
		con=Connect.getConnect();
		User user=new User();
		PreparedStatement pst=null;
		ResultSet rs = null;
		
		try{
			pst=con.prepareStatement("select * from user where id=?");		
			pst.setInt(1,id);
			rs=pst.executeQuery();
			
			while(rs.next()){
				
				user.setId(rs.getInt("id"));
				user.setUsername(rs.getString("username"));
				user.setPassword(rs.getString("passwords"));
				user.setGender(rs.getString("gender"));			
				user.setBirthday(Date.valueOf(rs.getString("birthday")));
				user.setCreatetime(Date.valueOf(rs.getString("createtime")));
				user.setBrief(rs.getString("brief"));
	            user.setUserlevel(rs.getInt("userlevel"));
				
	           
			}
			 
				
			 	
			
		}catch(Exception e){
			
		}finally{
			try{
				if(con!=null){con.close();}
				if(pst!=null){pst.close();}
				if(rs!=null){rs.close();}
			}catch(Exception e){
				
			}
		}
		
		return user;
	}
	
	
	
	
	public int getTotal(){
		Connection con=Connect.getConnect();
		StringBuffer sql= new StringBuffer();
		sql.append("select count(*) from user");
		PreparedStatement pst=null;
		ResultSet rs=null;
		int total=0;
		try{
			pst=con.prepareStatement(sql.toString());
			rs=pst.executeQuery();
			while(rs.next()){
				total=rs.getInt(1);
			}
		}catch(Exception e){
			
		}finally{
			try{
				con.close();
				if(pst!=null){
					pst.close();
				}if(rs!=null){
					rs.close();
				}
			}catch(Exception e){}
		}
		return total;
	}
}