（J2EE）Struts+Spring+MyBatis整合实现分页分页查询(二)
e");
// 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 dataList = new ArrayList();
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层
[java]
package com.qianyan.bm.rack.service;
public class BorrowManagerServiceImpl implements BorrowManagerService {
private BorrowDao borrowDao;
public final void setBorrowDao(BorrowDao borrowDao) {
this.borrowDao = borrowDao;
}
//分页查询
public List pageSelect(PageModel pageModel) throws SQLException {
List borrowList = new ArrayList();
borrowList = borrowDao.pageSelect(pageModel.getStartRow(), pageModel
.getEndRow());
return borrowList;
}
//计算总条数
public int selectTotalRecord() throws SQLException {
int totalRecord = borrowDao.selectTotalRecord();
return totalRecord;
}
}
dao层
[java]
package com.weixin.bm.rack.dao;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import com.qianyan.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 pageSelect(int startRow,int endRow) throws SQLException {
List borrowList = new ArrayList();
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配置
[java]
< xml version="1.0" encoding="UTF-8" >