Springmvc table搜索在本页显示加分页

最新推荐文章于 2023-11-20 01:02:15 发布

小虎哥的技术博客

最新推荐文章于 2023-11-20 01:02:15 发布

阅读量1.1k

点赞数

文章标签： spring mvc 搜索分页 table-编辑

本文链接：https://blog.csdn.net/qq_28883885/article/details/70767525

版权

Springmvc table搜索在本页显示加分页

控制器

@RequestMapping(value = "/searchGoodsBylimit/{index}")
    public String searchGoodsBylimitPst(Model model,
            @ModelAttribute Goods goods, @PathVariable String index,
            HttpServletRequest request) {
        System.out.println("商品类型" + goods.getGoodsType() + index);

        if (index == null || index.equals("")) {
            index = "0";
        }

        List<Goods> goodsS = goodsService.selectGoods(goods,
                Integer.parseInt(index), PageParam.limit);

        if (goodsS != null) {
            model.addAttribute("goodsS", goodsS);
        } else {
            model.addAttribute("resultMsg", "没有该商品");

        }
        int count = goodsService.selectAllCount(goods);
        model.addAttribute("index", index);
        model.addAttribute("count", count);
        model.addAttribute("limit", PageParam.limit);

        System.out.println("第" + index + "数据开始显示" + goodsS.size() + "条记录");
        return "goodsManager/showGoods";
    }

网页

<body>

    <form:form  id="goodsForm" class="goodsForm" modelAttribute="goods" action="" method="get">
    <div style="margin-left:auto;margin-right:auto;width:70%;font-size:13px">
              商品类型<form:input type="text" path="goodsType"  /> 
        商品名称<form:input type="text" path="goodsName"  /> 
        商品编号<form:input type="text" path="goodsId"  /> 
         <input type="submit"  id="search" value="搜索"/>
         <input type="submit"  id="allgoods" value="全部"/>

    </div>

        <table width="1052" border=0 align=center cellpadding=2 cellspacing=1
            bordercolor="#799AE1" class=tableBorder>
            <tbody>
                <tr>
                    <th align=center colspan=16 style="height: 23px">商品显示</th>
                </tr>

                <tr align="center" bgcolor="#799AE1" style="height:28px">
                    <td width="10%" align="center" class=txlHeaderBackgroundAlternate>商品编号</td>
                    <td width="10%" align="center" class=txlHeaderBackgroundAlternate>商品大类</td>
                    <td width="10%" align="center" class=txlHeaderBackgroundAlternate>商品名称</td>
                    <td width="10%" align="center" class=txlHeaderBackgroundAlternate>商品规格</td>
                    <td width="10%" align="center" class=txlHeaderBackgroundAlternate>加权进价</td>
                    <td width="10%" align="center" class=txlHeaderBackgroundAlternate>当前售价</td>
                    <td width="10%" align="center" class=txlHeaderBackgroundAlternate>操作</td>

                </tr>


                <c:forEach items="${goodsS}" var="goods">
                    <tr bgcolor="#DEE5FA">
                        <td align="center" id="goodsId" class="txlrow"><c:out
                                value="${goods.goodsId}"></c:out></td>
                        <td align=center id="goodsType" class=txlrow><c:out
                                value="${goods.goodsType}"></c:out></td>
                        <td align=center id="goodsName" class=txlrow><c:out
                                value="${goods.goodsName}"></c:out></td>
                        <td align=center id="goodsContent" class=txlrow><c:out
                                value="${goods.goodsContent}"></c:out></td>
                        <td align=center id="goodsPrice" class=txlrow><c:out
                                value="${goods.goodsPrice}"></c:out></td>
                        <td align=center id="goodsSell" class=txlrow><c:out
                                value="${goods.goodsSell}"></c:out></td>
                     <td align=center class=txlrow> <input type="button" value="编辑"></td>
                    </tr>
                </c:forEach>

            </tbody>
        </table>
        <div id="Pagination"></div>

    </form:form>


</body>

js

    var limit=<%=request.getAttribute("limit")%>;//每页显示多少 条数据
    var count=<%=request.getAttribute("count")%>//共多少条数据
    var index=<%=request.getAttribute("index")%>;//当前记录数

    $('#search').click(function(){
        var path="<%=ppath%>/goodsManager/searchGoodsBylimit/0";
        $("#goodsForm").attr("action",path );
        $("#goodsForm").submit();
    });
    $('#allgoods').click(function(){
        $('input').val("");
        var path="<%=ppath%>/goodsManager/searchGoodsBylimit/0";
        $("#goodsForm").attr("action",path );
        $("#goodsForm").submit();
    });

$(function(){
    $("#Pagination").pagination(count, {
        items_per_page:limit, // 每页显示多少条记录
        current_page: Math.ceil(index/limit),  //当前页
        num_display_entries:4, // 分页显示的条目数
        next_text:"下一页",
        prev_text:"上一页",
        num_edge_entries:2, // 连接分页主体，显示的条目数
        callback:handlePaginationClick
    });

    function handlePaginationClick(new_page_index, pagination_container) {
        var path="<%=ppath%>/goodsManager/searchGoodsBylimit/" + new_page_index*limit;
        $("#goodsForm").attr("action",path );
        $("#goodsForm").submit();
        return false;

}

});