user.xml
只有这两个page对象调用
<![CDATA[
select * from (select rownum rn,tu.party_id,tu.user_account,tu.password,tu.valid,tu.creater_id,tu.create_time,
tu.password_status,tu.terminal_use_flag,tu.desktop_use_flag,tu.valid_desk,tu.flag,tu.work_code,tu.team_code,tu.transfer_type,tu.card_transfer_type,
tp.party_name,tor.org_name,tor.org_code,tor.manager_org_code
]]>
<![CDATA[
and rownum<=# page.end #
) A WHERE rn> ** #page.start# **
]]>
Pagination分页控制类
package bj.n22.base.common;
/**
作用：分页的控制
@author wenc
*/
public class Pagination {
/**
总记录数 */ private int rowCount;
/**
当前页 / private int currentPage = 1; /*
下一页 / private int nextPage; /*
上一页
/ private int priPage; /*
最后一页 */ private int lastPage;
/**
总页数 */ private int pageCount;
/**
每页的显示数量
*/ private int paginalNum;
/**
构造函数 初始化每页显示的条数 */ public Pagination() { paginalNum = 10; }
/**
@return Returns the pageCount. */ public int getPageCount() { return pageCount; }
/**
@param pageCount
The pageCount to set. */ public void setPageCount(int pageCount) { this.pageCount = pageCount; }
/**
@return Returns the currentPage. */ public int getCurrentPage() { return currentPage; }
/**
@param currentPage */ public void setCurrentPage(int currentPage) { if (currentPage < 1) return; this.currentPage = currentPage; }
/**
@return Returns the paginalNum. */ public int getPaginalNum() { return paginalNum; }
/**
@param paginalNum
The paginalNum to set. / public void setPaginalNum(int paginalNum) { if (paginalNum < 1) return; this.paginalNum = paginalNum; } /*
@return Returns the priPage. */ public int getPriPage() { if (currentPage > 1) { priPage = currentPage - 1; } else { priPage = currentPage; } return priPage; }
/**
@return */ public int getLastPage() { lastPage = rowCount % paginalNum == 0 ? rowCount / paginalNum : rowCount / paginalNum + 1; return lastPage; }
/**
@return / public int getNextPage() { getLastPage(); if (currentPage < lastPage) { nextPage = currentPage + 1; } else { nextPage = currentPage; } return nextPage; } /*
@param rowCout
The rowCout to set. */ public void setRowCount(int rowCount) { if (rowCount < 0) return; this.rowCount = rowCount; pageCount = rowCount / paginalNum; if (rowCount % paginalNum !=0){ pageCount =pageCount + 1; } }
/**
@return the rowCount */ public int getRowCount() { return rowCount; }
/**用于 oracle查询时的起始记录数
@return */ public int getStart(){ return (this.getCurrentPage() -1) * this.getPaginalNum(); }
/**用于 oracle查询时的截止记录数
@return */ public int getEnd(){ return this.getCurrentPage() * this.getPaginalNum(); }
/** 设置当前页，从客户端获取的字符串时方便调用
@param currentPage */ public void setCurrentPage(String currentPage){ int curPage=1; if (currentPage !=null && !"".equals(currentPage.trim())){ curPage =Integer.parseInt(currentPage); } this.setCurrentPage(curPage); }
}
Action类
public String searchUsers() throws UnsupportedEncodingException {
Pagination page = new Pagination();
String currentPage = request.getParameter("currentPage");
page.setCurrentPage(currentPage);
//获得登陆用户角色
UserSession user = SessionManager.getLoginUser(request);
//获得登陆用户所在机构ID
String userOrgCode = user.getOrgCode();
if( !userOrgCode.equals(SystemConstant.SUPER_ORG_CODE)){
if(model.getOrgCode()==null && model.getOrgName()==null ){
model.setOrgCode(userOrgCode);
model.setOrgName(user.getOrgName());
}
}
//获得用户所属渠道
model.setChannelCode(user.getChannelCode());
//如果从启动移动展业跳转而来的，要对中文参数进行转码
String stemFrom = request.getParameter("stemFrom");
if(StringUtils.isNotEmpty(stemFrom)){
model.setPartyName(new String(model.getPartyName().getBytes("ISO-8859-1"), "UTF-8"));
model.setOrgName(new String(model.getOrgName().getBytes("ISO-8859-1"), "UTF-8"));
}
QueryResult result = usersService.searchUsers(model, page);