项目中 Mybatis分页插件 ，和全选反选

首先导包

porm.xml 中maven导包

<!-- pagehelper :分页插件 -->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>5.1.2</version>
</dependency>
<!-- pagehelper的依赖包:jsqlparser -->
<dependency>
    <groupId>com.github.jsqlparser</groupId>
    <artifactId>jsqlparser</artifactId>
    <version>0.9.5</version>
</dependency>

详细的 pageinfo 内容

这次项目是吧模糊查询和分页回显用的一个方法

 $(function () {
            search(1);
        });
        function search(obj) {
            $.ajax({
                type:'GET',
                url:'${pageContext.request.contextPath}/cus/showInfo',
                data:{"currentpage":obj,"keyindex":$("#mt").val(),"keyCode":"%" + $("#info").val() + "%","num":$("#mtime").val()},
                dataType:'json',
                success:function (rs) {
                    $(".datatr").remove();
                    $(rs.list).each(function (index,cus) {
                        var date = new Date(cus.addtime);
                        var newtime = date.getFullYear() + "-" + (date.getMonth() + 1) + "-" + date.getDate();
                        var tr = "<tr class='datatr' align='center' bgcolor='#FFFFFF'onMouseMove='javascript:this.bgColor='#FCFDEE';' onMouseOut='javascript:this.bgColor='#FFFFFF';' height='22' >\n" +
                            "<td><input name='id' type='checkbox' id='id' value='" + cus.id + "'class='ck'></td>\n" +
                            "        <td>" + cus.id + "</td>\n" +
                            "        <td>" + cus.companyperson + "</td>\n" +
                            "        <td align=\"center\">" + cus.comname + "</td>\n" +
                            "        <td>" + newtime + "</td>\n" +
                            "        <td>" + cus.comphone + "</td>\n" +
                            "        <td><a href=\"${pageContext.request.contextPath}/cus/selectByPrimaryKey?id=" + cus.id + "\">编辑</a> | <a href=\"${pageContext.request.contextPath}/cus/selectByPrimaryKey2?id=" + cus.id + "\">查看详情</a></td>" +
                            "    </tr>";
                        $("#tr2").after(tr);
                    });
                    $("#mm").each(function () {
                        $(this).find("td").remove();
                    });
                    var td = "<td height=\"28\" colspan=\"12\">&nbsp;\n" +
                        " <a href=\"javascript:quaryAll()\" class=\"coolbg\">全选</a>\n" +
                        "<a href=\"javascript:researtAll()\" class=\"coolbg\">反选</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "<a href=\"javascript:batchDelete()\" class=\"coolbg\">&nbsp;删除&nbsp;</a>\n" +
                        "<a href=\"\" class=\"coolbg\">&nbsp;导出Excel&nbsp;</a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                     &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "当前是第" + rs.pageNum + "页\n" +
                        "&nbsp;\n" +
                        "<a href=\"javascript:search(1)\" class=\"coolbg\">首页</a>\n" +
                        "&nbsp;\n" +
                        "<a href=\"javascript:search(" + rs.prePage + ")\" class=\"coolbg\">上一页</a>\n" +
                        "&nbsp;\n" +
                        "<a href=\"javascript:search(" + rs.nextPage + ")\" class=\"coolbg\">下一页</a>\n" +
                        "&nbsp;\n" +
                        "<a href=\"javascript:search(" + rs.pages + ")\" class=\"coolbg\">尾页</a>\n" +
                        "&nbsp;\n" +
                        "共有" + rs.pages + "页";
                    $("#mm").append(td);
                },
                error:function () {
                    alert("查询失败")
                }
            });
        }

其中 obj 为当前页码，并传到后台

  @RequestMapping("showInfo")
    @ResponseBody
    public PageInfo<Customer> showInfo(@RequestParam(value = "currentpage",required = false,defaultValue = "1") int pageNum,
                                       @RequestParam(value = "size",required = false,defaultValue = "5") int pageSize,
                                       CustomerVo vo){
        //Mybatis分页插件
        //PageInfo:分页信息----数据源---哪一页---每一页的数据量
        PageHelper.startPage(pageNum,pageSize);
        List<Customer> list=customerService.pageList(vo);
        PageInfo pageInfo=new PageInfo(list);
        pageInfo.getPages();
        pageInfo.getPrePage();
        pageInfo.getNextPage();
        return pageInfo;
    }

$("#mm").each(function () {
                        $(this).find("td").remove();
                    });
                    var td = "<td height=\"28\" colspan=\"12\">&nbsp;\n" +
                        " <a href=\"javascript:quaryAll()\" class=\"coolbg\">全选</a>\n" +
                        "<a href=\"javascript:researtAll()\" class=\"coolbg\">反选</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "<a href=\"javascript:batchDelete()\" class=\"coolbg\">&nbsp;删除&nbsp;</a>\n" +
                        "<a href=\"\" class=\"coolbg\">&nbsp;导出Excel&nbsp;</a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                     &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n" +
                        "当前是第" + rs.pageNum + "页\n" +
                        "&nbsp;\n" +
                        "<a href=\"javascript:search(1)\" class=\"coolbg\">首页</a>\n" +
                        "&nbsp;\n" +
                        "<a href=\"javascript:search(" + rs.prePage + ")\" class=\"coolbg\">上一页</a>\n" +
                        "&nbsp;\n" +
                        "<a href=\"javascript:search(" + rs.nextPage + ")\" class=\"coolbg\">下一页</a>\n" +
                        "&nbsp;\n" +
                        "<a href=\"javascript:search(" + rs.pages + ")\" class=\"coolbg\">尾页</a>\n" +
                        "&nbsp;\n" +
                        "共有" + rs.pages + "页";
                    $("#mm").append(td);
                },

" <a href=\"javascript:quaryAll()\" class=\"coolbg\">全选</a>\n" 
需要获取的input对象
    "<td><input name='id' type='checkbox' id='id' value='" + cus.id + "'class='ck'></td>\n" +

全选里面有一个Javascript方法，具体方法为

  function quaryAll() {
            var arr=$(".ck"); //获取class属性值weick的对象是个数组
            for (var i=0;i<arr.length;i++){
                arr[i].checked=true; // 讲他的属性值checked全改为空
            }
            第二种方法
            function  queryAll() {
            $("input[name='ids']").prop("checked",true);
            获取input标签中name为ids的input对象，将其属性checked改为true
        }
            /*var arr = $(".ck");
            for(var i =0;i<arr.length;i++){
                arr[i].checked=true;
            }*/
        }
        function researtAll() {
            var arr=$(".ck");
            for (var i=0;i<arr.length;i++){
                arr[i].checked=!arr[i].checked;
            }
        }