公司人才管理系统源码简易版（mvc框架进阶中1.0）

公司人才管理系统源码简易版（进阶中1.0）

Java 后端页面

controller控制层

AdminController 管理者层面

import com.gl.ams.pojo.vo.Admin;
import com.gl.ams.service.AdminService;
import com.gl.ams.service.impl.AdminServiceImpl;
import com.gl.ams.servlet.BaseServlet;
import org.apache.commons.beanutils.BeanUtils;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.Map;

@WebServlet(urlPatterns = "/dologin")
public class AdminController extends HttpServlet {
   
    private AdminService adminService=new AdminServiceImpl();
    @Override
   //判断跳转登录页面
    public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
   
        //获取页面数据
        Map<String,String[]> map= request.getParameterMap();

        // 封装页面数据
        Admin admin=new Admin();
        try {
   
            BeanUtils.populate(admin,map);
        } catch (IllegalAccessException e) {
   
            e.printStackTrace();
        } catch (InvocationTargetException e) {
   
            e.printStackTrace();
        }
        //调用业务层
        Admin realadmin= adminService.login(admin);


        //获取业务层的执行结果
        //跳转到视图层
        if (realadmin==null){
   //登陆失败再次登录
           
            response.getWriter().print("<script>alert('login no ok');history.go(-1);</script>");

        }else{
   //登陆成功跳转详情管理页面
            request.getSession().setAttribute("loginadmin",realadmin);

            response.sendRedirect(request.getContextPath()+"/admin/index.jsp");

        }


    }
}

DeptController 部门层面

import com.gl.ams.pojo.vo.Dept;
import com.gl.ams.service.DeptService;
import com.gl.ams.service.impl.DeptServiceImpl;
import com.gl.ams.servlet.BaseServlet;
import com.gl.ams.utils.DateUtil;
import com.gl.ams.utils.JsonResult;
import com.google.gson.Gson;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.Date;
import java.util.List;
import java.util.Map;
@WebServlet(urlPatterns = {
   "/admin/dept"})
public class DeptController extends BaseServlet {
   

    private DeptService deptService=new DeptServiceImpl();

    //控制部门添加
    public void doadd(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, InvocationTargetException, IllegalAccessException {
   

        // 接收数据
        Dept dept=new Dept();
        dept.setDeptname(request.getParameter("deptname"));
        dept.setDeptdesc(request.getParameter("deptdesc"));
        String datestr=request.getParameter("createdate");
        Date createdate= DateUtil.getDateByString(datestr,"yyyy-MM-dd");
        dept.setCreatedate(createdate);

        // 业务层处理数据
       int result= deptService.addDept(dept);

        // 依据业务的处理结果封装对客户端的jsonResult响应对象
        JsonResult jsonResult = new JsonResult();
        jsonResult.setData(result);
       if (result==-1){
   
           jsonResult.setResponseCode(500);
           jsonResult.setErrorMessage("部门名称重复，添加失败");
       }
       if (result==0){
   
         jsonResult.setResponseCode(500);
         jsonResult.setErrorMessage("未知异常，添加失败");
       }

        // jsonResult转成json字符串输出到客户端
        Gson gson = new Gson();
       response.getWriter().print(gson.toJson(jsonResult));
    }

     //控制修改
    public void doedit(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, InvocationTargetException, IllegalAccessException {
   
        //收集数据
        Dept dept=new Dept();
        dept.setDeptname(request.getParameter("deptname"));
        dept.setDeptdesc(request.getParameter("deptdesc"));
        String datestr=request.getParameter("createdate");
        Integer deptid=Integer.parseInt(request.getParameter("deptid"));
        dept.setDeptid(deptid);
        Date createdate= DateUtil.getDateByString(datestr,"yyyy-MM-dd");
        dept.setCreatedate(createdate);
        //业务层处理数据
        int result=  deptService.editDept(dept);
        // 依据业务的处理结果封装对客户端的jsonResult响应对象
        JsonResult jsonResult=new JsonResult();
        jsonResult.setData(result);
        if (result==-1){
   
            jsonResult.setResponseCode(500);
            jsonResult.setErrorMessage("部门名称重复，修改失败");
        }
        if(result==0){
   
            jsonResult.setResponseCode(500);
            jsonResult.setErrorMessage("未知异常，修改失败");
        }
        // jsonResult转成json字符串输出到客户端
        Gson gson=new Gson();
        response.getWriter().print(gson.toJson(jsonResult));
    }

     //控制删除
    public void remove(HttpServletRequest request,HttpServletResponse response) throws IOException {
   
        Integer deptid=Integer.parseInt(request.getParameter("id"));

        int result=  deptService.removeDeptById(deptid);
        // 依据业务的处理结果封装对客户端的jsonResult响应对象
        JsonResult jsonResult=new JsonResult();
        jsonResult.setData(result);
        if (result==-1){
   
            jsonResult.setResponseCode(500);
            jsonResult.setErrorMessage("该部门还有员工，删除失败");
        }
        if(result==0){
   
            jsonResult.setResponseCode(500);
            jsonResult.setErrorMessage("未知异常，删除失败");
        }
        // jsonResult转成json字符串输出到客户端
        Gson gson=new Gson();
        response.getWriter().print(gson.toJson(jsonResult));

    }

    //获取部门编号
    public void getdeptbyid(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {
   
        //得到了要修改部门的编号
        Integer deptid = Integer.parseInt(request.getParameter("id"));
        // 依据部门编号获取部门对象
        Dept dept = deptService.getDeptById(deptid);
        JsonResult jsonResult = new JsonResult();
        jsonResult.setData(dept);
        Gson gson = new Gson();
        response.getWriter().print(gson.toJson(jsonResult));
    }

    public void checkname(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, InvocationTargetException, IllegalAccessException {
   
        String deptname = request.getParameter("deptname");
        Dept dept = deptService.getDeptByName(deptname);
        if (dept == null) {
   
            response.getWriter().print("true");
        } else {
   
            response.getWriter().print("false");
        }
    }

    //获取部门全部信息
    public void dolist(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
   
            List<Dept> depts= deptService.getAll();
            Gson gson=new Gson();
            String depts_json=gson.toJson(depts);
//            System.out.println(depts_json);
            response.getWriter().print(depts_json);
    }
}

EmpController 员工层面

import com.gl.ams.pojo.vo.Emp;
import com.gl.ams.service.EmpService;
import com.gl.ams.service.impl.EmpServiceImpl;
import com.gl.ams.servlet.BaseServlet;
import com.gl.ams.utils.JsonResult;
import com.gl.ams.utils.PageResult;
import com.google.gson.Gson;
import org.apache.commons.beanutils.BeanUtils;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.List;
import java.util.Map;

@WebServlet(urlPatterns = "/admin/emp")
public class EmpController extends BaseServlet {
   

    private EmpService empService =new EmpServiceImpl();

     //控制员工添加
    public void doadd(HttpServletRequest request, HttpServletResponse response) throws InvocationTargetException, IllegalAccessException, IOException {
   
        //收集数据
        Map<String, String[]> map = request.getParameterMap();
        Emp emp = new Emp();
        BeanUtils.populate(emp,map);

        //调用业务层处理数据
        int result = empService.addEmp(emp);

        //依据业务层的执行结果——封装jsonresult对象
        JsonResult jsonResult = new JsonResult();
        jsonResult.setData(result);
        if (result==0){
   
            jsonResult.setErrorMessage("添加失败！");
            jsonResult.setResponseCode(500);
        }
        if (result==-1){
   
            jsonResult.setErrorMessage("员工编号重复,添加失败！");
            jsonResult.setResponseCode(500);
        }
        //将jsonresult转成json字符串输出到视图层
        response.getWriter().print(new Gson().toJson(jsonResult));
    }
   
    
    public void checkempid(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, InvocationTargetException, IllegalAccessException {
   
        //收集数据
        String empid=request.getParameter("empid");
        // 调用业务层处理数据
        Emp  emp= empService.getEmpById(empid);
        // 依据业务层的执行结果--封装jsonresult对象
        JsonResult jsonResult=new JsonResult();
        if (emp==null){
   
            jsonResult.setData(true);
        }else{
   
            jsonResult.setData(false);
            jsonResult.setResponseCode(500);
            jsonResult.setErrorMessage("员工编号重复,添加失败！");
        }
        // jsonresult转成json字符串输出到视图层
        response.getWriter().print(new Gson().toJson(jsonResult));

    }
    public void doedit(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, InvocationTargetException, IllegalAccessException {
   
        //收集数据
        Map<String,String[]> map= request.getParameterMap();
        Emp emp=new Emp();
        BeanUtils.populate(emp,map);
        // 调用业务层处理数据
        int result= empService.editEmp(emp);
        // 依据业务层的执行结果--封装jsonresult对象
        JsonResult jsonResult=new JsonResult();
        jsonResult.setData(result);
        if (result==0){
   
            jsonResult.setErrorMessage("修改失败！");
            jsonResult.setResponseCode(500);
        }
        // jsonresult转成json字符串输出到视图层
        response.getWriter().print(new Gson().toJson(jsonResult));

    }
    public void listpage(HttpServletRequest request,HttpServletResponse response) throws IOException {
   
        //收集数据
        int pageindex=1;
        String pageindex_str=request.getParameter("pageindex");
        if (pageindex_str!=null && !"".equals(pageindex_str)){
   
            pageindex=Integer.parseInt(pageindex_str);
        }
        int pagesize=2;
        String pagesize_str=request.getParameter("pagesize");
        if (pagesize_str!=null && !"".equals(pagesize_str)){
   
            pagesize=Integer.parseInt(pagesize_str);
        }

        //调用业务层处理数据
        List<Emp> emps = empService.getEmpByPage(pageindex, pagesize);
        long pagecount=empService.getPageCount(pagesize);

        // 封装成分页对象
        PageResult pageResult=new PageResult();
        pageResult.setPagecount(pagecount);
        pageResult.setPageindex(pageindex);
        pageResult.setPagesize(pagesize);
        pageResult.setDatas(emps);

        //依据业务层的执行结果——封装jsonresult对象
        JsonResult jsonResult = new JsonResult();
        jsonResult.setData(pageResult);

        //将jsonresult转成json字符串输出到视图层
        response.getWriter().print(new Gson().toJson(jsonResult));
    }
    public void getempbyid(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, InvocationTargetException, IllegalAccessException {
   
        //收集数据
        String empid=request.getParameter("id");
        // 调用业务层处理数据
        Emp  emp= empService.getEmpById(empid);
        // 依据业务层的执行结果--封装jsonresult对象
        JsonResult jsonResult=new JsonResult();
        jsonResult.setData(emp);
        // jsonresult转成json字符串输出到视图层
        response.getWriter().print(new Gson().toJson(jsonResult));

    }
}

mapper 数据库持久层

interface 接口

AdminMapper 管理者接口数据库

import com.gl.ams.pojo.vo.Admin;

import java.sql.Connection;
import java.sql.SQLException;

public interface AdminMapper {
   
    public Admin selectByUsername(Connection conn, String username)throws SQLException;
}

DeptMapper 部门接口数据库

import com.gl.ams.pojo.vo.Dept;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface DeptMapper {
   
    public  int insertDept(Connection conn, Dept dept)throws SQLException;
    public  int updateDept(Connection conn, Dept dept)throws SQLException;
    public  int deleteDeptById(Connection conn, Integer deptid)throws SQLException;
    public  Dept selectById(Connection conn, Integer deptid)throws SQLException;
    public  Dept selectByName(Connection conn, String deptname)throws SQLException;
    public List<Dept> selectAll(Connection conn)throws  SQLException;
}

EmpMapper 员工接口数据库

import com.gl.ams.pojo.vo.Emp;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface EmpMapper {
   
    public long selectEmpCountByDeptId(Connection conn, Integer deptid) throws SQLException;
    public int insertEmp(Connection conn, Emp emp)throws SQLException;
    public int updateEmp(Connection conn,Emp emp)throws SQLException;
    public int deleteEmpById(Connection conn,String empid)throws SQLException;
    public Emp selectEmpById(Connection conn,String empid)throws SQLException;
    public List<Emp> selectEmpByPage(Connection conn,int pageindex,int pagesize)throws SQLException;
    public long selectEmpCount(Connection conn)throws SQLException;
}

impl 存放接口实现类

AdminMapperImpl 管理者操作数据库

import com.gl.ams.mapper.AdminMapper;
import com.gl.ams.pojo.vo.Admin;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import java.sql.Connection;
import java.sql.SQLException;

public class AdminMapperImpl implements AdminMapper {
   
    @Override
    public Admin selectByUsername(Connection conn, String username) throws SQLException {
   
        String sql="select * from admin where username=?";
        QueryRunner queryRunner=new QueryRunner();
       Admin admin=  queryRunner.query(conn,sql,new BeanHandler<Admin>(Admin.class),username);
        return admin;
    }
}

DeptMapperImpl 部门操作数据库

import com.gl.ams.mapper.DeptMapper;
import com.gl.ams.pojo.vo.Dept;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public class