1.ibatis配置:list集合查询
select ID, NAME, NOTE, POLICIES, SN, MODIFY_DATE, SYS
from USER_OA.T_RES_ROLE
where ID = #id:VARCHAR#
2.Dao配置:
public List selectUsersByServId(String servId, int pageNum,
int pageSize) throws SQLException {
// TODO Auto-generated method stub
List list = sqlMapClient.queryForList(
"P4_01.selectUsersByServId",
servId, pageNum, pageSize);
return list;
}
3.分页类(SplitPageForm)
public class SplitPageForm {
/*
* 当前页号
*/
private String pageNum = null;
/*
* 每页显示条数
*/
private String pageSize = "8";
/*
* 总记录数
*/
private String rowCount = null;
public int getPageCount() {
int pageCount=(getRowCount() + getPageSize() - 1) / getPageSize();
if(pageCount==0){pageCount=1;}
return pageCount;
}
public int getPageNum() {
if (pageNum == null) { pageNum = "1";
}
return Integer.valueOf(pageNum);
}
public void setPageNum(String pageNum) {
this.pageNum = pageNum;
}
public int getPageSize() {
if (pageSize == null) {
pageSize = "8";
}
return Integer.valueOf(pageSize);
}
public int getRowCount() {
if (rowCount == null) {
rowCount = "0";
}
return Integer.valueOf(rowCount);
}
public void setRowCount(String rowCount) {
this.rowCount = rowCount;
}
public int getStartRowNum() {
return (getPageNum() - 1) * getPageSize();
}
}
4.Form设置将属性包装成Form类,继承分页类SplitPageForm。5.Action设置
String count = String.valueOf(dao.countInfo());// 得到总数 form.setRowCount(count);// 设置总记录数 List<TResDict> dictList = dao.selectInfoByExample(example, form .getStartRowNum(), form.getPageSize()); form.setDictList(dictList);
6.JS配置
function prePage() { var p = parseInt(document.getElementById("form.pageNum").value); p = p - 1;
if (p < 1) { p = 1; } document.getElementById("form.pageNum").value = p; document.all.queryFrm.submit(); } function nextPage() { var p = parseInt(document.getElementById("form.pageNum").value); var max = parseInt(document.getElementById("form.pageCount").value) p = p + 1; if (p > max) { p = max; } document.getElementById("form.pageNum").value = p; document.all.queryFrm.submit(); } function firstPage() { document.getElementById("form.pageNum").value = 1; document.all.queryFrm.submit(); } function lastPage() { var max = parseInt(document.getElementById("form.pageCount").value) document.getElementById("form.pageNum").value = max; document.all.queryFrm.submit(); }
7.jsp页面设置
在循环的末尾加入:
<div style="height:25px; margin-top:10px;"> <table border="0" style="width: 97%; font-size:13px; margin-top:10px;"> <tfoot> <tr align="right"> <td> <s:form id="queryFrm" action="p3_03_01.do" method="post"> <s:hidden name="form.pageNum" id="form.pageNum" /> <s:hidden name="form.pageCount" id="form.pageCount" /> <s:hidden name="type" id="type" /> <%@include file="../page.jsp" %> </s:form> </td> </tr> </tfoot> </table> </div>