Struts+Spring+MyBatis MVC模式实现分页分页查询

fish3129

首先引用一个写好的翻页模板工具类

import java.util.List;
/*
* 翻页模板工具类
*
* */
public final class PageModel<T> {
private int currentPage;// 当前页
private int pageSize;// 每页显示条数
private int totalPage;// 总页数
private int totalRecord;// 总记录数
private List<T> dataList;// 分页数据
private PageModel() {
}
/*
* 初始化PageModel实例
*/
private PageModel(final int pageSize, final String page, final int totalRecord) {
// 初始化每页显示条数
this.pageSize = pageSize;
// 设置总记录数
this.totalRecord = totalRecord;
// 初始化总页数
setTotalPage();
// 初始化当前页
setCurrentPage(page);
}
/*
* 外界获得PageModel实例
*/
public static PageModel newPageModel(final int pageSize, final String page,
final int totalRecord) {
return new PageModel(pageSize, page, totalRecord);
}
// 设置当前请求页
private void setCurrentPage(String page) {
try {
currentPage = Integer.parseInt(page);
} catch (java.lang.NumberFormatException e) {
// 这里异常不做处理，当前页默认为1
currentPage = 1;
}
// 如果当前页小于第一页时，当前页指定到首页
if (currentPage < 1) {
currentPage = 1;
}
if (currentPage > totalPage) {
currentPage = totalPage;
}
}
private void setTotalPage() {
if (totalRecord % pageSize == 0) {
totalPage = totalRecord / pageSize;
} else {
totalPage = totalRecord / pageSize + 1;
}
}
/*
* 获得当前页
*/
public int getCurrentPage() {
return currentPage;
}
/*
* 获得总页数
*/
public int getTotalPage() {
return totalPage;
}
/*
* 获得开始行数
*/
public int getStartRow() {
return (currentPage - 1) * pageSize;
}
/*
* 获得结束行
*/
public int getEndRow() {
return currentPage * pageSize;
}
/*
* 获得翻页数据
*/
public List<T> getDataList() {
return dataList;
}
/*
* 设置翻页数据
*/
public void setDataList(List<T> dataList) {
this.dataList = dataList;
}
//首页
public int getFirst() {
return 1;
}
//
//上一页
public int getPrevious() {
return currentPage - 1;
}
//
// // 下一页
public int getNext() {
return currentPage + 1;
}
//
// // 尾页
//
public int getLast() {
return totalPage;
}

Action中
public String showBorrowPage() {
Integer currentPage;
String page = this.getParameter("page");
// totalRecor计算
int totalRecord = 0;
try {
totalRecord = borrowManagerService.selectTotalRecord();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
PageModel pageModel = PageModel.newPageModel(3, page,
totalRecord);
List<Borrow> dataList = new ArrayList<Borrow>();
try {
dataList = borrowManagerService.pageSelect(pageModel);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pageModel.setDataList(dataList);
this.getReqeust().put("pageModel", pageModel);
this.getReqeust().put("currentPage",pageModel.getCurrentPage());
//System.out.println(pageModel.getTotalPage());
return "showBorrowPage";
}
serviece层

package com.weixin.bm.rack.service;
public class BorrowManagerServiceImpl implements BorrowManagerService {
private BorrowDao borrowDao;
public final void setBorrowDao(BorrowDao borrowDao) {
this.borrowDao = borrowDao;
}
//分页查询
public List<Borrow> pageSelect(PageModel pageModel) throws SQLException {
List<Borrow> borrowList = new ArrayList<Borrow>();
borrowList = borrowDao.pageSelect(pageModel.getStartRow(), pageModel
.getEndRow());
return borrowList;
}
//计算总条数
public int selectTotalRecord() throws SQLException {
int totalRecord = borrowDao.selectTotalRecord();
return totalRecord;
}
}

dao层
package com.weixin.bm.rack.dao;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import com.weixin.bm.rack.po.Borrow;
public class BorrowDaoImpl extends SqlSessionDaoSupport implements BorrowDao {
private final static String BM_BORROW_NAMESPACE = "com.weixin.bm.rack.po.BorrowMapper.";
//分页查询
public List<Borrow> pageSelect(int startRow,int endRow) throws SQLException {
List<Borrow> borrowList = new ArrayList<Borrow>();
Map params =new HashMap();
params.put("startRow", new Integer(startRow));
params.put("endRow", new Integer(endRow));
borrowList = this.getSqlSession().selectList(BM_BORROW_NAMESPACE+"pageSelect",params);
return borrowList;
}
//得到总条数
public int selectTotalRecord() throws SQLException {
int totalRecord = (Integer)this.getSqlSession().selectOne(BM_BORROW_NAMESPACE+"selectTotalRecord");
return totalRecord;
}
}
Mybatis配置

<?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.weixin.bm.rack.po.BorrowMapper">
<!-- 结果集映射 -->
<resultMap type="Borrow" id="BorrowResultMap">
<result property="id" column="id" />
<result property="managerId" column="manager_id" />
<result property="borrowerId" column="borrower_id" />
<result property="bookId" column="book_id" />
<result property="borrowDate" column="borrow_date" />
<result property="returnDate" column="return_date" />
<result property="returnFlag" column="return_flag" />
</resultMap>
<!-- 一对多配置 -->
<resultMap type="Borrow" id="borrow2Book" extends="BorrowResultMap">
<association property="book" column="book_id" javaType="Book"
select="com.weixin.bm.rack.po.BookMapper.selectBookById" />
</resultMap>
<!-- 分页查询 -->
<select id="pageSelect" resultMap="borrow2Book" parameterType="map">
<![CDATA[
select * from (select * from  (select  id,            
manager_id ,      
borrower_id ,     
book_id,         
borrow_date,        
return_date,      
return_flag,
rownum rn
FROM bm_borrow)
where rn <= #{endRow} )
where rn > #{startRow}
]]>
</select>
<!-- 查询总条数-->
<select id="selectTotalRecord" resultType="int">
select count(*) from bm_borrow
</select>

</mapper>

实体层

package com.weixin.bm.rack.po;
import java.util.Date;
public class Borrow{
private int id;
private int managerId;
private int borrowerId;
private int bookId;
private Date borrowDate;
private Date returnDate;
private String returnFlag;
private Book book;
public Borrow(){
}
省略Set和Get方法

展示层

<s:set var="pageModel" value="#request.pageModel"/>
<s:iterator var="borrow" value="#pageModel.dataList">
<tr>
<td width="200" height="35" align="center"><s:property value="#borrow.id"/></td>
<td height="35" align="center"><s:property value="#borrow.book.category.categoryName"/></td>
<td height="35" align="center"><s:property value="#borrow.book.bookName"/></td>
<td height="35" align="center"><s:property value="#borrow.book.bookAuthor"/></td>
<td height="35" align="center"><s:property value="#borrow.book.bookPublish"/></td>
<td height="35" align="center"><s:property value="#borrow.borrowDate"/></td>
<td height="35" align="center"><s:property value="#borrow.returnDate"/></td>
<td height="35" align="center"><s:property value="#borrow.returnFlag"/></td>
</tr>
</s:iterator>

<tr>
<td width="200" height="35" align="center"><a href="book_showMainPage">首页</a></td>
<td height="35" colspan="5" align="center"><a><s:property value="#request.currentPage"/></a>/<a><s:property value="#request.totalPage"/></a>   
<a href="borrow_showBorrowPage?page=<s:property value='#pageModel.first'/>">首页</a>
<a href="borrow_showBorrowPage?page=<s:property value='#pageModel.previous'/>">上一页</a>
<a href="borrow_showBorrowPage?page=<s:property value='#pageModel.next'/>">下一页</a>
<a href="borrow_showBorrowPage?page=<s:property value='#pageModel.last'/>">尾页</a>
<td height="35" align="center" ><a >导出Excel</a></td>
<td height="35" align="center" ><a >打印</a></td>
</tr>


其中的Struts ,Spring配置不就写出来了，写得不好，不要喷我