java分頁語句怎麼寫
- 綜合知識
- 關注:1W次
轉一個jsp分頁<%@ page contentType="text/html;charset=8859_1" %><%//變數宣告java.sql.Connection sqlCon; //資料庫連線物件java.sql.Statement sqlStmt; //SQL語句物件java.sql.ResultSet sqlRst; //結果集物件java.lang.String strCon; //資料庫連線字串java.lang.String strSQL; //SQL語句int intpageSize; //一頁顯示的記錄數int intRowCount; //記錄總數int intPageCount; //總頁數int intPage; //待顯示頁碼java.lang.String strPage;int i;//設定一頁顯示的記錄數intPageSize = 2;//取得待顯示頁碼strPage = request.getParameter("page");if(strPage==null){//表明在QueryString中沒有page這一個引數,此時顯示第一頁資料intPage = 1;}else{//將字串轉換成整型intPage = java.lang.Integer.parseInt(strPage);if(intPage<1) intPage = 1;}//裝載JDBC驅動程式java.sql.DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());//設定資料庫連線字串strCon = "jdbc:oracle:thin:@linux:1521:ora4cweb";//連線資料庫sqlCon = java.sql.DriverManager.getConnection(strCon,"hzq","hzq");//建立一個可以滾動的只讀的SQL語句物件sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);//準備SQL語句strSQL = "select name,age from test";//執行SQL語句並獲取結果集sqlRst = sqlStmt.executeQuery(strSQL);//獲取記錄總數sqlRst.last();intRowCount = sqlRst.getRow();//記算總頁數intPageCount = (intRowCount+intPageSize-1) / intPageSize;//調整待顯示的頁碼if(intPage>intPageCount) intPage = intPageCount;%>
<meta ; charset=gb2312">姓名 | 年齡 |
---|---|
<%=sqlRst.getString(1)%> | <%=sqlRst.getString(2)%> |