UC知道JSP分页代码
来源：百度知道 编辑：UC知道 时间：2024/05/16 12:18:39
我在JSP分页是结果显示为：[查询结果显示]
---------------------------------
Result set type is TYPE_FORWARD_ONLY 请问各位是怎么回事？代码如下：
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*"%>
<% request.setCharacterEncoding("GB2312");%>
<html>
<head>
<title>JSP 数据库查询!</title>
</head>
<body><center><strong>[查询结果显示]</strong></center><br><HR>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:jsp","","");
Statement stmt=conn.createStatement();
try{
ResultSet rs=stmt.executeQuery("SELECT * FROM user1");
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; /
---------------------------------
Result set type is TYPE_FORWARD_ONLY 请问各位是怎么回事？代码如下：
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*"%>
<% request.setCharacterEncoding("GB2312");%>
<html>
<head>
<title>JSP 数据库查询!</title>
</head>
<body><center><strong>[查询结果显示]</strong></center><br><HR>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:jsp","","");
Statement stmt=conn.createStatement();
try{
ResultSet rs=stmt.executeQuery("SELECT * FROM user1");
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; /
你对ResultSet向后滚动的操作.但是你取得Statement 时却使用了缺省是TYPE_FORWARD_ONLY,他只支持向前滚动.要向前滚动,要设置成TYPE_SCROLL_INSENSITIVE或TYPE_SCROLL_SENSITIVE
例如:
Statement stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);