员工管理系统实现批量删除

EmpMapper

<mapper namespace="com.test.dao.EmpMapper" >
  <resultMap id="BaseResultMap" type="com.test.po.Emp" >
    <id column="empno" property="empno" jdbcType="INTEGER" />
    <result column="empname" property="empname" jdbcType="VARCHAR" />
    <result column="job" property="job" jdbcType="VARCHAR" />
    <result column="mgr" property="mgr" jdbcType="INTEGER" />
    <result column="hiredate" property="hiredate" jdbcType="TIMESTAMP" />
    <result column="sal" property="sal" jdbcType="INTEGER" />
    <result column="comm" property="comm" jdbcType="INTEGER" />
    <result column="deptno" property="deptno" jdbcType="INTEGER" />
    <association property="dept" javaType="Dept">
      <id property="deptno" column="deptno"/>
      <result property="deptname" column="deptname"/>
      <result property="loc" column="loc"/>
    </association>
  </resultMap>
  <sql id="Base_Column_List" >
    empno, empname, job, mgr, hiredate, sal, comm, emp.deptno, deptname
  </sql>
<delete id="deleteByids">
    DELETE  from emp  where empno in
    <foreach collection="dnos" item="empno" open="(" separator="," close=")" >
      #{empno,jdbcType=INTEGER}
    </foreach>
  </delete>

EmpDao

int deleteByids(@Param("dnos") Integer[] dnos);

页面代码

<button onclick="deleteAll();">批量删除</button>
    <form id="delete" action="/deleteids.htm" method="post">
      <table border="1" >
        <tr>
          <td><input type="checkbox" onclick="changecheckBox(this.checked);"></td>
          <td>员工编号</td>
          <td>姓名</td>
          <td>岗位</td>
          <td>直属领导</td>
          <td>入职时间</td>
          <td>工资</td>
          <td>奖金</td>
          <td>部门编号</td>
          <td>删除</td>
          <td>修改</td>
          <td>详细</td>
        </tr>
<c:forEach items="${pageInfo.list}" var="emp">
          <tr>
            <td><input type="checkbox" name="dnos" value="${emp.empno}"></td>
            <td>${emp.empno}</td>
            <td>${emp.empname}</td>
            <td>${emp.job}</td>
            <td>${emp.mgr}</td>
            <td><fmt:formatDate value="${emp.hiredate}" pattern="yyyy-MM-dd" /></td>
            <td>${emp.sal}</td>
            <td>${emp.comm}</td>
            <td>${emp.deptno}</td>
            <td><a href="/delete.htm?id=${emp.empno}">删除</a></td>
            <td><a href="queryEdit.htm?id=${emp.empno}">修改</a></td>
            <td><a href="detail.htm?id=${emp.empno}">详情</a></td>
          </tr>
        </c:forEach>
        <tr>
          <td colspan="12"><a href="javascript:doPage(1);">首页</a>&nbsp;&nbsp;
            <a href="javascript:doPage(${pageInfo.pageNum-1});">上一页</a>&nbsp;&nbsp;
            <a href="javascript:doPage(${pageInfo.pageNum+1});">下一页</a>&nbsp;&nbsp;
            <a href="javascript:doPage(${pageInfo.pages});">末页</a>&nbsp;&nbsp;
            ${pageInfo.pageNum}/${pageInfo.pages}页</td>
        </tr>
      </table>
    </form>
  </div>
  </body>
  <script type="application/javascript" src="/js/jquery-1.8.3.min.js"></script>
  <script type="text/javascript">
      function doPage(pageno){
          //.给表单的当前也那么赋值
          if(pageno>0&&pageno<=${pageInfo.pages}){
              $("#pageno").val(pageno);
              //提交查询的表单
              $("#query").submit();
          }
      }
      function changecheckBox(check) {
          $("input[name='dnos']").attr("checked", check);
      }
      function deleteAll() {
          var delValue="";
          var flag=false;
          var de=document.getElementsByName("dnos");
          for (var i = 0; i < de.length ; i++) {
              if(de[i].checked){
                  delValue+=","+de[i].value;
                  flag=true;
              }
          }
          if(flag==false){
              alert("至少选择一条数据！");
              return false;
          }
          alert(delValue);
          $("#delete").submit();
      }
  </script>

EmpAction

@RequestMapping("/deleteids.htm")
    public String  deleteIds(Integer[] dnos ) {
        for (Integer Strin : dnos) {
            System.out.println(Strin);
        }
        empService.deleteByids(dnos);
        return "forward:login.htm";
    }

总结：今天完成了使用spring boot的第一个项目，即实现增删改查及分页的员工管理系统，总体来说这个项目和之前使用ssm做的项目在功能实现上是没多大区别的，不过在该项目中新使用的热更新效果不错，主要以熟悉环境的搭建为主。