[项目构建]babasport 分页的使用及解析.

             1
            package
             cn.itcast.core.controller;

             2
             3
            import
             java.util.List;

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

             6
            import
             org.springframework.stereotype.Controller;

             7
            import
             org.springframework.ui.Model;

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

             9
            10
            import
             cn.itcast.common.page.Pagination;

            11
            import
             cn.itcast.core.bean.product.Brand;

            12
            import
             cn.itcast.core.service.product.BrandService;

            13
            14
            /*
            15
             * 品牌

            16
            */
            17
            @Controller

            18 @RequestMapping(value="/brand")
19publicclass BrandController {
2021    @Autowired
22private BrandService brandService;
2324     @RequestMapping(value="/list.do")
25public String list(Integer pageNo, String name, Integer isDisplay, Model model){
26//List<Brand> brands = brandService.selectBrandListByQuery(name, isDisplay);27         Pagination pagination = brandService.selectPaginationByQuery(pageNo, name, isDisplay);
28         model.addAttribute("pagination", pagination);
29//回显查询条件30         model.addAttribute("name", name);
31if(isDisplay != null){
32             model.addAttribute("isDisplay", isDisplay);
33         }else{
34             model.addAttribute("isDisplay", 1);
35        }
36return "brand/list";
37    }
3839     @RequestMapping(value="/toEdit.do")
40public String selectBrandById(Long id, Model model){
4142         Brand brand = brandService.selectBrandById(id);
43         model.addAttribute("brand", brand);
4445return "brand/edit";
46    }
47 }

             1
            package
             cn.itcast.core.service.product;

             2
             3
            import
             java.util.List;

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

             6
            import
             org.springframework.stereotype.Service;

             7
            import
             org.springframework.transaction.annotation.Transactional;

             8
             9
            import
             cn.itcast.common.page.Pagination;

            10
            import
             cn.itcast.core.bean.product.Brand;

            11
            import
             cn.itcast.core.bean.product.BrandQuery;

            12
            import
             cn.itcast.core.dao.product.BrandDao;

            13 @Service("brandService")
14@Transactional
15publicclass BrandServiceImpl implements BrandService {
1617    @Autowired
18private BrandDao brandDao;
1920    @Override
21public List<Brand> selectBrandListByQuery(String name, Integer isDisplay) {
22         BrandQuery brandQuery = new BrandQuery();
23if (name != null) {
24            brandQuery.setName(name);
25        }
26if (isDisplay != null) {
27            brandQuery.setIsDisplay(isDisplay);
28        }
29else {
30//是: 1, 否:031             brandQuery.setIsDisplay(1);
32        }
3334return brandDao.selectBrandListByQuery(brandQuery);
35    }
3637//分页38public Pagination selectPaginationByQuery(Integer pageNo, String name, Integer isDisplay) {
39         BrandQuery brandQuery = new BrandQuery();
40//设置当前页  cpn方法: 如果pageNumber 是null或者 小于1, 那么就将pageNumber设置为1, 如果不是则使用传递进来的pageNumber41        brandQuery.setPageNo(Pagination.cpn(pageNo));
42//设置每页数43         brandQuery.setPageSize(3);
4445//拼接条件46         StringBuilder sb = new StringBuilder();
4748if (name != null) {
49            brandQuery.setName(name);
50             sb.append("name=").append(name);
51        }
5253if (isDisplay != null) {
54            brandQuery.setIsDisplay(isDisplay);
55             sb.append("&isDisplay=").append(isDisplay);
56        }
57else {
58//是: 1, 否:059             brandQuery.setIsDisplay(1);
60             sb.append("&isDisplay=").append(1);
61        }
62//构建分页对象
63//三个参数: 当前页,每页显示行数,总记录数64         Pagination pagination = new Pagination(brandQuery.getPageNo(), brandQuery.getPageSize(), brandDao.selectCount(brandQuery));
65//查询结果集
66//使用查询语句: select * from bbs_brand where ... limit (pageNumber - 1) * 3, 367        pagination.setList(brandDao.selectBrandListByQuery(brandQuery));
6869//分页在页面显示 /brand/list.do?name=aaa&&isDisplay=070         String url = "/brand/list.do";
71        pagination.pageView(url, sb.toString());
7273return pagination;
74    }
7576//通过ID查询一个品牌77public Brand selectBrandById(Long id){
78return brandDao.selectBrandById(id);
79    }
8081 }

            1
            /**
            2
                 * 检查页码 checkPageNo

            3
                 * 

            4
                 * 
            @param
             pageNo

            5
                 * 
            @return
             if pageNo==null or pageNo<1 then return 1 else return pageNo

            6
            */
            7
            public
            static
            int
             cpn(Integer pageNo) {

            8
            return (pageNo == null || pageNo < 1) ? 1 : pageNo;
9     }

             1
            //
            构建分页对象

             2
            //
            三个参数: 当前页,每页显示行数,总记录数
             3 Pagination pagination = new Pagination(brandQuery.getPageNo(), brandQuery.getPageSize(), brandDao.selectCount(brandQuery));
 4//查询结果集
 5//使用查询语句: select * from bbs_brand where ... limit (pageNumber - 1) * 3, 3 6pagination.setList(brandDao.selectBrandListByQuery(brandQuery));
 7 8//分页在页面显示 /brand/list.do?name=aaa&&isDisplay=0 9 String url = "/brand/list.do";
10 pagination.pageView(url, sb.toString());

             1 <?xml version="1.0" encoding="UTF-8" ?>  
 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 3 4 <mapper namespace="cn.itcast.core.dao.product.BrandDao">
 5 6     <resultMap type="Brand" id="brand">
 7          <result column="img_url" property="imgUrl"/>
 8          <result column="is_display" property="isDisplay"/>
 9     </resultMap>
10     <!-- 查询品牌结果集  List<Brand> -->
11     <select id="selectBrandListByQuery" parameterType="BrandQuery" resultMap="brand">
12        select id ,name,description,img_url,is_display,sort
13        from bbs_brand
14         <where>
15             <if test="name != null">
16                 name like "%"#{name}"%"
17             </if>
18             <if test="isDisplay != null">
19                 and is_display = #{isDisplay}
20             </if>
21         </where>
22         <if test="startRow != null">
23            limit #{startRow}, #{pageSize}
24         </if>
25     </select>
2627     <!-- 查询品牌结果集  List<Brand> -->
28     <select id="selectCount" parameterType="BrandQuery" resultType="Integer">
29         select count(1)
30        from bbs_brand
31         <where>
32             <if test="name != null">
33                 name like "%"#{name}"%"
34             </if>
35             <if test="isDisplay != null">
36                 and is_display = #{isDisplay}
37             </if>
38         </where>
39     </select>
4041     <!-- 根据ID查询 -->
42     <select id="selectBrandById" parameterType="Long" resultMap="brand">
43        select id ,name,description,img_url,is_display,sort
44        from bbs_brand
45         <where>
46             id = #{id}
47         </where>
48     </select>
49 </mapper>

              1
            package
             cn.itcast.core.bean.product;

              2
              3
            import
             java.io.Serializable;

              4
              5
            public
            class BrandQuery implements Serializable{
  6/**  7     * 默认的ID
  8*/  9privatestaticfinallong serialVersionUID = 1L;
 10 11//品牌ID  bigint 12private Long id;
 13//品牌名称 14private String name;
 15//描述 16private String description;
 17//图片URL 18private String imgUrl;
 19//排序  越大越靠前    20private Integer sort;
 21//是否可用   0 不可用 1 可用 22private Integer isDisplay;//is_display 23public Long getId() {
 24return id;
 25    }
 26publicvoid setId(Long id) {
 27this.id = id;
 28    }
 29public String getName() {
 30return name;
 31    }
 32publicvoid setName(String name) {
 33this.name = name;
 34    }
 35public String getDescription() {
 36return description;
 37    }
 38publicvoid setDescription(String description) {
 39this.description = description;
 40    }
 41public String getImgUrl() {
 42return imgUrl;
 43    }
 44publicvoid setImgUrl(String imgUrl) {
 45this.imgUrl = imgUrl;
 46    }
 47public Integer getSort() {
 48return sort;
 49    }
 50publicvoid setSort(Integer sort) {
 51this.sort = sort;
 52    }
 53public Integer getIsDisplay() {
 54return isDisplay;
 55    }
 56publicvoid setIsDisplay(Integer isDisplay) {
 57this.isDisplay = isDisplay;
 58    }
 59publicstaticlong getSerialversionuid() {
 60return serialVersionUID;
 61    }
 62    @Override
 63public String toString() {
 64return "Brand [id=" + id + ", name=" + name + ", description=" + description + ", imgUrl=" + imgUrl + ", sort="
 65                 + sort + ", isDisplay=" + isDisplay + "]";
 66    }
 67 68//附加字段
 69//当前页 70private Integer pageNo = 1;
 71 72//每页数 73private Integer pageSize = 10;
 74 75//开始行 76private Integer startRow;
 77public Integer getPageNo() {
 78return pageNo;
 79    }
 80publicvoid setPageNo(Integer pageNo) {
 81//计算开始行 82this.startRow = (pageNo - 1)*pageSize;
 83this.pageNo = pageNo;
 84    }
 85public Integer getPageSize() {
 86return pageSize;
 87    }
 88publicvoid setPageSize(Integer pageSize) {
 89//计算开始行 90this.startRow = (pageNo - 1)*pageSize;
 91this.pageSize = pageSize;
 92    }
 93public Integer getStartRow() {
 94return startRow;
 95    }
 96publicvoid setStartRow(Integer startRow) {
 97this.startRow = startRow;
 98    }
 99100101 }

             1
            //
            附加字段

             2
            //
            当前页
             3
            private Integer pageNo = 1;
 4 5//每页数 6private Integer pageSize = 10;
 7 8//开始行 9private Integer startRow;
10public Integer getPageNo() {
11return pageNo;
12}
13publicvoid setPageNo(Integer pageNo) {
14//计算开始行15this.startRow = (pageNo - 1)*pageSize;
16this.pageNo = pageNo;
17}
18public Integer getPageSize() {
19return pageSize;
20}
21publicvoid setPageSize(Integer pageSize) {
22//计算开始行23this.startRow = (pageNo - 1)*pageSize;
24this.pageSize = pageSize;
25}
26public Integer getStartRow() {
27return startRow;
28}
29publicvoid setStartRow(Integer startRow) {
30this.startRow = startRow;
31 }

             1
            <%
            @ page language
            =
            "
            java
            "
             import
            =
            "
            java.util.*
            "
             pageEncoding
            =
            "
            UTF-8
            "
            %>
             2
            <%
            @ include file
            =
            "
            ../head.jsp
            "
            %>
             3
            <!
            DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
            >
             4
            <
            html 
            xmlns
            ="http://www.w3.org/1999/xhtml"
            >
             5
            <
            head
            >
             6
            <
            meta 
            http-equiv
            ="Content-Type"
             content
            ="text/html; charset=UTF-8"
            />
             7
            <
            title
            >babasport-list</title> 8</head> 9<body>10<div class="box-positon">11<div class="rpos">当前位置: 品牌管理 - 列表</div>12<form class="ropt">13<input class="add" type="button" value="添加" onclick="javascript:window.location.href=‘add.jsp‘"/>14</form>15<div class="clear"></div>16</div>17<div class="body-box">18<form action="/brand/list.do" method="post" style="padding-top:5px;">19 品牌名称: <input type="text" name="name" value="${name}"/>20<select name="isDisplay">21<option value="1" <c:if test="${isDisplay==1 }">selected="selected"</c:if>>是</option>22<option value="0" <c:if test="${isDisplay==0 }">selected="selected"</c:if>>否</option>23</select>24<input type="submit" class="query" value="查询"/>25</form>26<table cellspacing="1" cellpadding="0" border="0" width="100%" class="pn-ltable">27<thead class="pn-lthead">28<tr>29<th width="20"><input type="checkbox" onclick="checkBox(‘ids‘,this.checked)"/></th>30<th>品牌ID</th>31<th>品牌名称</th>32<th>品牌图片</th>33<th>品牌描述</th>34<th>排序</th>35<th>是否可用</th>36<th>操作选项</th>37</tr>38</thead>39<tbody class="pn-ltbody">40<c:forEach items="${pagination.list }" var="brand">41<tr bgcolor="#ffffff" onmouseout="this.bgColor=‘#ffffff‘" onmouseover="this.bgColor=‘#eeeeee‘">42<td><input type="checkbox" value="${brand.id }" name="ids"/></td>43<td align="center">${brand.id }</td>44<td align="center">${brand.name }</td>45<td align="center"><img width="40" height="40" src="/images/pic/ppp.jpg"/></td>46<td align="center"></td>47<td align="center">${brand.sort}</td>48<td align="center">49<c:if test="${brand.isDisplay == 1 }">是</c:if>50<c:if test="${brand.isDisplay == 0 }">否</c:if>51</td>52<td align="center">53<a class="pn-opt" href="/brand/toEdit.do?id=${brand.id}">修改</a> | <a class="pn-opt" onclick="if(!confirm(‘您确定删除吗？‘)) {return false;}" href="#">删除</a>54</td>55</tr>5657</c:forEach>5859</tbody>60</table>61<div class="page pb15">62<span class="r inb_a page_b">63<c:forEach items="${pagination.pageView }" var="page">64            ${page }
65</c:forEach>66</span>67</div>68<div style="margin-top:15px;"><input class="del-button" type="button" value="删除" onclick="optDelete();"/></div>69</div>70</body>71</html>

             1
            /**
             2
                 * 分页显示样示部分

             3
            */
             4
            public
            void
             pageView(String url,String params){

             5
             6          pageView = new ArrayList<String>();
 7 8if(this.pageNo != 1){
 9             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo=1‘\"><font size=2>首页</font></a>");
10             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(this.pageNo-1)+"‘\"><font size=2>上一页</font></a>");
11         }else{
12             pageView.add("<font size=2>首页</font>");
13             pageView.add("<font size=2>上一页</font>");
14        }
1516if(this.getTotalPage() <= 10){
17for (int i = 0; i < this.getTotalPage(); i++) {
18if((i+1)==this.pageNo){
19                     pageView.add("<strong>"+this.pageNo+"</strong>");
20                     i = i+1;
21if(this.pageNo==this.getTotalPage())break;
22                }
23                 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(i+1)+"‘\">"+(i+1)+"</a>");
24            }
25         }elseif(this.getTotalPage() <= 20){
26//没有把...加上27int l = 0;
28int r = 0;
29if(this.pageNo<5){
30                 l=this.pageNo-1;
31                 r=10-l-1;
32             }elseif(this.getTotalPage()-this.pageNo<5){
33                 r=this.getTotalPage()-this.pageNo;
34                 l=10-1-r;
35             }else{
36                 l=4;
37                 r=5;
38            }
39int tmp =  this.pageNo-l;
40for (int i = tmp; i < tmp+10; i++) {
41if(i==this.pageNo){
42                     pageView.add("<strong>"+this.pageNo+"</strong>");
43                     i = i+1;
44if(this.pageNo==this.getTotalPage()) break;
45                }
46                 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(i)+"‘\">"+(i)+"</a>");
47            }
4849         }elseif(this.pageNo<7){
50for (int i = 0; i < 8; i++) {
51if(i+1==this.pageNo){
52                     pageView.add("<strong>"+this.pageNo+"</strong>");
53                     i = i+1;
54                }
55                 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(i+1)+"‘\">"+(i+1)+"</a>");
56            }
57             pageView.add("...");
58             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(this.getTotalPage()-1)+"‘\">"+(this.getTotalPage()-1)+"</a>");
59             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(this.getTotalPage())+"‘\">"+(this.getTotalPage())+"</a>");
60         }elseif(this.pageNo>this.getTotalPage()-6){
61             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(1)+"‘\">"+(1)+"</a>");
62             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(2)+"‘\">"+(2)+"</a>");
63             pageView.add("...");
64for (int i = this.getTotalPage()-8; i <this.getTotalPage() ; i++) {
65if(i+1==this.pageNo){
66                     pageView.add("<strong>"+this.pageNo+"</strong>");
67                     i = i+1;
68if(this.pageNo==this.getTotalPage()) break;
69                }
70                 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(i+1)+"‘\">"+(i+1)+"</a>");
71            }
72         }else{
73             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(1)+"‘\">"+(1)+"</a>");
74             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(2)+"‘\">"+(2)+"</a>");
75             pageView.add("...");
7677             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(this.pageNo-2)+"‘\">"+(this.pageNo-2)+"</a>");
78             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(this.pageNo-1)+"‘\">"+(this.pageNo-1)+"</a>");
79             pageView.add("<strong>"+this.pageNo+"</strong>");
80             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(this.pageNo+1)+"‘\">"+(this.pageNo+1)+"</a>");
81             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(this.pageNo+2)+"‘\">"+(this.pageNo+2)+"</a>");
8283             pageView.add("...");
84             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(this.getTotalPage()-1)+"‘\">"+(this.getTotalPage()-1)+"</a>");
85             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(this.getTotalPage())+"‘\">"+(this.getTotalPage())+"</a>");
86        }    
87if(this.pageNo != this.getTotalPage()){
88             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+(this.pageNo+1)+"‘\"><font size=2>下一页</font></a>");
89             pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href=‘" + url + "?" + params + "&pageNo="+this.getTotalPage()+"‘\"><font size=2>尾页</font></a>");
90         } else{
91             pageView.add("<font size=2>下一页</font>");
92             pageView.add("<font size=2>尾页</font>");
93        }
94         pageView.add("共<var>" + getTotalPage() + "</var>页 到第<input type=‘text‘ id=‘PAGENO‘  size=‘3‘ />页 <input type=‘button‘ id=‘skip‘ class=‘hand btn60x20‘ value=‘确定‘ onclick=\"javascript:window.location.href = ‘" + url + "?" + params + "&pageNo=‘ + $(‘#PAGENO‘).val() \"/>");
95     }