人力资源管理系统源码包括数据库设计

package com.etc.sky.daoimpl; import java.util.*; import java.sql.Connection; 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.etc.sky.dao.DAOUser; import com.etc.sky.entity.Rec; import com.etc.sky.entity.Record; import com.etc.sky.entity.Salary; import com.etc.sky.entity.User; import com.etc.sky.utils.JDBCConnectionFactory; import com.etc.sky.utils.StrConvert; import java.sql.*; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.jsp.jstl.sql.Result; public class DUser implements DAOUser { public List<User>selectAll() { List<User> list=new ArrayList<User>(); Connection conn=JDBCConnectionFactory.getConnestion(); try { //User user=new User(rs.getInt(1),rs.getString(2)); Statement stmt=conn.createStatement(); //ResultSet rs=stmt.executeQuery("select * from tb_user"); ResultSet rs=stmt.executeQuery("select perId, name, sex, username,passwd, permission, education,status, department, duties, position,to_char(birthday,'yyyy/mm/dd') from tb_user"); while(rs.next()){ list.add(new User(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),rs.getString(9),rs.getString(10),rs.getString(11),rs.getString(12))); //System.out.print(rs.getString(8)); // user.setPerid(rs.getInt(1)); // user.setName(rs.getString(2)); // user.setSex(rs.getString(3)); // user.setPermission(rs.getString(6)); // user.setEducation(rs.getString(7)); // //user.setBirthday(rs.getString(8)); // user.setDepartment(rs.getString(9)); // user.setDuties(rs.getString(10)); // user.setPosition(rs.getString(11)); // user.setStatus(rs.getString(12)); } } catch (Exception e) { e.printStackTrace(); }finally{ if(conn!=null){ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } return list; } public List<Salary> updateSalary(int start, int end) { List<Salary> list=new ArrayList<Salary>(); String sql = "select * from (select inner.* , rownum as no FROM (select * from tb_salary " + "where rownum <=? )inner ) where no >? "; Connection conn=JDBCConnectionFactory.getConnestion(); PreparedStatement psmt = null; ResultSet rs = null; Salary sal=null; try { psmt=conn.prepareStatement(sql); psmt.setInt(1, end); psmt.setInt(2, start); rs=psmt.executeQuery(); while(rs.next()){ sal=new Salary(); sal.setSalId(rs.getInt("SalId")); sal.setPerId(rs.getInt("perId")); sal.setIns(rs.getInt("ins")); sal.setSubsid(rs.getInt("subsidy")); sal.setSalary(rs.getInt("salary")); list.add(sal); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ if(conn!=null){ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return list; } public List<Salary> deleteSalaryById(String salId) { List<Salary>list=new ArrayList(); Connection conn=JDBCConnectionFactory.getConnestion(); try { Statement stmt=conn.createStatement(); stmt.executeQuery("delete from tb_salary where salId="+salId); } catch (Exception e) { e.printStackTrace(); }finally{ if(conn!=null){ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return null; } public Salary queryById(int id){ String sql = "select * from tb_salary where salid="+id; Connection conn=JDBCConnectionFactory.getConnestion(); ResultSet rs = null; Salary sal = null; try { Statement stmt=conn.createStatement(); rs = stmt.executeQuery(sql); if(rs.next()){ sal = new Salary(); sal.setIns(rs.getInt("ins")); sal.setPerId(rs.getInt("perid")); sal.setSalary(rs.getInt("salary")); sal.setSalId(rs.getInt("salid")); sal.setSubsid(rs.getInt("subsidy")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ if(conn!=null){ try { rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return sal; } public List<Salary> updateSalaryById(String salId, String ins, String subsid, String salary) { List<Salary>list=new ArrayList(); Connection conn=JDBCConnectionFactory.getConnestion(); try { Statement stmt=conn.createStatement(); stmt.executeQuery("update tb_salary set ins="+ins+",subsidy="+subsid+",salary="+salary+" where salId="+salId ); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ if(conn!=null){ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return null; } public void insert(String salId, String perId,String ins, String subsid, String salary) { String sql="insert into tb_salary values(?,?,?,?,?,null)"; Connection conn=JDBCConnectionFactory.getConnestion(); try { PreparedStatement psmt=conn.prepareStatement(sql); psmt.setInt(1, Integer.parseInt(salId)); psmt.setInt(2, Integer.parseInt(perId)); psmt.setInt(3,Integer.parseInt(ins)); psmt.setInt(4, Integer.parseInt(subsid)); psmt.setInt(5, Integer.parseInt(salary)); psmt.executeUpdate(); System.out.println("execute"); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ if(conn!=null){ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } public List<Record> queryAll(int start, int end) { List<Record> list=new ArrayList<Record>(); String sql="select * from (select inner.* , rownum as no FROM (select * from tb_record " + "where rownum <=? )inner ) where no >? "; Connection conn=JDBCConnectionFactory.getConnestion(); PreparedStatement psmt = null; Record rec=null; ResultSet rs = null; try { psmt=conn.prepareStatement(sql); psmt.setInt(1, end); psmt.setInt(2, start); rs=psmt.executeQuery(); while(rs.next()){ rec=new Record(); rec.setRecordId(rs.getInt("recordid")); rec.setPerId(rs.getInt("PerId")); rec.setPerName(rs.getString("PerName")); rec.setDuties(rs.getString("Duties")); rec.setEducation(rs.getString("Education")); rec.setDepartment(rs.getString("DEPARTMENT")); rec.setJobContent(rs.getString("JobContent")); rec.setStartTime(rs.getString("startTime")); rec.setEndTime(rs.getString("endTime")); list.add(rec); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ if(conn!=null){ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return list; } public List<Record> deleteRecordById(String recordId) { List<Record>list=new ArrayList(); Connection conn=JDBCConnectionFactory.getConnestion(); try { Statement stmt=conn.createStatement(); s