记一次 SSM 分页

1.实体层(entity,pojo,domain)

package com.entity;

import java.io.Serializable;

      private int totalCount;      //总记录数

      private int totalPageCount;  //总页数

      private int startPos;        //开始位置，从0开始

      private boolean hasFrist;    //是否有首页

      private boolean hasPre;      //是否有前一页

      private boolean hasNext;     //是否有后一页

      private boolean hasLast;     //是否有尾页

      /**

       * 通过构造函数，传入总记录数和当前页

       * @param pageNow

       * @param totalCount

       */

      public CountPage(int pageNow, int totalCount) {

          super();

          this.pageNow = pageNow;

          this.totalCount = totalCount;

      }

      //获取总页数

      public int getTotalPageCount() {

          totalPageCount=getTotalCount()/getPageSize();

          return (totalCount/pageSize==1) ? totalPageCount:totalPageCount+1;

      }

      public void setTotalPageCount(int totalPageCount) {

          this.totalPageCount = totalPageCount;

      }

      public int getPageNow() {

          return pageNow;

      }

      public void setPageNow(int pageNow) {

          this.pageNow = pageNow;

      }

      public int getPageSize() {

          return pageSize;

      }

      public void setPageSize(int pageSize) {

          this.pageSize = pageSize;

      }

      public int getTotalCount() {

          return totalCount;

      }

      public void setTotalCount(int totalCount) {

          this.totalCount = totalCount;

      }

      //取得选择记录的初始位置

      public int getStartPos() {

          return (pageNow-1)*pageSize;

      }

      public void setStartPos(int startPos) {

          this.startPos = startPos;

      }

      //判断是否有第一页

      public boolean isHasFrist() {

          return (pageNow==1) ? false:true;

      }

      public void setHasFrist(boolean hasFrist) {

          this.hasFrist = hasFrist;

      }

      //如果有首页就有前一页

      public boolean isHasPre() {

          return isHasFrist() ? true:false;

      }

      public void setHasPre(boolean hasPre) {

          this.hasPre = hasPre;

      }

      //如果有尾页就有下一页

      public boolean isHasNext() {

          return isHasNext() ? true:false;

      }

      public void setHasNext(boolean hasNext) {

          this.hasNext = hasNext;

      }

      //判断是否有尾页

      public boolean isHasLast() {

          return (pageNow==getTotalCount()) ? false:true;

      }

      public void setHasLast(boolean hasLast) {

          this.hasLast = hasLast;

      }

}

2.DAO层

package com.dao;

import java.util.List;

import com.entity.MyAccount;

public interface MyAccountMapper {

    /*  查询所有   传值（当前页，每页显示多少条数据） */

    List<MyAccount> findAll(Integer pageNow,Integer pageSize);

    /*  查询总数  */

    Integer myAccountCount();

}

3.xxxmapper.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="com.dao.MyAccountMapper" >

            <!-- 查询所有 并用 limit 进行 分页 -->

            <select id="findAll" resultType="com.entity.MyAccount">

                    select * from account limit #{0},#{1}

            </select>

            <!-- 查询总数 -->

            <select id="accountCount" resultType="Integer">

                    select COUNT(*) from account

            </select>

</mapper>

4.服务层(service)

package com.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Transactional;

import com.dao.MyAccountMapper;

import com.entity.MyAccount;

@Transactional

@Service

public class AccountService {

    @Autowired

    MyAccountMapper accountMapper = null;

    /**

     * 查询 所有 账户

     */

    public List<MyAccount> findAll(Integer pageNow,Integer pageSize){

         System.out.println("业务查询  >>> 查询我的所有账户");

         List<MyAccount> list = accountMapper.findAll(pageNow, pageSize);

         System.out.println("查询到的结果是 >>> " + list.toString());

        return list;

    }

    /**

     * 查询 总页数

     */

    public Integer myAccountCount(){

         System.out.println("业务查询  >>> 查询所有账户数量");

         return accountMapper.myAccountCount();

    }

}

5.控制层(Controller)

package com.web;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import javax.annotation.Resource;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpSession;

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.RequestMapping;

import com.entity.CountPage;

import com.entity.MyAccount;

import com.service.AccountService;

@Controller

public class AccountController {

    @Resource

    AccountService accountService = null;

    /**

     *    查询所有账户

     */

    @RequestMapping(value = "/account")

    public String findAll(Model model,HttpServletRequest request){

        //获取当前页数

        String pageNow=request.getParameter("pageNow");

        //获取总页数

        int totalCount=(int)accountService.myAccountCount();

        //初始化 CountPage 对象 page

        CountPage page=null;

        //new 一个 集合  把数据 放进集合里

        List<MyAccount> list=new ArrayList<MyAccount>();

        if (pageNow!=null) {

            page=new CountPage(Integer.parseInt(pageNow), totalCount);

            list=this.accountService.findAll(page.getStartPos(),page.getPageSize());

        }else {

            page=new CountPage(1, totalCount);

            list=this.accountService.findAll(page.getStartPos(),page.getPageSize());

        }

        //把数据放到 model 中并转发到 jsp 页面

        model.addAttribute("list", list);

        model.addAttribute("page", page);

        return "myaccount";

    }

}

6.页面代码(JSP)

<div class="pager">

          <font size="2">共 ${page.totalPageCount} 页</font> <font size="2">第

            ${page.pageNow} 页</font> <a href="account?pageNow=1">首页</a>

        <c:choose>

            <c:when test="${page.pageNow - 1 > 0}">

                <a href="account?pageNow=${page.pageNow - 1}">上一页</a>

            </c:when>

            <c:when test="${page.pageNow - 1 <= 0}">

                <a href="account?pageNow=1">上一页</a>

            </c:when>

        </c:choose>

        <c:choose>

            <c:when test="${page.totalPageCount==0}">

                <a href="account?pageNow=${page.pageNow}">下一页</a>

            </c:when>

            <c:when test="${page.pageNow + 1 < page.totalPageCount}">

                <a href="account?pageNow=${page.pageNow + 1}">下一页</a>

            </c:when>

            <c:when test="${page.pageNow + 1 >= page.totalPageCount}">

                <a href="account?pageNow=${page.totalPageCount}">下一页</a>

            </c:when>

        </c:choose>

        <c:choose>

            <c:when test="${page.totalPageCount==0}">

                <a href="account?pageNow=${page.pageNow}">尾页</a>

            </c:when>

            <c:otherwise>

                <a href="account?pageNow=${page.totalPageCount}">尾页</a>

            </c:otherwise>

        </c:choose>

       </div>

注：其中 <a href="account?pageNow=1">首页</a> ( account 是控制层(Controller) @RequestMapping(value = "/account") 的值)

巴特西

记一次 SSM 分页

最新文章

热门文章