JSP實現的簡單分頁樣本_JSP編程

來源:互聯網
上載者:User

本文執行個體講述了JSP實現的簡單分頁樣本。分享給大家供大家參考,具體如下:

<%@ page language="java" import="java.util.*" contentType="text/html; charset=gbk"%><%@ page import="com.yx.page.db.*"%><%@ page import="java.sql.*" %><html> <head>  <title>My JSP 'page01.jsp' starting page</title> </head> <body> <center> <%!  final String jspURL = "page04.jsp";  %> <% // 定義如下分頁變數 // 1、定義每頁要顯示的記錄數 int lineSize = 10 ; // 2、定義一個當前是第幾頁 int currentPage = 1 ; //接受傳過來的當前頁 %> <% try{  currentPage = Integer.parseInt(request.getParameter("cp")); }catch(Exception e){  e.printStackTrace(); } %> <% Connection conn = null; PreparedStatement pStmt = null; ResultSet rs = null; GetConnection getConnection = new GetConnection(); //自訂資料庫連接操作 DAO %> <script language="javascript"> function openPage(curpage){  document.form1.cp.value=curpage;  document.form1.submit(); } </script> <form action="<%=jspURL%>" method="post" name="form1"> <input name="button1" type="button" value="首頁" onClick="openPage(1)"> <input name="button2" type="button" value="上一頁" onClick="openPage(<%=currentPage-1%>)"> <input name="button3" type="button" value="下一頁" onClick="openPage(<%=currentPage+1%>)"> <input name="button4" type="button" value="尾頁"> <input name="cp" type="hidden" value="" /> </form> <table width="80%" border="1"> <% try{ String strSql= "select * from person"; pStmt = getConnection.getPreStatement(strSql); rs = pStmt.executeQuery(); %> <tr> <td align="center">編號</td> <td align="center">登陸名稱</td> <td align="center">姓名</td> <td align="center">密碼</td> <td colspan="2" align="center">操作</td> </tr> <% for(int x=0; x<(currentPage-1)*lineSize; x++){  rs.next(); } for(int x=0; x<lineSize; x++){  if(rs.next()){  int id = rs.getInt(1);  String uid = rs.getString(2);  String name = rs.getString(3);  String pass = rs.getString(4); %> <tr>  <td><%=id%></td>  <td><%=uid%></td>  <td><%=name%></td>  <td><%=pass%></td>  <td>更改</td>  <td>刪除</td> </tr> <%  } } }catch(Exception e){ %> <h4>系統有錯誤</h4> <% e.printStackTrace(); }finally{ getConnection.getAllClose(conn,pStmt,rs); } %> </table> </center> </body></html>

希望本文所述對大家JSP程式設計有所協助。

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.