ssm项目---人事管理系统：员工与部门、职位实现一对一

概要说明：在这个员工实现分页功能上耗费了相当大的精力，首先需要晓得一对一是怎么配置的，然后就是sql语句是怎么写的，这两个缺一不可。

Page类参考：http://blog.csdn.net/su1573/article/details/76889339

1.创建Employee.java和Employee.xml映射文件

Employee.java

public class Employee {
    private Integer employeeId;    //员工id
    private Integer deptId;
    private Dept dept;              //部门
    private Integer jobId;
    private Job job;                //职业
    private String employeeName;    //员工名字
    private String employeeCardId;  //身份证
    private String employeeAddress; //地址
    private String employeePostCode; //邮政编码
    private String employeePhone;    //手机号
    private String employeeQQ;       //QQ号
    private String employeeEmail;    //E-mail
    private String employeeSex;      //性别
    private String employeeParty;    //政治面貌
    /**
     *  使用@ModelAttribute接收参数时
     *  form表单中有日期,Spring不知道该如何转换,
     *  要在实体类的日期属性上加@DateTimeFormat(pattern="yyyy-MM-dd")注解 
     */
    @DateTimeFormat(pattern="yyyy-MM-dd")
    private Date employeeBirthday;   //出生日期

    private String employeeRace;     //民族
    private String employeeEducation;  //学历
    private String employeeHobby;      //爱好
    private Date employeeCreateDate; //建档日期

    //getter()和setter()省略
}

Employee.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="employee">

    <!-- 《员工与部门相关联》 -->
    <resultMap type="com.su.domain.Employee" id="EmployeeWithDept">
        <id column="employeeId" property="employeeId"/>
        <result column="deptId" property="deptId"/>
        <result column="jobId" property="jobId"/>
        <result column="employeeName" property="employeeName"/>
        <result column="employeeCardId" property="employeeCardId"/>
        <result column="employeeAddress" property="employeeAddress"/>
        <result column="employeePostCode" property="employeePostCode"/>
        <result column="employeePhone" property="employeePhone"/>
        <result column="employeeQQ" property="employeeQQ"/>
        <result column="employeeEmail" property="employeeEmail"/>
        <result column="employeeSex" property="employeeSex"/>
        <result column="employeeParty" property="employeeParty"/>
        <result column="employeeBirthday" property="employeeBirthday"/>
        <result column="employeeRace" property="employeeRace"/>
        <result column="employeeEducation" property="employeeEducation"/>
        <result column="employeeHobby" property="employeeHobby"/>
        <result column="employeeCreateDate" property="employeeCreateDate"/>
        <association property="dept" javaType="com.su.domain.Dept">
            <id column="deptId" property="deptId"/>
            <result column="deptName" property="deptName"/>
            <result column="deptDesc" property="deptDesc"/>
        </association>
    </resultMap>

    <!-- 《员工与职业相关联 》“继承”《员工与部门相关联》 -->
    <resultMap type="com.su.domain.Employee" id="EmployeeWithJobExtendDept" extends="EmployeeWithDept">
        <collection property="job" ofType="com.su.domain.Job">
            <id column="jobId" property="jobId"/>
            <result column="jobName" property="jobName"/>
            <result column="jobDesc" property="jobDesc"/>
        </collection>
    </resultMap>

    <!-- 根据条件分页查询 -->
    <select id="findEmployeeByPageName" parameterType="employee" resultMap="EmployeeWithJobExtendDept">
        select employeeTable.*,jobTable.jobName,deptTable.deptName
        from employeeTable,jobTable,deptTable
        where  jobTable.jobId = #{jobId}  and deptTable.deptId = #{deptId}
                and employeeTable.employeeName like '%${employeeName}%' and employeeTable.employeeCardId = #{employeeCardId} 
                and employeeTable.employeePhone = #{employeePhone} and employeeTable.jobId = #{jobId} 
                and employeeTable.deptId = #{deptId} and employeeTable.employeeSex = #{employeeSex}
    </select>

    <!-- 点击查询全部员工信息 -->
    <select id="findAllCount" resultType="java.lang.Integer">
        select count(*) from employeeTable
    </select>



    <!-- 查询记录数 -->
    <select id="findCount" parameterType="employee" resultType="java.lang.Integer">
        select count(*) from employeeTable,jobTable,deptTable
        where  jobTable.jobId = #{jobId}  and deptTable.deptId = #{deptId}
                and employeeTable.employeeName like '%${employeeName}%' and employeeTable.employeeCardId = #{employeeCardId} 
                and employeeTable.employeePhone = #{employeePhone} and employeeTable.jobId = #{jobId} 
                and employeeTable.deptId = #{deptId} and employeeTable.employeeSex = #{employeeSex}
    </select>


    <!-- 员工、部门、职位 -->
    <select id="findEmployeeByPage" resultMap="EmployeeWithJobExtendDept" parameterType="employee">
        select employeeTable.*,jobTable.jobName,deptTable.deptName
        from employeeTable,jobTable,deptTable
        where employeeTable.jobId = jobTable.jobId and employeeTable.deptId = deptTable.deptId 
    </select>


</mapper>

2. 创建EmployeeDao,和EmployeeDaoImpl

EmployeeDao.java

public interface EmployeeDao {

    public Page findEmployeeByPageName(int currentPage,Employee employee);   //按条件分页查询
}

EmployeeDaoImpl.java

public class EmployeeDaoImpl extends SqlSessionDaoSupport implements EmployeeDao {

    @Override
    public Page findEmployeeByPageName(int currentPage, Employee employee) {
        SqlSession sqlSession = this.getSqlSession();
        Page pageIndex = new Page();                //实例化Page对象
        int countResult = 0;
        if(employee.getEmployeeName() == null || employee.getEmployeeName().equals("")){
            //查询employee中数据总数，或者符合条件的数据总数
            countResult = sqlSession.selectOne("employee.findAllCount");   
        }else if(employee.getEmployeeName() != null){
            //查询employee中数据总数，或者符合条件的数据总数
            countResult = sqlSession.selectOne("employee.findCount",employee);   
        }

        System.out.println("******总记录数："+countResult);
        pageIndex.setTatalNums(countResult);           
        int totalPages = (pageIndex.getTatalNums() % pageIndex.PAGESIZE) == 0?
                pageIndex.getTatalNums() / pageIndex.PAGESIZE : (pageIndex.getTatalNums() / pageIndex.PAGESIZE)+1;
        pageIndex.setTotalPages(totalPages);  //总页数
        System.out.println("******总页数："+totalPages);

        if(currentPage < 1 ||currentPage == 0){
            currentPage = 1;
        }else if(currentPage > totalPages){
            currentPage = totalPages;
        }
        System.out.println("当前页："+currentPage);
        pageIndex.setCurrentPage(currentPage);
        int firstResult = (currentPage - 1) * pageIndex.PAGESIZE;
        System.out.println("起始行："+firstResult);
        pageIndex.setFirstResult(firstResult);
        List deptList = null;
        // offset起始行 // limit是当前页显示多少条数据
        RowBounds rowBounds = new RowBounds(pageIndex.getFirstResult(), pageIndex.PAGESIZE); 
        if(employee.getEmployeeName() == null || employee.getEmployeeName().equals("")){
            deptList = sqlSession.selectList("employee.findEmployeeByPage", employee, rowBounds);

        }else if(employee.getEmployeeName() != null){

            deptList = sqlSession.selectList("employee.findEmployeeByPageName", employee, rowBounds);   
        }

        pageIndex.setList(deptList);
        System.out.println("数据长度："+deptList.size());
        return pageIndex;
    }

}

3.创建EmployeeService和EmployeeServiceImpl

EmployeeService.java

public interface EmployeeService {
    public Page findEmployeeByPageName(int currentPage,Employee employee);   //按条件分页查询
}

EmployeeServiceImpl.java

public class EmployeeServiceImpl implements EmployeeService {

    @Autowired
    private EmployeeDao employeeDao;

    @Override
    public Page findEmployeeByPageName(int currentPage, Employee employee) {

        return employeeDao.findEmployeeByPageName(currentPage, employee);
    }


}

4.EmployeeController控制器


具体实现员工分页查询，检索条件分页查询

@Controller
public class EmployeeController {

    @Autowired
    private EmployeeService employeeService;

    @Autowired
    private JobService jobService;

    @Autowired
    private DeptService deptService;

    @RequestMapping("findEmployeeByPageName.action")
    public ModelAndView findEmployeeByPageName(int currentPage,Employee employee,ModelAndView mav,HttpServletRequest request){
        System.out.println("in EmployeeController method findEmployeeByPageName()");
        if(employee.getEmployeeName() != null){
            System.out.println("检索的员工姓名："+employee.getEmployeeName());
        }
        request.setAttribute("empBack", employee);
        Page page = employeeService.findEmployeeByPageName(currentPage, employee);
        List<Dept> deptList = deptService.findAllDept();
        List<Job> jobList = jobService.findAllJob();
        request.setAttribute("page", page);
        request.setAttribute("deptList", deptList);
        request.setAttribute("jobList", jobList);
        mav.setViewName("jsp/employee/employeeList.jsp");
        return mav;
    }

5. jsp页面展示结果

<%@ page language="java" contentType="text/html; charset=UTF-8" import="com.su.util.*"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="f" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <title>人事管理系统 ——员工管理</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta http-equiv="pragma" content="no-cache" />
    <meta http-equiv="cache-control" content="no-cache" />
    <meta http-equiv="expires" content="0" />    
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3" />
    <meta http-equiv="description" content="This is my page" />
    <link href="${pageContext.request.contextPath}/css/css.css" type="text/css" rel="stylesheet" />
    <link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/js/ligerUI/skins/Aqua/css/ligerui-dialog.css"/>
    <link href="${pageContext.request.contextPath}/js/ligerUI/skins/ligerui-icons.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery-1.11.0.js"></script>
    <script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery-migrate-1.2.1.js"></script>
    <script src="${pageContext.request.contextPath}/js/ligerUI/js/core/base.js" type="text/javascript"></script>
    <script src="${pageContext.request.contextPath}/js/ligerUI/js/plugins/ligerDrag.js" type="text/javascript"></script> 
    <script src="${pageContext.request.contextPath}/js/ligerUI/js/plugins/ligerDialog.js" type="text/javascript"></script>
    <script src="${pageContext.request.contextPath}/js/ligerUI/js/plugins/ligerResizable.jss" type="text/javascript"></script>
    <link href="${pageContext.request.contextPath}/css/pager.css" type="text/css" rel="stylesheet" />

    <script type="text/javascript">
        function one(frm,num){ 
            frm.currentPage.value=num;
            frm.submit();
        }
        function jump_to(frm,pageNo){
            var reg=/^\d+$/;
            if(!reg.test(pageNo)){
                alert("请输入正确数字");
            }else{  
                one(frm,pageNo);
            }
        }


           $(function(){
               /** 获取上一次选中的部门数据 */
               var boxs  = $("input[type='checkbox'][id^='box_']");

               /** 给全选按钮绑定点击事件  */
                $("#checkAll").click(function(){
                    // this是checkAll  this.checked是true
                    // 所有数据行的选中状态与全选的状态一致
                    boxs.attr("checked",this.checked);
                })

               /** 给数据行绑定鼠标覆盖以及鼠标移开事件  */
                $("tr[id^='data_']").hover(function(){
                    $(this).css("backgroundColor","#eeccff");
                },function(){
                    $(this).css("backgroundColor","#ffffff");
                })


               /** 删除员工绑定点击事件 */
               $("#delete").click(function(){
                   /** 获取到用户选中的复选框  */
                   var checkedBoxs = boxs.filter(":checked");
                   if(checkedBoxs.length < 1){
                       $.ligerDialog.error("请选择一个需要删除的员工！");
                   }else{
                       /** 得到用户选中的所有的需要删除的ids */
                       var ids = checkedBoxs.map(function(){
                           return this.value;
                       })

                       $.ligerDialog.confirm("确认要删除吗?","删除员工",function(r){
                           if(r){
                               // alert("删除："+ids.get());
                               // 发送请求
                               window.location = "${pageContext.request.contextPath}/removeEmployee.action?ids=" + ids.get();
                           }
                       });
                   }
               })
           })
    </script>
</head>
<body>
    <!-- 导航 -->
    <table width="100%" border="0" cellpadding="0" cellspacing="0">
      <tr><td height="10"></td></tr>
      <tr>
        <td width="15" height="32"><img src="${pageContext.request.contextPath}/images/main_locleft.gif" width="15" height="32"></td>
        <td class="main_locbg font2"><img src="${pageContext.request.contextPath}/images/pointer.gif">&nbsp;&nbsp;&nbsp;当前位置：员工管理 &gt; 员工查询</td>
        <td width="15" height="32"><img src="${pageContext.request.contextPath}/images/main_locright.gif" width="15" height="32"></td>
      </tr>
    </table>

    <form name="empform0" method="post" id="empform0" action="${pageContext.request.contextPath}/findEmployeeByPageName.action">
    <table width="100%" height="90%" border="0" cellpadding="5" cellspacing="0" class="main_tabbor">
      <!-- 查询区  -->
      <tr valign="top">
        <td height="30">
          <table width="100%" border="0" cellpadding="0" cellspacing="10" class="main_tab">
            <tr>
              <td class="fftd">


                    <table width="100%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td class="font3">
                            职位：
                                <select name="jobId" style="width:143px;">
                                    <option value="${requestScope.empBack.jobId}">(默认值)</option>
                                    <c:forEach items="${requestScope.jobList }" var="job">
                                        <option value="${job.jobId }">${job.jobName }</option>
                                    </c:forEach>
                                </select>
                            姓名：<input type="text" name="employeeName" value="${requestScope.empBack.employeeName}">
                            身份证号码：<input type="text" name="employeeCardId" maxlength="18" value="${requestScope.empBack.employeeCardId}">
                        </td>
                      </tr>
                      <tr>
                        <td class="font3">
                            性别：
                                <select name="employeeSex" style="width:143px;">
                                    <option value="${requestScope.empBack.employeeSex}">(默认值)</option>
                                    <option value="男">男</option>
                                    <option value="女">女</option>
                                </select>
                            手机：<input type="text" name="employeePhone" value="${requestScope.empBack.employeePhone}">
                            所属部门：<select  name="deptId" style="width:100px;">
                                   <option value="${requestScope.empBack.deptId}">(默认值)</option>
                                   <c:forEach items="${requestScope.deptList }" var="dept">
                                        <option value="${dept.deptId }">${dept.deptName }</option>
                                    </c:forEach>
                            </select>&nbsp;
                            <input type="hidden" name="currentPage" value="1">
                            <input type="submit" value="搜索"/>
                            <input id="delete" type="button" value="删除"/>
                        </td>
                      </tr>
                    </table>

              </td>
            </tr>
          </table>
        </td>
      </tr>

      <!-- 数据展示区 -->
      <tr valign="top">
        <td height="20">
          <table width="100%" border="1" cellpadding="5" cellspacing="0" style="border:#c2c6cc 1px solid; border-collapse:collapse;">
            <tr class="main_trbg_tit" align="center">
              <td><input type="checkbox" name="checkAll" id="checkAll"></td>
              <td>姓名</td>
              <td>性别</td>
              <td>手机号码</td>
              <td>邮箱</td>
              <td>职位</td>
              <td>学历</td>
              <td>身份证号码</td>
              <td>部门</td>
              <td>联系地址</td>
              <td>建档日期</td>
              <td align="center">操作</td>
            </tr>
            <c:forEach items="${requestScope.page.list}" var="employee" varStatus="stat">
                <tr id="data_${stat.index}" class="main_trbg" align="center">
                    <td><input type="checkbox" id="box_${stat.index}" value="${employee.employeeId}"></td>
                     <td>${employee.employeeName }</td>
                      <td>${employee.employeeSex} </td>
                      <td>${employee.employeePhone }</td>
                      <td>${employee.employeeEmail }</td>
                      <td>${employee.job.jobName }</td>
                      <td>${employee.employeeEducation }</td>
                      <td>${employee.employeeCardId }</td>
                      <td>${employee.dept.deptName }</td>
                      <td>${employee.employeeAddress }</td>
                      <td>
                        <f:formatDate value="${employee.employeeCreateDate}" 
                                type="date" dateStyle="long"/>
                      </td>
                      <td align="center" width="40px;"><a href="${pageContext.request.contextPath}/updateEmployee.action?flag=1&employeeId=${employee.employeeId}">
                            <img title="修改" src="${pageContext.request.contextPath}/images/update.gif"/></a>
                      </td>
                </tr>
            </c:forEach>
          </table>
        </td>
      </tr>
      <!-- 分页标签 -->
      <tr valign="top"><td align="center" class="font3">

         <% Page pageOne = (Page)request.getAttribute("page"); %>
        <% if(pageOne!=null) {for(int i=1;i<=pageOne.getTotalPages();i++){ %>
            <a href="javascript:one(document.forms[0],<%=i%>)"><font size="3px"><%=i%>&nbsp;</font></a>
        <% }} %>

        <br>
        搜索结果共<font style="color:red">${page.tatalNums }</font>条&nbsp;当前页${page.currentPage}/共${page.totalPages}页
        <span>跳转至</span><input type="text" name="inputPage" id="inputPage" value="${page.currentPage}" style="width:30px;text-align:center;"/>页

        <input type="button" onclick="javascript:jump_to(document.forms[0],document.getElementById('inputPage').value)" value="GO"/>

      </td></tr>
      </table>
      </form>

    <div style="height:10px;"></div>
</body>
</html>

至此员工与部门、职位，关联分页查询已完成，供以后复习

---

Author:su1573