Java编写的人事管理信息系统

package renshi; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Vector; public class DataOperate { //从数据库中获取用户的信息 public IUser getUser(String userID){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); rs=sm.executeQuery("select * from iuser where userID='"+userID+"'"); if(rs.next()){ IUser user=new IUser(); user.setID(new Long(rs.getLong("id"))); user.setUserID(userID); user.setPassword(rs.getString("password")); user.setuserpermit(rs.getString("userpermit")); return user; } } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } return null; } void close(ResultSet rs){ if(rs!=null){ try{ rs.close(); }catch(SQLException e){} rs=null; } } void close(Statement sm){ if(sm!=null){ try{ sm.close(); }catch(SQLException e){} sm=null; } } void close(Connection con){} // 修改使用者密码 public void addUser(String i,String j,String k){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); sm.execute("insert into iuser (userID,password,userpermit) values ('"+i+"','"+j+"','"+k+"')"); } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } } // 修改使用者密码 public void editUser(String i,String j){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); sm.execute("update iuser set password='"+i+"'where userID='"+j+"'"); } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } } // 删除使用者帐号 public void deleteUser(String i){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); sm.execute("delete iuser where userID='"+i+"'"); } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } } //读取员工基本信息记录 @SuppressWarnings("unchecked") public Vector getYuangongxx(){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); rs=sm.executeQuery("select * from workertable"); Vector vec=new Vector(); while(rs.next()){ Vector sv=new Vector(); sv.add(rs.getString("员工编号")); sv.add(rs.getString("员工姓名")); sv.add(rs.getString("性别")); sv.add(rs.getString("学历")); sv.add(rs.getString("工作部门")); vec.add(sv); } return vec; } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } return null; } // 保存新员工基本信息记录 public void addYuangongxx(String i,String a1,String a2,String a3,String a4){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); sm.execute("insert into workertable values ('"+i+"','"+a1+"','"+a2+"','"+a3+"','"+a4+"')"); } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } } //获取全部员工职称信息记录 @SuppressWarnings("unchecked") public Vector getzhichenxx(){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); rs=sm.executeQuery("select * from zhichen"); Vector vec=new Vector(); while(rs.next()){ Vector sv=new Vector(); sv.add(rs.getString("员工编号")); sv.add(rs.getString("员工姓名")); sv.add(rs.getString("职称")); sv.add(rs.getString("评定日期")); sv.add(rs.getString("评定单位")); vec.add(sv); } return vec; } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } return null; } //查询员工职称信息 @SuppressWarnings("unchecked") public Vector chaxunzhichenxx(String i){ Connection con=null; Statement sm=null; ResultSet rs=null; Vector sv=new Vector(); try { con=ConnectManager.getConnection(); sm=con.createStatement(); rs=sm.executeQuery("select * from zhichen where 员工编号='"+i+"'"); if(rs.next()){ Vector sv1=new Vector(); sv1.add(rs.getString("员工编号")); sv1.add(rs.getString("员工姓名")); sv1.add(rs.getString("职称")); sv1.add(rs.getString("评定日期")); sv1.add(rs.getString("评定单位")); sv.add(sv1); return sv; }else { return null; } } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } return null; } //删除员工职称信息 public void deletezhichenxx(String i){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); sm.execute("delete zhichen where 员工编号='"+i+"'"); } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } } //获取员工履历中员工编号列表 @SuppressWarnings("unchecked") public Vector getYGlvlibhxx(){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); rs=sm.executeQuery("select * from workerll"); Vector vec=new Vector(); while(rs.next()){ vec.add(rs.getString("员工编号")); } return vec; } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } return null; } //获取员工履历文本信息 @SuppressWarnings("unchecked") public String getYGlvlixx(String i){ Connection con=null; Statement sm=null; ResultSet rs=null; String sv; try { con=ConnectManager.getConnection(); sm=con.createStatement(); rs=sm.executeQuery("select * from workerll where 员工编号='"+i+"'"); if(rs.next()){ sv=rs.getString("员工履历"); return sv; }else { return null; } } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } return null; } //修改员工履历信息 public void editYGlvlixx(String i,String j){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); sm.execute("update workerll set 员工履历='"+i+"'where 员工编号='"+j+"'"); } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } } //删除员工履历信息 public void deleteYGlvlixx(String i){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); sm.execute("delete workerll where 员工编号='"+i+"'"); } catch(SQLException e){ e.printStackTrace(); }finally{ close(rs); close(sm); close(con); } } //获取全部员工考勤信息记录 @SuppressWarnings("unchecked") public Vector getYGkqxx(){ Connection con=null; Statement sm=null; ResultSet rs=null; try { con=ConnectManager.getConnection(); sm=con.createStatement(); rs=sm.executeQuery("select * from workerRecord"); Vector vec=new Vector(); while(rs.next()){ Vector sv=new Vector(); sv.add(rs.getLong("记录编号")); sv.add(rs.getString("员工编号")); sv.add(rs.getString("员工姓名")); sv.add(rs.getString("日期")); sv.add(rs.getString("考勤记录")); vec.add(sv); } return vec;