员工管理系统

1. //数据库连接工具类 package com.util;

   import java.sql.*;

   public class DBconn { static String url =
   “jdbc:mysql://localhost:3306/mybase?useunicuee=true&
   characterEncoding=utf-8”; static String username = “root”;
   static String password = “123”; static Connection conn = null;
   static ResultSet rs = null; static PreparedStatement ps =null;
   public static Connection getConn(){ try {
   Class.forName(“com.mysql.jdbc.Driver”); conn =
   DriverManager.getConnection(url,username,password); } catch
   (Exception e) { System.out.println(“getConn [SQL驱动程序初始化失败！]”);
   e.printStackTrace(); } return conn; } public static int
   addUpdDel(String sql){ int i = 0; /* System.out.println(“sql:” +
   sql);*/ try { //通过PreparedStatement 对数据库进行增删改查
   PreparedStatement ps = conn.prepareStatement(sql);
   //executeUpdate()的返回值是一个整数，指示受影响的行数（即更新计数） i =
   ps.executeUpdate(); } catch (SQLException e) {
   System.out.println(“sql数据库增删改异常”); e.printStackTrace(); }

   	return i; 	} 	public static ResultSet selectSql(String sql){ 		try
   

   { /* System.out.println(“sql:” + sql);*/ ps =
   conn.prepareStatement(sql); rs = ps.executeQuery(sql); } catch
   (SQLException e) { System.out.println(“sql数据库查询异常”);
   e.printStackTrace(); } return rs; } public static void
   closeConn(){ try { conn.close(); } catch (SQLException e) {
   System.out.println(“sql数据库关闭异常”); e.printStackTrace(); } }
   } //登录 package com.servlet; import java.io.IOException; import
   java.io.PrintWriter; import javax.servlet.ServletException; import
   javax.servlet.http.HttpServlet; import
   javax.servlet.http.HttpServletRequest; import
   javax.servlet.http.HttpServletResponse; import
   javax.servlet.http.HttpSession;

   import com.dao.UserDaoImpl; public class DengluServlet extends
   HttpServlet { //需要继承HttpServlet 并重写doGet doPost方法 public void
   doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException { doPost(request,
   response);
   //将信息使用doPost方法执行 对应jsp页面中的form表单中的method } public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException { String name =
   request.getParameter(“emp_name”); //得到jsp页面传过来的参数 String pwd =
   request.getParameter(“pwd”); HttpSession session
   =request.getSession(); session.setAttribute(“name”, name); String id=session.getId();
   response.getWriter().write(“JSESSIONID:”+id);
   UserDaoImpl ud = new UserDaoImpl(); /System.out.println(name+"____________________");/
   if(ud.login(name, pwd)&&“123”.equals(name)){ //向request域中放置信息
   request.setAttribute(“xiaoxi”, “欢迎用户”+" “+name); request.getRequestDispatcher(”/success.jsp").forward(request,
   response);//转发到成功页面 }else if(ud.login(name, pwd)){
   //向request域中放置信息
   request.setAttribute(“xiaoxi”, “欢迎用户”+" “+name); request.getRequestDispatcher(”/successpu.jsp").forward(request,
   response);//转发到成功页面 //重定向到首页
   }else{response.sendRedirect(“index.jsp”);}

   } } /数据操作类 package com.dao;
   

   import java.sql.PreparedStatement; import java.sql.ResultSet; import
   java.sql.SQLException; import java.text.SimpleDateFormat; import
   java.util.ArrayList; import java.util.Date; import java.util.List;

   import javax.servlet.http.HttpServletRequest; import
   javax.servlet.http.HttpSession;

   import com.data.Userdata; import com.util.DBconn;

   public class UserDaoImpl{ //注册 public boolean register(Userdata
   user) { boolean flag = false; DBconn.getConn(); int i
   =DBconn.addUpdDel(“insert into employees(emp_name,pwd,emp_sex) " +
   “values(’”+user.getEmp_name()+”’,’"+user.getPwd()+"’,’"+user.getEmp_sex()+"’)");
   if(i>0){ flag = true; } DBconn.closeConn(); return flag;
   } //添加留言 public boolean registerlpu(Userdata user) { boolean
   flag = false; DBconn.getConn(); int i
   =DBconn.addUpdDel(“insert into leaveword(lea_name,lea_text,lea_time) " +
   “values(’”+user.getLea_name()+”’,’"+user.getLea_text()+"’,’"+user.getLea_time()+"’)");
   if(i>0){
   flag = true; } DBconn.closeConn(); return flag; } //添加公告 public boolean registergong(Userdata user) { boolean flag
   = false; DBconn.getConn(); SimpleDateFormat df = new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”);//设置日期格式 String
   s=df.format(new Date()); int i =DBconn.addUpdDel(“insert into
   proclamation(pro_name,pro_text,pro_time) " +
   “values(’”+user.getPro_name()+”’,’"+user.getPro_text()+"’,’"+s+"’)");
   if(i>0){ flag = true; } DBconn.closeConn(); return flag;
   } //注册判断 public boolean panduan(String emp_name) { boolean flag
   = false; DBconn.getConn(); ResultSet rs=DBconn.selectSql(“select * from employees where emp_name=”+ “’” +emp_name + “’”); try { if(rs.next()){
   flag = true; } } catch (SQLException e) { e.printStackTrace(); } DBconn.closeConn(); return flag; }
   //添加公告判断 public boolean panduangong(String pro_name) { boolean
   flag = false; DBconn.getConn(); ResultSet
   rs=DBconn.selectSql(“select * from proclamation where pro_name=”+
   “’” +pro_name + “’”); try {
   if(rs.next()){
   flag = true;
   } } catch (SQLException e) {
   e.printStackTrace(); } DBconn.closeConn(); return flag; } //添加部门 public boolean registerbu(Userdata user) { boolean
   flag = false; DBconn.getConn(); int i
   =DBconn.addUpdDel(“insert into department(dep_name,dep_gov) " +
   “values(’”+user.getDep_name()+”’,’"+user.getDep_gov()+"’)"); if(i>0){
   flag = true; } DBconn.closeConn(); return flag; } //添加请假信息
   public boolean registerleav(Userdata user) {
   boolean flag = false;
   DBconn.getConn();
   SimpleDateFormat df = new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”);//设置日期格式
   String s=df.format(new Date());
   String j=“请假时间”+user.getLeav_time()+“请假开始时间 “+s;
   System.out.println(j+“");
   int i =DBconn.addUpdDel(“insert into leaveone(emp_name,leav_time,leav_text) " +
   “values(’”+user.getEmp_name()+”’,’"+j+"’,’"+user.getLeav_text()+"’)");
   if(i>0){
   flag = true;
   }
   DBconn.closeConn();
   return flag;
   } //添加部门判断 public boolean panduanbu(String dep_name) { boolean flag = false; DBconn.getConn(); ResultSet
   rs=DBconn.selectSql(“select * from department where dep_name=”+ “’”
   +dep_name + “’”); try {
   if(rs.next()){
   flag = true;
   } } catch (SQLException e) {
   e.printStackTrace(); } DBconn.closeConn(); return flag; } //登录 public boolean login(String emp_name,String pwd) {
   boolean flag = false; try { DBconn.getConn(); ResultSet rs
   = DBconn.selectSql(“select * from employees where emp_name=’”+emp_name+"’ and pwd=’"+pwd+"’"); while(rs.next()){
   if(rs.getString(“emp_name”).equals(emp_name) && rs.getString(“pwd”).equals(pwd)){
   flag = true;
   } } DBconn.closeConn(); } catch (SQLException e) { e.printStackTrace(); } return flag; } //返回单个部门信息 public
   Userdata getUserbu(int dep_no) { Userdata user = new Userdata();
   try {
   DBconn.getConn();
   ResultSet rs = DBconn.selectSql(“select dep_no,dep_name,dep_gov from department where dep_no=” +"’" +dep_no + “’”);
   while(rs.next()){
   user.setDep_no(rs.getInt(“dep_no”));
   user.setDep_name(rs.getString(“dep_name”));
   user.setDep_gov(rs.getString(“dep_gov”));
   }
   DBconn.closeConn();
   return user; } catch (SQLException e) {
   e.printStackTrace(); } return null; }
   //返回单个请假信息 public Userdata getUserqipu(String emp_name) { Userdata user = new Userdata(); try {
   DBconn.getConn();
   ResultSet rs = DBconn.selectSql(“select emp_no,emp_name,leav_text,leav_time,leav_ans from leaveone where
   emp_name=” +"’" +emp_name + “’”);
   while(rs.next()){
   user.setEmp_no(rs.getInt(“emp_no”));
   user.setEmp_name(rs.getString(“emp_name”));
   user.setLeav_time(rs.getString(“leav_time”));
   user.setLeav_text(rs.getString(“leav_text”));
   user.setLeav_ans(rs.getString(“leav_ans”));
   /System.out.println(rs.getString(“leav_ans”)+"*****************");/
   }
   DBconn.closeConn();
   return user; } catch (SQLException e) {
   e.printStackTrace(); } return null; } //返回单个请假信息
   public Userdata getUserqi(int emp_no) {
   Userdata user = new Userdata();
   try {
   DBconn.getConn();
   ResultSet rs = DBconn.selectSql(“select emp_no,emp_name,leav_text,leav_time,leav_ans from leaveone where
   emp_no=” +"’" +emp_no + “’”);
   while(rs.next()){
   user.setEmp_no(rs.getInt(“emp_no”));
   user.setEmp_name(rs.getString(“emp_name”));
   user.setLeav_time(rs.getString(“leav_time”));
   user.setLeav_text(rs.getString(“leav_text”));
   user.setLeav_ans(rs.getString(“leav_ans”));
   /System.out.println(rs.getString(“leav_ans”)+"******");/
   }
   DBconn.closeConn();
   return user;
   } catch (SQLException e) {
   e.printStackTrace();
   }
   return null;
   }
   //返回单个公告信息 public Userdata getUsergong(int pro_no) { Userdata user = new Userdata(); try {
   DBconn.getConn();
   ResultSet rs = DBconn.selectSql(“select pro_no,pro_name,pro_text,pro_time from proclamation where pro_no=”
   +"’" +pro_no + “’”);
   while(rs.next()){
   user.setPro_no(rs.getInt(“pro_no”));
   user.setPro_name(rs.getString(“pro_name”));
   user.setPro_text(rs.getString(“pro_text”));
   user.setPro_time(rs.getString(“pro_time”));
   System.out.println(rs.getString(“pro_time”)+"");
   }
   DBconn.closeConn();
   return user; } catch (SQLException e) {
   e.printStackTrace(); } return null; } //根据登录的用户名查询信息返回员工用户留言信息 public Userdata getUserlpu(String
   lea_name) { Userdata user = new Userdata(); try {
   DBconn.getConn();
   ResultSet rs = DBconn.selectSql(“select lea_no,lea_name,lea_text,lea_time from leaveword where lea_name=”
   +"’" +lea_name+ “’”);
   while(rs.next()){
   user.setLea_no(rs.getInt(“lea_no”));
   user.setLea_name(rs.getString(“lea_name”));
   user.setLea_text(rs.getString(“lea_text”));
   user.setLea_time(rs.getString(“lea_time”));
   }
   DBconn.closeConn();
   return user; } catch (SQLException e) {
   e.printStackTrace(); } return null; } //根据登录的用户名查询信息返回员工用户工资信息
   public Userdata getUserg(String emp_name) {
   Userdata user = new Userdata();
   try {
   DBconn.getConn();
   ResultSet rs = DBconn.selectSql(“select emp_no,emp_name,emp_wage from employees where emp_name=” +"’"
   +emp_name+ “’”);
   while(rs.next()){
   user.setEmp_no(rs.getInt(“emp_no”));
   user.setEmp_name(rs.getString(“emp_name”));
   user.setEmp_wage(rs.getString(“emp_wage”));
   }
   DBconn.closeConn();
   return user;
   } catch (SQLException e) {
   e.printStackTrace();
   }
   return null;
   } //根据登录的用户名查询信息返回员工用户个人信息 public Userdata getUserz(String emp_name) { Userdata user = new Userdata(); try {
   DBconn.getConn();
   ResultSet rs = DBconn.selectSql(“select emp_no,emp_name,pwd,emp_sex,emp_wage,emp_department,emp_workday,emp_signday
   from employees where emp_name=” +"’" +emp_name+ “’”);
   while(rs.next()){
   user.setEmp_no(rs.getInt(“emp_no”));
   user.setEmp_name(rs.getString(“emp_name”));
   user.setPwd(rs.getString(“pwd”));
   user.setEmp_sex(rs.getString(“emp_sex”));
   user.setEmp_wage(rs.getString(“emp_wage”));
   user.setEmp_department(rs.getString(“emp_department”));
   /user.setEmp_department(rs.getString(“emp_department”));/
   user.setEmp_workday(rs.getString(“emp_workday”));
   / System.out.println("-------------------------");
   System.out.println(rs.getString(“emp_signday”));/
   user.setEmp_signday(rs.getString(“emp_signday”));
   }
   DBconn.closeConn();
   return user; } catch (SQLException e) {
   e.printStackTrace(); } return null; } //返回员工用户个人信息 public Userdata getUser(int emp_no) { Userdata user = new
   Userdata(); try { DBconn.getConn(); ResultSet rs =
   DBconn.selectSql(“select
   emp_no,emp_name,pwd,emp_sex,emp_department,emp_wage,emp_workday,emp_signday
   from employees where emp_no=” +"’" +emp_no + “’”);
   while(rs.next()){
   user.setEmp_no(rs.getInt(“emp_no”));
   user.setEmp_name(rs.getString(“emp_name”));
   user.setPwd(rs.getString(“pwd”));
   user.setEmp_sex(rs.getString(“emp_sex”));
   user.setEmp_wage(rs.getString(“emp_wage”));
   user.setEmp_department(rs.getString(“emp_department”));
   user.setEmp_workday(rs.getString(“emp_workday”));
   /System.out.println("-------------------------");
   System.out.println(rs.getString(“emp_signday”));/
   user.setEmp_signday(rs.getString(“emp_signday”)); } DBconn.closeConn(); return user; } catch (SQLException e) {
   e.printStackTrace(); } return null; } //返回单人请假信息 public
   Userdata getUserleav(int emp_no) { Userdata user = new Userdata();
   try { DBconn.getConn(); ResultSet rs =
   DBconn.selectSql(“select
   emp_no,emp_name,leav_time,leav_text,leav_ans from leaveone where
   emp_no=” +"’" +emp_no + “’”); while(rs.next()){
   user.setEmp_no(rs.getInt(“emp_no”));
   user.setEmp_name(rs.getString(“emp_name”));
   user.setLeav_text(rs.getString(“leav_text”));
   user.setLeav_time(rs.getString(“leav_time”));
   user.setLeav_ans(rs.getString(“leav_ans”));
   /System.out.println(rs.getString(“leav_ans”)+"__________");/
   } DBconn.closeConn(); return user; } catch (SQLException
   e) { e.printStackTrace(); } return null; } //签到 public
   boolean sign(String emp_name){ boolean flag = false;
   DBconn.getConn(); SimpleDateFormat df = new
   SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”);//设置日期格式 String
   s=df.format(new Date()); String sql=“update employees set
   emp_signday=’”+s+”'where emp_name =”+”’" +emp_name + “’”; int i
   =DBconn.addUpdDel(sql); if(i>0){ flag = true; } DBconn.closeConn(); return flag; } //返回所有部门 public
   List getUserAlldp() { List list = new
   ArrayList(); try { DBconn.getConn(); ResultSet rs
   = DBconn.selectSql(“select * from department”); while(rs.next()){
   Userdata user = new Userdata();
   user.setDep_no(rs.getInt(“dep_no”));
   user.setDep_name(rs.getString(“dep_name”));
   user.setDep_gov(rs.getString(“dep_gov”));
   list.add(user); } DBconn.closeConn(); return list; } catch (SQLException e) { e.printStackTrace(); } return null;
   } //返回所有请假信息 public List getUserAllleav() {
   List list = new ArrayList(); try {
   DBconn.getConn();
   ResultSet rs = DBconn.selectSql(“select * from leaveone”);
   while(rs.next()){
   Userdata user = new Userdata();
   user.setEmp_no(rs.getInt(“emp_no”));
   user.setEmp_name(rs.getString(“emp_name”));
   user.setLeav_time(rs.getString(“leav_time”));
   user.setLeav_text(rs.getString(“leav_text”));
   user.setLeav_ans(rs.getString(“leav_ans”));
   list.add(user);
   }
   DBconn.closeConn();
   return list; } catch (SQLException e) {
   e.printStackTrace(); } return null; } //返回所有留言 public List getUserAlllpu() {
   List list = new ArrayList();
   try {
   DBconn.getConn();
   ResultSet rs = DBconn.selectSql(“select * from leaveword”);
   while(rs.next()){
   Userdata user = new Userdata();
   user.setLea_no(rs.getInt(“lea_no”));
   user.setLea_name(rs.getString(“lea_name”));
   user.setLea_text(rs.getString(“lea_text”));
   user.setLea_time(rs.getString(“lea_time”));
   list.add(user);
   }
   DBconn.closeConn();
   return list;
   } catch (SQLException e) {
   e.printStackTrace();
   }
   return null; } //返回所有公告 public List getUserAllpro() { List list = new
   ArrayList(); try {
   DBconn.getConn();
   ResultSet rs = DBconn.selectSql(“select * from proclamation”);
   while(rs.next()){
   Userdata user = new Userdata();
   user.setPro_no(rs.getInt(“pro_no”));
   user.setPro_name(rs.getString(“pro_name”));
   user.setPro_text(rs.getString(“pro_text”));
   user.setPro_time(rs.getString(“pro_time”));
   list.add(user);
   }
   DBconn.closeConn();
   return list; } catch (SQLException e) {
   e.printStackTrace(); } return null; } //返回所有用户 public List getUserAll() { List list = new
   ArrayList(); try { DBconn.getConn(); ResultSet rs
   = DBconn.selectSql(“select * from employees”); while(rs.next()){
   Userdata user = new Userdata();
   user.setEmp_no(rs.getInt(“emp_no”));
   user.setEmp_name(rs.getString(“emp_name”));
   user.setPwd(rs.getString(“pwd”));
   user.setEmp_sex(rs.getString(“emp_sex”));
   user.setEmp_wage(rs.getString(“emp_wage”));
   user.setEmp_department(rs.getString(“emp_department”));
   user.setEmp_workday(rs.getString(“emp_workday”));
   user.setEmp_signday(rs.getString(“emp_signday”));
   list.add(user); } DBconn.closeConn(); return list; } catch (SQLException e) { e.printStackTrace(); } return null;
   } //删除公告 public boolean deletegong(int pro_no) { boolean flag
   = false; DBconn.getConn(); String sql = “delete from proclamation where pro_no=”+"’" +pro_no + “’”; int i
   =DBconn.addUpdDel(sql); if(i>0){
   flag = true; } DBconn.closeConn(); return flag; } //删除员工 public boolean delete(int emp_no) { boolean flag = false;
   DBconn.getConn(); String sql = “delete from employees where
   emp_no=”+"’" +emp_no + “’”; int i =DBconn.addUpdDel(sql);
   if(i>0){ flag = true; } DBconn.closeConn(); return flag;
   } //删除留言 public boolean deletelpu(int lea_no) {
   boolean flag = false;
   DBconn.getConn();
   String sql = “delete from leaveword where lea_no=”+"’" +lea_no + “’”;
   int i =DBconn.addUpdDel(sql);
   if(i>0){
   flag = true;
   }
   DBconn.closeConn();
   return flag; } //删除部门 public boolean deletebu(int dep_no) { boolean flag = false; DBconn.getConn(); String sql =
   “delete from department where dep_no=”+"’" +dep_no + “’”; int i
   =DBconn.addUpdDel(sql); if(i>0){
   flag = true; } DBconn.closeConn(); return flag; } //删除请假信息
   public boolean deleteleav(int emp_no) {
   boolean flag = false;
   DBconn.getConn();
   String sql = “delete from leaveone where emp_no=”+"’" +emp_no + “’”;
   int i =DBconn.addUpdDel(sql);
   if(i>0){
   flag = true;
   }
   DBconn.closeConn();
   return flag;
   } //更改pu用户 public boolean updatez(int emp_no,String emp_name, String pwd,String emp_sex, String emp_wage,String
   emp_department,String emp_workday,String emp_signday) { boolean
   flag = false; DBconn.getConn(); String sql =“update employees
   set emp_name =’”+emp_name
   +"’ , pwd =’"+pwd
   +"’ , emp_wage =’"+emp_wage
   +"’ , emp_sex =’"+emp_sex
   +"’ , emp_department =’"+emp_department
   +"’ , emp_workday =’"+emp_workday
   +"’ , emp_signday =’"+emp_signday+"’ where emp_name = “+”’" +emp_name + “’”; int i =DBconn.addUpdDel(sql); if(i>0){
   flag = true; } DBconn.closeConn(); return flag; } //普通用户更改 public boolean updatepul(int emp_no,String emp_name,
   String pwd,String emp_sex) { boolean flag = false;
   DBconn.getConn(); String sql =“update employees set emp_name
   =’”+emp_name
   +"’ , pwd =’"+pwd
   +"’ , emp_sex =’"+emp_sex+"’ where emp_no = “+”’" +emp_no + “’”; int i =DBconn.addUpdDel(sql); if(i>0){
   flag = true; } DBconn.closeConn(); return flag; } //更改 public boolean update(int emp_no,String emp_name, String
   pwd,String emp_sex, String emp_wage,String emp_department,String
   emp_workday,String emp_signday) { boolean flag = false;
   DBconn.getConn(); String sql =“update employees set emp_name
   =’”+emp_name
   +"’ , pwd =’"+pwd
   +"’ , emp_wage =’"+emp_wage
   +"’ , emp_sex =’"+emp_sex
   +"’ , emp_department =’"+emp_department
   +"’ , emp_workday =’"+emp_workday
   +"’ , emp_signday =’"+emp_signday+"’ where emp_no = “+”’" +emp_no + “’”; int i =DBconn.addUpdDel(sql); if(i>0){ flag = true; } DBconn.closeConn(); return flag; } //更改部门信息 public
   boolean updatebu(int dep_no,String dep_name, String dep_gov) {
   boolean flag = false; DBconn.getConn(); String sql =“update
   department set dep_name =’”+dep_name
   +"’ , dep_gov =’"+dep_gov+"’ where dep_no = “+”’" +dep_no + “’”; int i =DBconn.addUpdDel(sql); if(i>0){
   flag = true; } DBconn.closeConn(); return flag; } //回复请假信息
   public boolean updateleav(int emp_no,String leav_ans) {
   boolean flag = false;
   DBconn.getConn();
   String sql =“update leaveone set leav_ans =’”+leav_ans+"’ where emp_no = “+”’" +emp_no + “’”;
   int i =DBconn.addUpdDel(sql);
   if(i>0){
   flag = true;
   }
   DBconn.closeConn();
   return flag;
   } //更改公告信息
   public boolean updategong(int pro_no,String pro_name, String pro_text, String pro_time) {
   boolean flag = false;
   DBconn.getConn();
   /System.out.println(pro_no+"******************************");/
   String sql =“update proclamation set pro_name =’”+pro_name
   +"’ , pro_text =’"+pro_text+"’, pro_time =’"+pro_time+"‘where pro_no = “+”’" +pro_no + “’”;
   / System.out.println(pro_no+"********************************");/
   int i =DBconn.addUpdDel(sql);
   if(i>0){
   flag = true;
   }
   DBconn.closeConn();
   return flag;
   } }