人事管理系统 （软件工程课设）

/** * 员工档案信息数据模型 */ package sjzue.edu.cn.clq; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.Statement; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import org.apache.commons.dbutils.DbUtils; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.BeanListHandler; /** * 员工档案信息Bean，包括员工的资料的增删改 * @author clq * @version 1.8 10/06/14 */ public class Employee { private String employeeID;//员工编号 public String getEmployeeID() { return employeeID; } public void setEmployeeID(String employeeID) { this.employeeID = employeeID; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public String getBirthDay() { return birthDay; } public void setBirthDay(String birthDay) { this.birthDay = birthDay; } public String getMarriage() { return marriage; } public void setMarriage(String marriage) { this.marriage = marriage; } public String getIdentityID() { return identityID; } public void setIdentityID(String identityID) { this.identityID = identityID; } public String getDapartment() { return dapartment; } public void setDapartment(String dapartment) { this.dapartment = dapartment; } public String getDuty() { return duty; } public void setDuty(String duty) { this.duty = duty; } private String userName;//员工姓名 private String sex;//性别 private String birthDay;//出生年月 private String marriage;//婚姻状态 private String identityID;//身份证号码 private String dapartment;//所在部门 private String duty;//担任职务 private static ArrayList<Employee> employees = null;//员工信息结果集 private Employee oneEmployee = null; private String url = "jdbc:oracle:thin:@127.0.0.1:1521:ora9";//oracle的路径名 private String username = "scott";//employee 表所属数据的用户名 private String password = "root";//数据库登录的密码 private String driver = "oracle.jdbc.driver.OracleDriver";//oracle的驱动名 /** * 查询所有员工信息的静态函数 返回是一个内容是员工信息的数组容器 */ public ArrayList<Employee> selectEmployee() { String sql = "select * from employee";//查询所有员工信息的sql语句 DbUtils.loadDriver(driver);//加载数据库驱动 try { Connection conn = DriverManager.getConnection(url, username, password);//连接数据库 QueryRunner qr = new QueryRunner();//DbUtil的一个类 //将sql执行的结果放入到结果集中 List<Employee> results = (List<Employee>) qr.query(conn, sql, new BeanListHandler<Employee>(Employee.class)); DbUtils.close(conn);//关闭连接池 employees = new ArrayList<Employee>();//初始化数组集 Employee employee = null; for (int i = 0; i < results.size(); i++) { //遍历结果集，将元素放入到数组集中保存 employee = (Employee) results.get(i); employees.add(employee); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return employees;//返回保存有结果的数组集 } /** * 根据员工编号查找员工信息，并返回 */ public Employee selectEmployee(String id) { String sql = "select * from employee where empoyeeID =\'" + id + "\'"; DbUtils.loadDriver(driver); try { Connection conn = DriverManager.getConnection(url, username, password); QueryRunner qr = new QueryRunner(); List<Employee> results = (List<Employee>) qr.query(conn, sql, new BeanListHandler<Employee>(Employee.class));//将sql执行的结果放入到结果集中 DbUtils.close(conn);//关闭连接池 for (int i = 0; i < results.size(); i++) { //遍历结果集，将元素放入到数组集中保存 oneEmployee = (Employee) results.get(i);//取得结果集中的元素 } } catch (SQLException e) { e.printStackTrace(); } return oneEmployee;//返回保存有结果的数组集 } /** * 删除制定id号的员工信息 * @param id 制定要删除用户的id * @return 删除成功时返回真，否则返回假 */ public boolean deleteEmployee(String id) { String sql = "delete from employee where employeeID =?"; int result = 0;//执行sql操作的返回值 try { Class.forName(driver);//加载数据库驱动 Connection conn = DriverManager.getConnection(url, username, password);//取得数据库的连接 //创建一个 PreparedStatement 对象来将参数化的 SQL 语句发送到数据库。 PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, id);//将指定参数设置为给定 Java String 值 result = ps.executeUpdate();//执行sql语句 conn.close();//关闭连接 } catch (ClassNotFoundException e1) { e1.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } if (result > 0) { //操作成功，返回真， return true; } else {//否则，返回假 return false; } } /** * 更新制定的员工信息 * @param updateEmployee 要更新的员工信息 * @return 操作成功返回真，否则 */ public boolean updateEmployee(Employee updateEmployee) { //更新操作的sql语句 String sql = "update employee set userName=\'" + updateEmployee.getUserName() + "\',sex=\'" + updateEmployee.getSex() + "\',birthday=\'" + updateEmployee.getBirthDay() + "\',marriage=\'" + updateEmployee.getMarriage() + "\',identityID=\'" + updateEmployee.getIdentityID() + "\',department=\'" + updateEmployee.getDapartment() + "\',duty=\'" + updateEmployee.getDuty() + "\' where employeeID =\'" + updateEmployee.getEmployeeID() + "\'"; int result = 0;//操作结果量 try { Class.forName(driver);//加载驱动 Connection conn = DriverManager.getConnection(url, username, password);//取得连接 Statement stm = conn.createStatement();//创建一个 Statement 对象来将 SQL 语句发送到数据库 result = stm.executeUpdate(sql);//执行更新操作 stm.close();//关闭结果集 conn.close();//关闭连接 } catch (ClassNotFoundException e1) { e1.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } if (result > 0) { //操作成功，返回真 return true; } else { return false; } } /** * 指定员工到数据库 * @param addEmployee 要添加的员工信息 * @return 操作成功放回真。否则 */ public boolean addEmployee(Employee addEmployee) { //更新操作sql语句 String sql = "insert into employee(employeeID,userName,sex,birthDay,marriage,identityID,department,duty) " + "values(\'" + addEmployee.getEmployeeID() + "\',\'" + addEmployee.getUserName() + "\',\'" + addEmployee.getSex() + "\',\'" + addEmployee.getBirthDay() + "\',\'" + addEmployee.getMarriage() + "\',\'" + addEmployee.getIdentityID() + "\',\'" + addEmployee.getDapartment() + "\',\'" + addEmployee.getDuty() + "\')"; int result = 0; try { Class.forName(driver);//加载驱动 Connection conn = DriverManager.getConnection(url, username, password);//取得连接 Statement stm = conn.createStatement();//创建一个 Statement 对象来将 SQL 语句发送到数据库 result = stm.executeUpdate(sql);//执行更新操作 stm.close();//关闭结果集 conn.close();//关闭连接 } catch (ClassNotFoundException e1) { e1.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } if (result > 0) { //操作成功，返回真 return true; } else { //否则返回假 return false; } } }