企业人力资源管理系统（毕业设计）（Struts2+Tomcat+mysql）内附数据库

package com.hrm.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.hrm.bean.*; public class CondbUsers { private Connection conn; private String username = "root"; private String password = ""; private String url = "jdbc:mysql://localhost/hrm_system"; private String driver = "com.mysql.jdbc.Driver"; public Connection GetConnDB() throws Exception { Class.forName(driver); conn = DriverManager.getConnection(url, username, password); return conn; } public Statement getStatement() { Statement st = null; try { st = GetConnDB().createStatement(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return st; } // 显示所有职工信息 public List<UserBean> getusers() { List<UserBean> list = new ArrayList<UserBean>(); try { String sql = "SELECT * FROM userinformation "; ResultSet rs = getStatement().executeQuery(sql); while (rs.next()) { UserBean usercontent= new UserBean(0,null,null,0,null,null,null,null,null,null); int userid= rs.getInt("userid"); String username = rs.getString("username"); String sex = rs.getString("sex"); int age = rs.getInt("age"); String department = rs.getString("department"); String position = rs.getString("position"); String phonenumber=rs.getString("phonenumber"); String state=rs.getString("state"); String others=rs.getString("others"); String introduce=rs.getString("introduce"); usercontent.setUserid(userid); usercontent.setUsername(username); usercontent.setAge(age); usercontent.setSex(sex); usercontent.setDepartment(department); usercontent.setPosition(position); usercontent.setPhonenumber(phonenumber); usercontent.setState(state); usercontent.setOthers(others); usercontent.setIntroduce(introduce); // 添加到数组中 list.add(usercontent); } rs.close(); getStatement().close(); GetConnDB().close(); } catch (Exception e) { e.printStackTrace(); } return list; } // /插入新职工信息 public void insertuser( String username,int age, String sex,String department, String position,String phonenumber,String state,String others,String introduce) { try { String sql = "insert into userinformation(username,age,sex,department,position,phonenumber,state,others,introduce) " + "values('"+username+"',age,'"+sex+"','"+department+"','"+position+"','"+phonenumber+"','"+state+"','"+others+"','"+introduce+"')"; getStatement().execute(sql); getStatement().close(); GetConnDB().close(); } catch (Exception e) { e.printStackTrace(); } } // ///准备更新职工信息，先取出原来的信息 public UserBean prepareUpdateUser(int userids) { UserBean usercontent = new UserBean(0, null,null,0,null,null,null,null,null,null); try { String sql = "select * from userinformation where userid=" + userids; ResultSet rs = getStatement().executeQuery(sql); while (rs.next()) { int userid= rs.getInt("userid"); String username = rs.getString("username"); String sex = rs.getString("sex"); int age = rs.getInt("age"); String department = rs.getString("department"); String position = rs.getString("position"); String phonenumber=rs.getString("phonenumber"); String state=rs.getString("state"); String others=rs.getString("others"); String introduce=rs.getString("introduce"); usercontent.setUserid(userid); usercontent.setUsername(username); usercontent.setAge(age); usercontent.setSex(sex); usercontent.setDepartment(department); usercontent.setPosition(position); usercontent.setPhonenumber(phonenumber); usercontent.setState(state); usercontent.setOthers(others); usercontent.setIntroduce(introduce); } rs.close(); getStatement().close(); GetConnDB().close(); } catch (Exception e) { e.printStackTrace(); } return usercontent; } // 更新职工信息 public void updateuser(int userid, String username,int age, String sex, String department,String position,String phonenumber,String state,String others,String introduce) { try { String sql = "update userinformation set username='" + username + "',age="+age+",sex='" +sex + "',department='" + department + "',position='"+position+"',phonenumber='"+phonenumber+"',state='"+state+"',others='"+others+"',introduce='"+introduce+"' where userid=" + userid; getStatement().executeUpdate(sql); getStatement().close(); GetConnDB().close(); } catch (Exception e) { e.printStackTrace(); } } // /删除职员信息 public void deleteuser(int userids) { try { String sql = "delete from userinformation where userid=" + userids; getStatement().execute(sql); getStatement().close(); GetConnDB().close(); } catch (Exception e) { e.printStackTrace(); } } // 管理员类型登陆验证 public String CheckAdminuser(String username, String password) { String id = null; String sql = "select * from adminuser where adminusername='" + username + "' and password='" + password + "'"; ResultSet rs = null; try { rs = getStatement().executeQuery(sql); while (rs.next()) { id = rs.getString("adminid"); } } catch (SQLException ex) { ex.getMessage(); } return id; } // 普通用户类型登陆验证 public String CheckUsers(String username, String password) { String id = null; String sql = "select * from userinformation where username='" + username + "' and userid='" + password + "'"; ResultSet rs = null; try { rs = getStatement().executeQuery(sql); while (rs.next()) { id = rs.getString("userid"); } } catch (SQLException ex) { ex.getMessage(); } return id; } }