javaweb的struts2的分頁查詢操作

分頁查詢的實現：
1.利用action完成
action有成員變量：
除了實體對象的屬性還有
// 分頁顯示
public int totalRecord;
// 每頁顯示條數
public int limitRecord = 5;
// 當前頁
public int nowPage = 1;
// 總頁數
public int totalPage;
// 實體對象查詢結果集合
private LinkedList op;

2.sql語句：
select * from tb_userinfo where id="" limit a,b
這樣只會查詢a，b條間的記錄。
是分頁實現的一種方式。

直接上代碼
1.后臺：
查詢action類
說明：
**delete()方法是查詢主要實現。
gettotal()是獲取總記錄數與總頁數
JDBC_S是查詢model層
**

public String sql_s(String sql) {}//處理sql
可以使用其他方式實現，反正需要一個完整的sql;自己實現
Jdbc_DBCP_xiu是數據庫鏈接池。

package controller.option;import java.sql.Connection; import java.sql.ResultSet; import java.util.LinkedList; import org.apache.struts2.ServletActionContext;import com.dbcp.Jdbc_DBCP_xiu;import model.linku.JDBC_S; import model.linku.UserX;public class UserXselect extends UserXinfo {/*** @author joker* * action 分頁查詢信息表tb_userinfo數據*/private static final long serialVersionUID = -8974990156314709622L;// 分頁顯示public int totalRecord;// 每頁顯示條數public int limitRecord = 5;// 當前頁public int nowPage = 1;// 總頁數public int totalPage;// 結果集合private LinkedList<UserX> op;public LinkedList<UserX> getOp() {return op;}public int getNowPage() {return nowPage;}public void setNowPage(int nowPage) {this.nowPage = nowPage;}public int getTotalRecord() {return totalRecord;}public int getTotalPage() {return totalPage;}public void setOp(LinkedList<UserX> op) {this.op = op;}// 獲取查詢結果的總記錄數總頁數public void getTotal() {try {String sql = this.sql_s("select count(*) from tb_userinfo where ");Connection co = Jdbc_DBCP_xiu.getConnection();// 獲取查詢結果的總記錄數總頁數java.sql.PreparedStatement p = co.prepareStatement(sql);ResultSet result = p.executeQuery();// 設置結果while (result.next()) {this.totalRecord = result.getInt(1);// 取整if ((totalRecord % limitRecord) > 0)// 向上取整this.totalPage = ((int) (totalRecord / limitRecord)) + 1;else// 取整this.totalPage = ((int) (totalRecord / limitRecord));if (this.totalPage <= 0) {this.totalPage = 1;}}Jdbc_DBCP_xiu.release(co, p, result);} catch (Exception e1) {// TODO 自動生成的 catch 塊}return;}// 處理整合數據public String sql_s(String sql) {if (!id.equals(""))sql = sql + "id='" + id + "' and ";if (!name.equals(""))sql = sql + "name='" + name + "' and ";if (!sex.equals(""))sql = sql + "sex='" + sex + "' and ";if (!local.equals(""))sql = sql + "local='" + local + "' and ";if (!status.equals(""))sql = sql + "status='" + status + "' and ";if (!lv.equals(""))sql = sql + "lv='" + lv + "' and ";// 表單傳遞String form = "id=" + id + "&name=" + name + "&sex=" + sex + "&status=" + status + "&lv=" + lv + "&local="+ local;ServletActionContext.getRequest().getSession().setAttribute("theFinfo", form);if (sql.lastIndexOf("and ") + 4 <= sql.length() && sql.lastIndexOf("and ") >= 0)sql = sql.substring(0, sql.lastIndexOf("and ") - 1);if (sql.length() <= "select * from tb_userinfo where ".length())return "";return sql;}public String select() throws Exception {// TODO 自動生成的方法存根// 獲取查詢結果的總記錄數總頁數this.getTotal();String sql = this.sql_s("select * from tb_userinfo where ");if (sql.equals("")) {this.addFieldError("id", "至少輸入一項信息！！！");return INPUT;} else {JDBC_S s = new JDBC_S(sql + "limit " + (nowPage - 1) * limitRecord + "," + limitRecord);LinkedList<UserX> op1 = s.getSelectResult();if (!op1.isEmpty()) {op = op1;return SUCCESS;} else {this.addFieldError("id", "查詢無信息！！！");return INPUT;}}} }

JDBC_S.java(查詢model層)

package model.linku;import java.sql.Connection; import java.sql.ResultSet; import java.util.LinkedList;import com.dbcp.Jdbc_DBCP_xiu; import com.opensymphony.xwork2.ActionSupport;public class JDBC_S extends ActionSupport {/*** @author joker* *select */private static final long serialVersionUID = -391369734025576555L;private LinkedList<UserX> select = new LinkedList<>();public LinkedList<UserX> getSelectResult() {return select;}public JDBC_S(String sql) {this.query(sql);}private void query(String sql) {try {Connection co = Jdbc_DBCP_xiu.getConnection();java.sql.PreparedStatement p = co.prepareStatement(sql);ResultSet result = p.executeQuery();// 設置結果while (result.next()) {UserX u = new UserX(result.getString("id"),result.getString("name"), result.getString("sex"), result.getString("local"),result.getString("status"), result.getString("lv"));this.select.add(u);}Jdbc_DBCP_xiu.release(co, p, result);} catch (Exception e1) {// TODO 自動生成的 catch 塊}}}

2.前端：

select.jsp
op是action的成員

上一頁，下一頁的query.action自己配置

<s:form class="input" action="query.action" method="post"><s:textfield class="input1" name="id" label="ID查找"></s:textfield><s:textfield class="input1" name="name" label="姓名查找"></s:textfield><s:textfield class="input1" name="local" label="地域查找"></s:textfield><s:textfield class="input1" name="lv" label="修為查找"></s:textfield><s:radio name="sex" label="性別查找" list="#{'男':'男','女':'女'}"></s:radio><s:radio name="status" list="#{'存活':'存活','死亡':'死亡'}" label="狀態查找"></s:radio><s:submit value="查詢數據信息"></s:submit></s:form><s:if test="op"><div class="table">查詢結果表</div><div class="table" style="border: 3px solid white"><table class="table"><thead><tr class="table"><th class="th">ID</th><th class="th">姓名</th><th class="th">性別</th><th class="th">出生地</th><th class="th">當前狀態</th><th class="th">當前修為</th></tr></thead><tbody><s:form theme="simple"><s:iterator value="op" var="x"><tr class="table"><td class="td"><s:property value="%{#x.id}" /></td><td class="td"><s:property value="%{#x.name}" /></td><td class="td"><s:property value="%{#x.sex}" /></td><td class="td"><s:property value="%{#x.local}" /></td><td class="td"><s:property value="%{#x.status}" /></td><td class="td"><s:property value="%{#x.lv}" /></td></tr></s:iterator></s:form></tbody></table><div class="tablex">&nbsp;&nbsp;每次限制查詢與操作的記錄數：<s:property value="%{limitRecord}" />&nbsp;<s:if test="%{nowPage-1}"></s:if><s:if test="nowPage>1"><s:a href="query.action?nowPage=%{nowPage-1}&%{#session.theFinfo}">上一頁</s:a></s:if><s:if test="nowPage<totalPage"><s:a href="query.action?nowPage=%{nowPage+1}&%{#session.theFinfo}">下一頁</s:a></s:if>&nbsp;&nbsp;當前為第<s:property value="%{nowPage}" />頁&nbsp;&nbsp;,共<s:property value="%{totalPage}" />頁&nbsp;,共<s:property value="%{totalRecord}" />條記錄&nbsp;</div></div></s:if>

ok

總結

以上是生活随笔為你收集整理的javaweb的struts2的分页查询操作的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。