导读:
本文转自
http://www.blogjava.net/wyz191/articles/156923.html
=======分页BEAN========
import java.util.List;
/**
* ibatis分页Bean
* @author Administrator
*
*/
public class PageUtil {
private int curPage = 0; //当前页
private int pageSize = 0; //每页多少行
private int endSize ; //用于not in(select top endSize id)不在多少行内
private int totalRow ; //共多少行
private int totalPage ; //共多少页
public int getCurPage() {
return curPage;
}
public void setCurPage(int curPage) {
int temp = pageSize * (curPage-1);
this.setEndSize(temp);
this.curPage = curPage;
}
public int getEndSize() {
return endSize;
}
public void setEndSize(int endSize) {
this.endSize = endSize;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getTotalRow() {
return totalRow;
}
public void setTotalRow(int totalRow) {
totalPage = totalRow/pageSize;
if(totalRow%pageSize > 0)
totalPage = totalPage + 1;
this.totalRow = totalRow;
}
public int getTotalPage(){
return this.totalPage;
}
public String getToolsMenu() {
StringBuffer str = new StringBuffer("");
int next, prev;
prev = curPage - 1;
next = curPage + 1;
if (curPage > 1) {
str.append(
"首页 ");
} else {
str.append("首页 ");
}
if (curPage > 1) {
str.append(
"上页 ");
} else {
str.append("上页 ");
}
if (curPage < totalPage) {
str.append(
"下页 ");
} else {
str.append("下页 ");
}
if (totalPage > 1 && curPage != totalPage) {
str.append(
"末页 ");
} else {
str.append("末页 ");
}
str.append(" 共" + totalRow + "条记录");
str.append(" 每页
str.append("条 分" + pageSize + "页显示 转到");
str.append("
str.append(" ");
str.append(" ");
return str.toString();
}
}
========配置文件=======
=======DAO method========
public List getWaitingLeaveBill(PageUtil page){
List list = null;
try {
list = sqlMapClientTemplate.queryForList("getWaitingLeaveBillByPage",page);
} catch (Exception e) {
logger.error(e.getMessage());
}
return list;
}
=========具体操作=======
public ModelAndView toWaitingLeaveBillList(HttpServletRequest request, HttpServletResponse response){
PageUtil page = new PageUtil();
java.util.List list = leaveBillDao.getWaitingLeaveBill(page);
int temp = list.size();
if(null != request.getParameter("pageSize") && !"".equals(request.getParameter("pageSize"))){
page.setPageSize(Integer.parseInt(request.getParameter("pageSize")));
}else{
page.setPageSize(3);
}
page.setTotalRow(temp);
if(null != request.getParameter("pages") && !"".equals(request.getParameter("pages"))){
page.setCurPage(Integer.parseInt(request.getParameter("pages")));
}else{
page.setCurPage(1);
}
request.setAttribute("menu",page.getToolsMenu());
request.setAttribute("waitinglist",leaveBillDao.getWaitingLeaveBill(page));
return new ModelAndView(WAITINGLIST);
}
这是针对MS SQL的,针对MYSQL或其它数据库的情况,改动一下配置文件即可。