sql.jsp:
<%@ page contentType="text/html;charset=utf-8" %>
<%@ page import="java.sql.*,java.lang.String,java.util.*" %>
<HTML>
<head>
<title>
分页显示</title>
</head>
<BODY>
<%!String xh; %>
<%!int i;%>
<%!int pageSize=6;%><!--每页显示的记录条数为3 -->
<%!int rowCount=0;%>
<%!int pageCurrent;%><!--当前页数为“pageCurrent”-->
<%!int pageCount;%><!--总页数为pageCount-->
<%!Connection con=null;%>
<%!Statement sql=null;%>
<%!ResultSet rs=null;%>
<%
/**下面这个数据库连接,的主要目的是求出总的记录数rowCount*/
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl