mybatis结合分页的使用及解析.
mybatis结合分页的使用及解析.
一枝花算不算浪漫
发布于 2018-05-18 12:08:59
发布于 2018-05-18 12:08:59
首先说明: 这里分页是使用了SSM框架+ jsp 来做的, 当然分页还有其他的很多做法, 比如easyUI自带的分页效果. 但是这些原理都是很相似的, 再次只做为学习总结之用. 一, 效果图
这里的截图是来自百度, 当然我们的项目也是做成这种效果, 当点击第10页时, 相应页码数也要发生相应变化. 二, 代码实例 1, 首先我们在项目中加入了一个page 的jar包, 这个jar包有3个java文件组成, 这个jar包是事先写好的通用分页插件.
另外这里将源码也写上来: Paginable.java:
1 package cn.itcast.common.page;
2
3 /**
4 * 分页接口
5 */
6 public interface Paginable {
7 /**
8 * 总记录数
9 *
10 * @return
11 */
12 public int getTotalCount();
13
14 /**
15 * 总页数
16 *
17 * @return
18 */
19 public int getTotalPage();
20
21 /**
22 * 每页记录数
23 *
24 * @return
25 */
26 public int getPageSize();
27
28 /**
29 * 当前页号
30 *
31 * @return
32 */
33 public int getPageNo();
34
35 /**
36 * 是否第一页
37 *
38 * @return
39 */
40 public boolean isFirstPage();
41
42 /**
43 * 是否最后一页
44 *
45 * @return
46 */
47 public boolean isLastPage();
48
49 /**
50 * 返回下页的页号
51 */
52 public int getNextPage();
53
54 /**
55 * 返回上页的页号
56 */
57 public int getPrePage();
58 }SimplePage.java:
1 package cn.itcast.common.page;
2
3 /**
4 * 简单分页类
5 */
6 public class SimplePage implements java.io.Serializable,Paginable {
7
8 private static final long serialVersionUID = 1L;
9 public static final int DEF_COUNT = 20;
10
11 /**
12 * 检查页码 checkPageNo
13 *
14 * @param pageNo
15 * @return if pageNo==null or pageNo<1 then return 1 else return pageNo
16 */
17 public static int cpn(Integer pageNo) {
18 return (pageNo == null || pageNo < 1) ? 1 : pageNo;
19 }
20
21 public SimplePage() {
22 }
23
24 /**
25 * 构造器
26 *
27 * @param pageNo
28 * 页码
29 * @param pageSize
30 * 每页几条数据
31 * @param totalCount
32 * 总共几条数据
33 */
34 public SimplePage(int pageNo, int pageSize, int totalCount) {
35 setTotalCount(totalCount);
36 setPageSize(pageSize);
37 setPageNo(pageNo);
38 adjustPageNo();
39
40 }
41
42 /**
43 * 调整页码，使不超过最大页数
44 */
45 public void adjustPageNo() {
46 if (pageNo == 1) {
47 return;
48 }
49 int tp = getTotalPage();
50 if (pageNo > tp) {
51 pageNo = tp;
52 }
53 }
54
55 /**
56 * 获得页码
57 */
58 public int getPageNo() {
59 return pageNo;
60 }
61
62 /**
63 * 每页几条数据
64 */
65 public int getPageSize() {
66 return pageSize;
67 }
68
69 /**
70 * 总共几条数据
71 */
72 public int getTotalCount() {
73 return totalCount;
74 }
75
76 /**
77 * 总共几页
78 */
79 public int getTotalPage() {
80 int totalPage = totalCount / pageSize;
81 if (totalPage == 0 || totalCount % pageSize != 0) {
82 totalPage++;
83 }
84 return totalPage;
85 }
86
87 /**
88 * 是否第一页
89 */
90 public boolean isFirstPage() {
91 return pageNo <= 1;
92 }
93
94 /**
95 * 是否最后一页
96 */
97 public boolean isLastPage() {
98 return pageNo >= getTotalPage();
99 }
100
101 /**
102 * 下一页页码
103 */
104 public int getNextPage() {
105 if (isLastPage()) {
106 return pageNo;
107 } else {
108 return pageNo + 1;
109 }
110 }
111
112 /**
113 * 上一页页码
114 */
115 public int getPrePage() {
116 if (isFirstPage()) {
117 return pageNo;
118 } else {
119 return pageNo - 1;
120 }
121 }
122
123 protected int totalCount = 0;
124 protected int pageSize = 20;
125 protected int pageNo = 1;
126
127 /**
128 * if totalCount<0 then totalCount=0
129 *
130 * @param totalCount
131 */
132 public void setTotalCount(int totalCount) {
133 if (totalCount < 0) {
134 this.totalCount = 0;
135 } else {
136 this.totalCount = totalCount;
137 }
138 }
139
140 /**
141 * if pageSize< 1 then pageSize=DEF_COUNT
142 *
143 * @param pageSize
144 */
145 public void setPageSize(int pageSize) {
146 if (pageSize < 1) {
147 this.pageSize = DEF_COUNT;
148 } else {
149 this.pageSize = pageSize;
150 }
151 }
152
153 /**
154 * if pageNo < 1 then pageNo=1
155 *
156 * @param pageNo
157 */
158 public void setPageNo(int pageNo) {
159 if (pageNo < 1) {
160 this.pageNo = 1;
161 } else {
162 this.pageNo = pageNo;
163 }
164 }
165 }Pagination.java:
1 package cn.itcast.common.page;
2
3 import java.util.ArrayList;
4 import java.util.List;
5
6 /**
7 * 列表分页。包含list属性。
8 */
9 public class Pagination extends SimplePage{
10
11 public Pagination() {
12 }
13
14 /**
15 * 构造器
16 *
17 * @param pageNo
18 * 页码
19 * @param pageSize
20 * 每页几条数据
21 * @param totalCount
22 * 总共几条数据
23 */
24 public Pagination(int pageNo, int pageSize, int totalCount) {
25 super(pageNo, pageSize, totalCount);
26
27 }
28
29 /**
30 * 构造器
31 *
32 * @param pageNo
33 * 页码
34 * @param pageSize
35 * 每页几条数据
36 * @param totalCount
37 * 总共几条数据
38 * @param list
39 * 分页内容
40 */
41 public Pagination(int pageNo, int pageSize, int totalCount, List<?> list) {
42 super(pageNo, pageSize, totalCount);
43 this.list = list;
44 }
45
46 /**
47 * 第一条数据位置
48 *
49 * @return
50 */
51 public int getFirstResult() {
52 return (pageNo - 1) * pageSize;
53 }
54
55 /**
56 * 当前页的数据
57 */
58 private List<?> list;
59
60 /**
61 * 当前页的分页样式
62 */
63 private List<String> pageView;
64
65 /**
66 * 获得分页内容
67 *
68 * @return
69 */
70 public List<?> getList() {
71 return list;
72 }
73
74 /**
75 * 设置分页内容
76 *
77 * @param list
78 */
79 @SuppressWarnings("unchecked")
80 public void setList(List list) {
81 this.list = list;
82 }
83 /**
84 * 获得分页样式
85 *
86 * @return
87 */
88 public List<String> getPageView() {
89 return pageView;
90 }
91 /**
92 * 设置分页样式
93 *
94 * @param list
95 */
96 public void setPageView(List<String> pageView) {
97 this.pageView = pageView;
98 }
99
100
101 /**
102 * 分页显示样示部分
103 */
104 public void pageView(String url,String params){
105
106 pageView = new ArrayList<String>();
107
108 if(this.pageNo != 1){
109 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo=1'\"><font size=2>首页</font></a>");
110 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(this.pageNo-1)+"'\"><font size=2>上一页</font></a>");
111 }else{
112 pageView.add("<font size=2>首页</font>");
113 pageView.add("<font size=2>上一页</font>");
114 }
115
116 if(this.getTotalPage() <= 10){
117 for (int i = 0; i < this.getTotalPage(); i++) {
118 if((i+1)==this.pageNo){
119 pageView.add("<strong>"+this.pageNo+"</strong>");
120 i = i+1;
121 if(this.pageNo==this.getTotalPage())break;
122 }
123 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(i+1)+"'\">"+(i+1)+"</a>");
124 }
125 }else if(this.getTotalPage() <= 20){
126 //没有把...加上
127 int l = 0;
128 int r = 0;
129 if(this.pageNo<5){
130 l=this.pageNo-1;
131 r=10-l-1;
132 }else if(this.getTotalPage()-this.pageNo<5){
133 r=this.getTotalPage()-this.pageNo;
134 l=10-1-r;
135 }else{
136 l=4;
137 r=5;
138 }
139 int tmp = this.pageNo-l;
140 for (int i = tmp; i < tmp+10; i++) {
141 if(i==this.pageNo){
142 pageView.add("<strong>"+this.pageNo+"</strong>");
143 i = i+1;
144 if(this.pageNo==this.getTotalPage()) break;
145 }
146 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(i)+"'\">"+(i)+"</a>");
147 }
148
149 }else if(this.pageNo<7){
150 for (int i = 0; i < 8; i++) {
151 if(i+1==this.pageNo){
152 pageView.add("<strong>"+this.pageNo+"</strong>");
153 i = i+1;
154 }
155 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(i+1)+"'\">"+(i+1)+"</a>");
156 }
157 pageView.add("...");
158 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(this.getTotalPage()-1)+"'\">"+(this.getTotalPage()-1)+"</a>");
159 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(this.getTotalPage())+"'\">"+(this.getTotalPage())+"</a>");
160 }else if(this.pageNo>this.getTotalPage()-6){
161 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(1)+"'\">"+(1)+"</a>");
162 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(2)+"'\">"+(2)+"</a>");
163 pageView.add("...");
164 for (int i = this.getTotalPage()-8; i <this.getTotalPage() ; i++) {
165 if(i+1==this.pageNo){
166 pageView.add("<strong>"+this.pageNo+"</strong>");
167 i = i+1;
168 if(this.pageNo==this.getTotalPage()) break;
169 }
170 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(i+1)+"'\">"+(i+1)+"</a>");
171 }
172 }else{
173 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(1)+"'\">"+(1)+"</a>");
174 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(2)+"'\">"+(2)+"</a>");
175 pageView.add("...");
176
177 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(this.pageNo-2)+"'\">"+(this.pageNo-2)+"</a>");
178 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(this.pageNo-1)+"'\">"+(this.pageNo-1)+"</a>");
179 pageView.add("<strong>"+this.pageNo+"</strong>");
180 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(this.pageNo+1)+"'\">"+(this.pageNo+1)+"</a>");
181 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(this.pageNo+2)+"'\">"+(this.pageNo+2)+"</a>");
182
183 pageView.add("...");
184 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(this.getTotalPage()-1)+"'\">"+(this.getTotalPage()-1)+"</a>");
185 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(this.getTotalPage())+"'\">"+(this.getTotalPage())+"</a>");
186 }
187 if(this.pageNo != this.getTotalPage()){
188 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+(this.pageNo+1)+"'\"><font size=2>下一页</font></a>");
189 pageView.add("<a href=\"javascript:void(0);\" onclick=\"javascript:window.location.href='" + url + "?" + params + "&pageNo="+this.getTotalPage()+"'\"><font size=2>尾页</font></a>");
190 } else{
191 pageView.add("<font size=2>下一页</font>");
192 pageView.add("<font size=2>尾页</font>");
193 }
194 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() \"/>");
195 }
196 }2, 下面源码就是需要自己在项目中构建 下面开始从Controller(babasport-console)-->ServiceImpl(babasport-product)-->DaoMapper(babasport-dao)-->jsp展示 Controller层: BrandController.java:
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")
19 public class BrandController {
20
21 @Autowired
22 private BrandService brandService;
23
24 @RequestMapping(value="/list.do")
25 public 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);
31 if(isDisplay != null){
32 model.addAttribute("isDisplay", isDisplay);
33 }else{
34 model.addAttribute("isDisplay", 1);
35 }
36 return "brand/list";
37 }
38
39 @RequestMapping(value="/toEdit.do")
40 public String selectBrandById(Long id, Model model){
41
42 Brand brand = brandService.selectBrandById(id);
43 model.addAttribute("brand", brand);
44
45 return "brand/edit";
46 }
47 }解析: 这个controller 包括两个方法, 一个是查询分页数据, 另一个是根据ID 回显数据. 两个方法都很简单, 第一个就是根据页面传递过来的当前页数和查询条件通过service层去做进一步处理后再通过Dao层去查询结果, 将查询的结果返回后再封装到Model里面, 然后转发到视图层. 第二个方法更简单了, 通过Id查询到相应的商品然后回显数据即可. Service层: BrandServiceImpl.java:
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
15 public class BrandServiceImpl implements BrandService {
16
17 @Autowired
18 private BrandDao brandDao;
19
20 @Override
21 public List<Brand> selectBrandListByQuery(String name, Integer isDisplay) {
22 BrandQuery brandQuery = new BrandQuery();
23 if (name != null) {
24 brandQuery.setName(name);
25 }
26 if (isDisplay != null) {
27 brandQuery.setIsDisplay(isDisplay);
28 }
29 else {
30 //是: 1, 否:0
31 brandQuery.setIsDisplay(1);
32 }
33
34 return brandDao.selectBrandListByQuery(brandQuery);
35 }
36
37 //分页
38 public Pagination selectPaginationByQuery(Integer pageNo, String name, Integer isDisplay) {
39 BrandQuery brandQuery = new BrandQuery();
40 //设置当前页 cpn方法: 如果pageNumber 是null或者 小于1, 那么就将pageNumber设置为1, 如果不是则使用传递进来的pageNumber
41 brandQuery.setPageNo(Pagination.cpn(pageNo));
42 //设置每页数
43 brandQuery.setPageSize(3);
44
45 //拼接条件
46 StringBuilder sb = new StringBuilder();
47
48 if (name != null) {
49 brandQuery.setName(name);
50 sb.append("name=").append(name);
51 }
52
53 if (isDisplay != null) {
54 brandQuery.setIsDisplay(isDisplay);
55 sb.append("&isDisplay=").append(isDisplay);
56 }
57 else {
58 //是: 1, 否:0
59 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, 3
67 pagination.setList(brandDao.selectBrandListByQuery(brandQuery));
68
69 //分页在页面显示 /brand/list.do?name=aaa&&isDisplay=0
70 String url = "/brand/list.do";
71 pagination.pageView(url, sb.toString());
72
73 return pagination;
74 }
75
76 //通过ID查询一个品牌
77 public Brand selectBrandById(Long id){
78 return brandDao.selectBrandById(id);
79 }
80
81 }解析: Service层中主要来说第二个分页的方法. 1 brandQuery.setPageNo(Pagination.cpn(pageNo)); 这个cpn方法是Pagination中封装好的静态方法, 我们来看下源码:
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 }使用StringBuilder 封装查询条件, 因为当我们根据查询条件查询到的数据也有分页效果时, 这时候我们点击页码的按钮时跳转到相应的页数后, 查询条件也应该回显.
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
6 pagination.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());构建分页对象, 将查询的结果封装到pagination中, 且 将url和封装的条件封装到pageView中. 这里因为页码按钮的样式是固定的, 不固定的只是我们点击 每一个按钮跳转的url和查询的条件不同, 所以这里使用pageView属性来封装url和查询条件.
Dao层: BrandDao.xml:
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>
26
27 <!-- 查询品牌结果集 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>
40
41 <!-- 根据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>Model BrandQuery.java:
1 package cn.itcast.core.bean.product;
2
3 import java.io.Serializable;
4
5 public class BrandQuery implements Serializable{
6 /**
7 * 默认的ID
8 */
9 private static final long serialVersionUID = 1L;
10
11 //品牌ID bigint
12 private Long id;
13 //品牌名称
14 private String name;
15 //描述
16 private String description;
17 //图片URL
18 private String imgUrl;
19 //排序 越大越靠前
20 private Integer sort;
21 //是否可用 0 不可用 1 可用
22 private Integer isDisplay;//is_display
23 public Long getId() {
24 return id;
25 }
26 public void setId(Long id) {
27 this.id = id;
28 }
29 public String getName() {
30 return name;
31 }
32 public void setName(String name) {
33 this.name = name;
34 }
35 public String getDescription() {
36 return description;
37 }
38 public void setDescription(String description) {
39 this.description = description;
40 }
41 public String getImgUrl() {
42 return imgUrl;
43 }
44 public void setImgUrl(String imgUrl) {
45 this.imgUrl = imgUrl;
46 }
47 public Integer getSort() {
48 return sort;
49 }
50 public void setSort(Integer sort) {
51 this.sort = sort;
52 }
53 public Integer getIsDisplay() {
54 return isDisplay;
55 }
56 public void setIsDisplay(Integer isDisplay) {
57 this.isDisplay = isDisplay;
58 }
59 public static long getSerialversionuid() {
60 return serialVersionUID;
61 }
62 @Override
63 public String toString() {
64 return "Brand [id=" + id + ", name=" + name + ", description=" + description + ", imgUrl=" + imgUrl + ", sort="
65 + sort + ", isDisplay=" + isDisplay + "]";
66 }
67
68 //附加字段
69 //当前页
70 private Integer pageNo = 1;
71
72 //每页数
73 private Integer pageSize = 10;
74
75 //开始行
76 private Integer startRow;
77 public Integer getPageNo() {
78 return pageNo;
79 }
80 public void setPageNo(Integer pageNo) {
81 //计算开始行
82 this.startRow = (pageNo - 1)*pageSize;
83 this.pageNo = pageNo;
84 }
85 public Integer getPageSize() {
86 return pageSize;
87 }
88 public void setPageSize(Integer pageSize) {
89 //计算开始行
90 this.startRow = (pageNo - 1)*pageSize;
91 this.pageSize = pageSize;
92 }
93 public Integer getStartRow() {
94 return startRow;
95 }
96 public void setStartRow(Integer startRow) {
97 this.startRow = startRow;
98 }
99
100
101 }解析: mapper和model 这里model这接计算好了startRow, 所以在mapper就可以直接查询了.
1 //附加字段
2 //当前页
3 private Integer pageNo = 1;
4
5 //每页数
6 private Integer pageSize = 10;
7
8 //开始行
9 private Integer startRow;
10 public Integer getPageNo() {
11 return pageNo;
12 }
13 public void setPageNo(Integer pageNo) {
14 //计算开始行
15 this.startRow = (pageNo - 1)*pageSize;
16 this.pageNo = pageNo;
17 }
18 public Integer getPageSize() {
19 return pageSize;
20 }
21 public void setPageSize(Integer pageSize) {
22 //计算开始行
23 this.startRow = (pageNo - 1)*pageSize;
24 this.pageSize = pageSize;
25 }
26 public Integer getStartRow() {
27 return startRow;
28 }
29 public void setStartRow(Integer startRow) {
30 this.startRow = startRow;
31 }View层: list.jsp:
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>
56
57 </c:forEach>
58
59 </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>解析: 这里需要添加一些必要的说明: 这里 在显示分页页码的时候直接使用了 ${page}, 到底这个是怎么实现的呢? 下面来看下源码中的pageView.
1 /**
2 * 分页显示样示部分
3 */
4 public void pageView(String url,String params){
5
6 pageView = new ArrayList<String>();
7
8 if(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 }
15
16 if(this.getTotalPage() <= 10){
17 for (int i = 0; i < this.getTotalPage(); i++) {
18 if((i+1)==this.pageNo){
19 pageView.add("<strong>"+this.pageNo+"</strong>");
20 i = i+1;
21 if(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 }else if(this.getTotalPage() <= 20){
26 //没有把...加上
27 int l = 0;
28 int r = 0;
29 if(this.pageNo<5){
30 l=this.pageNo-1;
31 r=10-l-1;
32 }else if(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 }
39 int tmp = this.pageNo-l;
40 for (int i = tmp; i < tmp+10; i++) {
41 if(i==this.pageNo){
42 pageView.add("<strong>"+this.pageNo+"</strong>");
43 i = i+1;
44 if(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 }
48
49 }else if(this.pageNo<7){
50 for (int i = 0; i < 8; i++) {
51 if(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 }else if(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("...");
64 for (int i = this.getTotalPage()-8; i <this.getTotalPage() ; i++) {
65 if(i+1==this.pageNo){
66 pageView.add("<strong>"+this.pageNo+"</strong>");
67 i = i+1;
68 if(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("...");
76
77 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>");
82
83 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 }
87 if(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 }这里是直接将展示页拼接了出来, 而且加了url和查询参数. 到了这里整个分页的流程就搞完了, 下面来看下整体效果:
本文参与 腾讯云自媒体分享计划，分享自作者个人站点/博客。
原始发表：2016-08-21 ，如有侵权请联系 cloudcommunity@tencent.com 删除
评论
登录后参与评论
推荐阅读