JavaWeb SQL 人力资源管理系统

package com.dao; import java.sql.Connection; import java.sql.Date; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.common.SqlConn; import com.model.Users; public class UsersDAO { private Connection conn; public UsersDAO() { SqlConn sqlConn=new SqlConn(); conn=sqlConn.getConn(); } //增加 public void add(Users users) { String sql="insert into users values(?,?,?,?,?,?,?,?,?,?,?,?)"; try { PreparedStatement pState=conn.prepareStatement(sql); pState.setString(1, users.getUser_id()); pState.setString(2, users.getUser_name()); pState.setString(3, users.getUser_sex()); pState.setDate(4, (Date) users.getUser_birthday()); pState.setString(5, users.getUser_minzu()); pState.setString(6, users.getUser_mianmao()); pState.setString(7, users.getUser_tell()); pState.setString(8, users.getUser_add()); pState.setString(9, users.getUser_email()); pState.setString(10, users.getUser_xueli()); pState.setString(11, users.getDep_Name()); pState.setString(12, users.getUser_beizu()); pState.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } } //修改 public void edit(Users users) { String sql="update users set user_name=?,user_sex=?,user_birthday=?,user_minzu=?,user_mianmao=?,user_tell=?,user_add=?,user_email=?,user_xueli=?,dep_name=?,user_beizu=? where user_id=?"; try { PreparedStatement pState=conn.prepareStatement(sql); pState.setString(12, users.getUser_id()); pState.setString(1, users.getUser_name()); pState.setString(2, users.getUser_sex()); pState.setDate(3, (Date) users.getUser_birthday()); pState.setString(4, users.getUser_minzu()); pState.setString(5, users.getUser_mianmao()); pState.setString(6, users.getUser_tell()); pState.setString(7, users.getUser_add()); pState.setString(8, users.getUser_email()); pState.setString(9, users.getUser_xueli()); pState.setString(10, users.getDep_Name()); pState.setString(11, users.getUser_beizu()); pState.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } } //删除 public void del(String usersId) { String sql="delete from users where user_id=?"; try { PreparedStatement pState=conn.prepareStatement(sql); pState.setString(1, usersId); pState.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } } //查询 public Users findById(String usersId) { String sql="select * from users where user_id like '%"+usersId+"%'"; Users users=new Users(); try { Statement statement=conn.createStatement(); ResultSet rs=statement.executeQuery(sql); if(rs.next()) { users.setUser_id(rs.getString("user_id")); users.setUser_name(rs.getString("user_name")); users.setUser_sex(rs.getString("user_sex")); users.setUser_birthday(rs.getDate("user_birthday")); users.setUser_minzu(rs.getString("user_minzu")); users.setUser_mianmao(rs.getString("user_mianmao")); users.setUser_tell(rs.getString("user_tell")); users.setUser_add(rs.getString("user_add")); users.setUser_email(rs.getString("user_email")); users.setUser_xueli(rs.getString("user_xueli")); users.setDep_Name(rs.getString("dep_Name")); users.setUser_beizu(rs.getString("user_beizu")); } } catch (Exception e) { e.printStackTrace(); } return users; } public List<Users> findAll() { String sql="select * from users"; List<Users> list=new ArrayList<Users>(); Users users=null; try { Statement statement=conn.createStatement(); ResultSet rs=statement.executeQuery(sql); while(rs.next()) { users=new Users(); users.setUser_id(rs.getString("user_id")); users.setUser_name(rs.getString("user_name")); users.setUser_sex(rs.getString("user_sex")); users.setUser_birthday(rs.getDate("user_birthday")); users.setUser_minzu(rs.getString("user_minzu")); users.setUser_mianmao(rs.getString("user_mianmao")); users.setUser_tell(rs.getString("user_tell")); users.setUser_add(rs.getString("user_add")); users.setUser_email(rs.getString("user_email")); users.setUser_xueli(rs.getString("user_xueli")); users.setDep_Name(rs.getString("dep_Name")); users.setUser_beizu(rs.getString("user_beizu")); list.add(users); } } catch (Exception e) { e.printStackTrace(); } return list; } public List<Users> findByPro(String proName,String proValue) { String sql="select * from users where "+proName+" like '%"+proValue+"%'"; List<Users> list=new ArrayList<Users>(); Users users=null; try { Statement statement=conn.createStatement(); ResultSet rs=statement.executeQuery(sql); while(rs.next()) { users=new Users(); users.setUser_id(rs.getString("user_id")); users.setUser_name(rs.getString("user_name")); users.setUser_sex(rs.getString("user_sex")); users.setUser_birthday(rs.getDate("user_birthday")); users.setUser_minzu(rs.getString("user_minzu")); users.setUser_mianmao(rs.getString("user_mianmao")); users.setUser_tell(rs.getString("user_tell")); users.setUser_add(rs.getString("user_add")); users.setUser_email(rs.getString("user_email")); users.setUser_xueli(rs.getString("user_xueli")); users.setDep_Name(rs.getString("dep_Name")); users.setUser_beizu(rs.getString("user_beizu")); list.add(users); } } catch (Exception e) { e.printStackTrace(); } return list; } public void closeConn() { try { conn.close(); } catch (Exception e) { e.printStackTrace(); } } }