分页查询

mapper

//分页查询加模糊查询
List<Address> showAddress(@Param("addressName") String addressName, @Param("dangQianYe") Integer dangQianYe,@Param("meiYeYouJiGe")  Integer meiYeYouJiGe);
//查询总数加模糊查询
int count(@Param("addressName") String addressName);



mapper.Xml
<select id="showAddress" resultType="com.fenyecha.pojo.Address">
SELECT * FROM `address`
        <where>
        <if test="addressName!=null">
            and `addressName` like concat ('%',#{addressName},'%')
        </if>
        </where>
  LIMIT #{dangQianYe},#{meiYeYouJiGe}
    </select>
    <select id="count" resultType="java.lang.Integer">
        SELECT COUNT(*) FROM `address`
        <where>
            <if test="addressName!=null">
               and `addressName` like concat ('%',#{addressName},'%')
            </if>
        </where>
    </select>





controller

@RequestMapping("/index")
public String Show(Model model, String addressName,Integer dangQianYe){
    System.out.println("123");
    //当前页数
    dangQianYe = dangQianYe != null ? dangQianYe:1;
    PageSupport pageSupport = new PageSupport();
    addressService.showAddress(addressName,dangQianYe,pageSupport.getPageSize());
    //总记录数
    pageSupport.setTotalCount(addressService.count(addressName));
    //总页数
    int totalPageCount = pageSupport.getTotalPageCount();
    //当前页数
    model.addAttribute("dangQianYe",dangQianYe);
    dangQianYe = (dangQianYe-1)*pageSupport.getPageSize();
    List<Address> list = addressService.showAddress(addressName, dangQianYe, pageSupport.getPageSize());
    model.addAttribute("showAddress",list);
    model.addAttribute("totalPageCount",totalPageCount);
    model.addAttribute("count",pageSupport.getTotalCount());
    return "index";
}


 
页面

<body>
<form method="post" action="${pageContext.request.contextPath }/index">
    <input type="text" name="addressName">
    <input type="submit" value="查询"/>
</form>
<table>
        <tr>
            <th>addressareaid</th>
            <th>addressname</th>
            <th>addressregionid</th>
        </tr>
<c:forEach var="list" items="${showAddress}">
    <tr>
        <td>${list.addressareaid}</td>
        <td>${list.addressname}</td>
        <td>${list.addressregionid}</td>
    </tr>
</c:forEach>
    </table>
    <span>总共有/${count}条数据</span>&nbsp;
    <c:if test="${dangQianYe>1}">
        <a href="${pageContext.request.contextPath }/index?dangQianYe=1">首页</a>&nbsp;&nbsp;&nbsp;
        <a href="${pageContext.request.contextPath }/index?dangQianYe=${dangQianYe-1}">上一页</a>&nbsp;&nbsp;&nbsp
    </c:if>
<c:if test="${dangQianYe<totalPageCount}">
    <a href="${pageContext.request.contextPath }/index?dangQianYe=${dangQianYe+1}">下一页</a>&nbsp;&nbsp;&nbsp;
    <a href="${pageContext.request.contextPath }/index?dangQianYe=${totalPageCount}">末页</a>&nbsp;
</c:if>
    &nbsp;  &nbsp;<span>第<span id="nCurPage">${dangQianYe}</span>页/共<span id="nPageSize">${totalPageCount}</span>页</span>
</body>





posted @ 2022-04-28 14:54  朱浩杰  阅读(13)  评论(0)    收藏  举报