电梯直达

1楼 [收藏(0)] [报告]

发表于 2011-12-21 08:44 |只看该作者 |倒序浏览

根据前面的一个代码Page和PaginationHelper类可以查出第几页的数据返回一个List

Servlet层：

// 分析当前页码
String pageString=req.getParameter("page");
if(pageString == null || pageString.length() == 0) {
pageString = "1";
}
int currentPage= 0 ;
try {
currentPage = Integer.parseInt(pageString);// 当前页码
} catch(Exception e) {}
if(currentPage == 0) {
currentPage = 1;
}
int pageSize = 30;//每页显示的数据数
PaginationHelper<EipSms> ph = new PaginationHelper<EipSms>();
List<EipSms> ls=new ArrayList<EipSms>();
Page<EipSms> p=ph.fetchPage(
jdbc,
"SELECT COUNT(*) FROM EIP_SMS WHERE CUSERID=? AND STATUS='1'",
"SELECT PK_EIP_SMS,RUSER,CONTENT,CTIME FROM EIP_SMS WHERE CUSERID=? AND STATUS='1'",
new Object[]{pageUser.getUserID()},
currentPage,
pageSize,
new ParameterizedRowMapper<EipSms>() {
public EipSms mapRow(ResultSet rs, int i) throws SQLException {
return new EipSms(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4));
}
}
);
ls=p.getPageItems();
req.getSession().setAttribute("ls",ls);// 保存列表
req.getSession().setAttribute("totalPage", p.getPagesAvailable());// 保存总页数
req.getSession().setAttribute("currentPage", currentPage);// 保存当前页码
res.sendRedirect("resources/sms/sms_draft.jsp");

表现层：

<td>
<%-- 输出页面跳转代码, 分链接和静态文字两种 --%>
<c:if test="${currentPage > 1}">
[ <a href="${pageContext.request.contextPath}/showsms?type=draft&page=${currentPage-1}">上一页</a> ]
</c:if>
<c:if test="${currentPage <= 1}">
[ 上一页 ]
</c:if>
<c:if test="${currentPage < totalPage}">
[ <a href="${pageContext.request.contextPath}/showsms?type=draft&page=${currentPage+1}">下一页</a> ]
</c:if>
<c:if test="${currentPage >= totalPage}">
[ 下一页 ]
</c:if>
<%-- 输出 JavaScript 跳转代码 --%>
<script>
// 页面跳转函数
// 参数: 包含页码的表单元素，例如输入框，下拉框等
function jumpPage(input) {
// 页码相同就不做跳转
if(input.value == ${currentPage}) {
return;
}
var newUrl = "${pageContext.request.contextPath}/showsms?type=draft&page=" + input.value;
document.location = newUrl;
}
</script>
转到
<select onchange='jumpPage(this);'>
<c:forEach var="i" begin="1" end="${totalPage}">
<option value="${i}"
<c:if test="${currentPage == i}">
selected
</c:if>
>第${i}页</option>
</c:forEach>
</select>
</td>

Spring Jdbc的分页操作 [复制链接]