Struts2 + MySQL 实现分页
2024-08-23 02:36:46
代码结构:
package com.action; import java.util.List;
import java.util.Map; import com.bean.Pager;
import com.bean.UserInfo;
import com.dao.LendDao;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport; public class LendAction extends ActionSupport{
private int pageNow=1; //初始页为第一页
private int pageSize=3; //每页数据为4条,可调节 public String execute() throws Exception{
LendDao dao = new LendDao(); List list = dao.selectLend(pageNow, pageSize);
Pager page = new Pager(pageNow, dao.selectLendSize()); Map session = ActionContext.getContext().getSession();
session.put("userinfo", list);
session.put("pageinfo", page);
return SUCCESS;
} public int getPageNow() {
return pageNow;
} public void setPageNow(int pageNow) {
this.pageNow = pageNow;
} public int getPageSize() {
return pageSize;
} public void setPageSize(int pageSize) {
this.pageSize = pageSize;
} }
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@taglib prefix="s" uri="/struts-tags"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'index.jsp' starting page</title>
</head>
<body>
<table border="1" width="599">
<tr>
<td valign="top"><jsp:include page="lenduserinfo.jsp"></jsp:include></td>
</tr> <tr bgcolor="#E9EDF5" class="font1">
<td align="right">
<s:set name="page" value="#session.pageinfo"/>
<a href="lendaction?pageNow=1">首页</a> <s:if test="#page.hasPre">
<a href="lendaction?pageNow=<s:property value="#page.pageNow-1"/>">上一页</a>
</s:if>
<s:else>
<a href="lendaction?pageNow=1">上一页</a>
</s:else> <s:if test="#page.hasNext">
<a href="lendaction?pageNow=<s:property value="#page.pageNow+1"/>">下一页</a>
</s:if>
<s:else>
<a href="lendaction?pageNow=<s:property value="#page.totalPage"/>">下一页</a>
</s:else> <a href="lendaction?pageNow=<s:property value="#page.totalPage"/>">尾页</a>
</td>
</tr>
</table>
</body> </html>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'success.jsp' starting page</title>
</head> <body>
<table border="2">
<tr>
<td>userId</td>
<td>userName</td>
<td>userPassword</td>
</tr>
<s:iterator value="#session.userinfo" id="lend">
<tr>
<td><s:property value="#lend.userId" /></td>
<td><s:property value="#lend.userName" /></td>
<td><s:property value="#lend.userPassword" /></td>
</tr>
</s:iterator>
</table>
</body> </html>
最新文章
- BZOJ 2440: [中山市选2011]完全平方数 [容斥原理 莫比乌斯函数]
- Keepalived使用梳理
- 苹果企业账号打包发布APP流程详解
- mongodb存储过程
- python 中 sorted() 和 list.sort() 的用法
- 剑指offer-第二章算法之斐波拉契数列(青蛙跳台阶)
- SharePoint咨询师之路:设计之前的那些事三:体系结构
- C. Om Nom and Candies 巧妙优化枚举,将复杂度控制在10e6
- javascripct流程语句
- 逻辑回归应用之Kaggle泰坦尼克之灾(转)
- SQL 设计心得、逗号分隔列表
- 谈谈Facebook的聊天系统架构
- ABP 框架启程
- mysql循环插入数据
- CMDB资产管理系统开发【day26】:admin action
- 201671010142 2017-2 《java第十二章学习感悟》
- Android 通过onTouchEvent判断是否为双击事件
- robotframework连接mysql数据库
- SQL Server 之 内部连接
- 使用ScriptableObject创建.asset文件