js|oracle| Pagination | data | database | Display <%--
Author: He Zhiqiang [hhzqq@21cn.com]
Date: 2000-08-03
Version: 1.0
Functions: JSP database Operations routines-Data paging display-JDBC 2.0-oracle
--%>
<%@ page contenttype= "Text/html;charset=8859_1"%>
<%
Variable declaration
Java.sql.Connection Sqlcon; Database Connection objects
Java.sql.Statement sqlstmt; SQL Statement Object
Java.sql.ResultSet Sqlrst; Result set Object
Java.lang.String Strcon; Database connection string
Java.lang.String strSQL; SQL statement
int intpagesize; Number of records displayed on one page
int introwcount; Total Records
int intpagecount; Total pages
int intpage; Page number to display
Java.lang.String strpage;
int i;
Set the number of records to display on a page
Intpagesize = 2;
Get the number to display
Strpage = request.getparameter ("page");
if (strpage==null) {//indicates that there is no page this parameter in QueryString, the first page data is now displayed
Intpage = 1;
}
else{//converts a string to an integral type
Intpage = Java.lang.Integer.parseInt (strpage);
if (intpage<1) intpage = 1;
}
Load JDBC Driver
Java.sql.DriverManager.registerDriver (New Oracle.jdbc.driver.OracleDriver ());
To set the database connection string
Strcon = "Jdbc:oracle:thin: @linux: 1521:ora4cweb";
Connecting to a database
Sqlcon = Java.sql.DriverManager.getConnection (Strcon, "Hzq", "hzq");
Create a read-only SQL statement object that can be scrolled
sqlstmt = Sqlcon.createstatement (java.sql.resultset.type_scroll_insensitive,java.sql.resultset.concur_read_only) ;
Preparing SQL statements
strSQL = "Select Name,age from Test";
Execute the SQL statement and get the result set
Sqlrst = Sqlstmt.executequery (strSQL);
Get Total Records
Sqlrst.last ();
Introwcount = Sqlrst.getrow ();
Count Total Pages
Intpagecount = (introwcount+intpagesize-1)/intpagesize;
Adjust the number of pages to be displayed
if (intpage>intpagecount) intpage = Intpagecount;
%>
<meta http-equiv= "Content-type" content= "text/html; charset=gb2312 ">
<TITLE>JSP database operation Routines-data paging display-JDBC 2.0-oracle</title>
<body>
<table border= "1" cellspacing= "0" cellpadding= "0" >
<tr>
<th> name </th>
<th> Age </th>
</tr>
<%
if (intpagecount>0) {
Position the record pointer over the first record of the page you want to display
Sqlrst.absolute ((intPage-1) * intpagesize + 1);
Display data
i = 0;
while (I<intpagesize &&!sqlrst.isafterlast ()) {
%>
<tr>
<td><%=sqlrst.getstring (1)%></td>
<td><%=sqlrst.getstring (2)%></td>
</tr>
<%
Sqlrst.next ();
i++;
}
}
%>
</table>
<%=intPage%> page Total <%=intPageCount%> page <%if (intpage<intpagecount) {%><a href= Jdbc20-oracle.jsp?page=<%=intpage+1%> "> Next page </a><%}%> <%if (intpage>1) {%><a href=" Jdbc20-oracle.jsp?page=<%=intpage-1%> "> Prev </a><%}%>
</body>
<%
Close result set
Sqlrst.close ();
Close an SQL statement object
Sqlstmt.close ();
Close Database
Sqlcon.close ();
%>
