解决问题的代码如下:
/*
* Created on 2005-8-17
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* @author iQUEEN
*/
public class RsLastTest {
public static void main (String[] args) throws ClassNotFoundException,
SQLException {
Class.forName("dm.jdbc.driver.DmDriver"); //$NON-NLS-1$
Connection conn = DriverManager.getConnection("jdbc:dm://localhost", //$NON-NLS-1$
"******", "******"); //$NON-NLS-1$ //$NON-NLS-2$
Statement stmt = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
//采用conn.createStatement();
//会出现:java.sql.SQLException: 不能使用于该类型的结果集
ResultSet rs = stmt.executeQuery("select * from systables"); //$NON-NLS-1$
rs.last();
int rc = rs.getRow();
rs.close();
stmt.close();
conn.close();
System.out.println(rc);
}
}
出错信息:
/*
* Created on 2005-8-17
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* @author iQUEEN
*/
public class RsLastTest {
public static void main (String[] args) throws ClassNotFoundException,
SQLException {
Class.forName("dm.jdbc.driver.DmDriver"); //$NON-NLS-1$
Connection conn = DriverManager.getConnection("jdbc:dm://localhost", //$NON-NLS-1$
"******", "******"); //$NON-NLS-1$ //$NON-NLS-2$
Statement stmt = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
//采用conn.createStatement();
//会出现:java.sql.SQLException: 不能使用于该类型的结果集
ResultSet rs = stmt.executeQuery("select * from systables"); //$NON-NLS-1$
rs.last();
int rc = rs.getRow();
rs.close();
stmt.close();
conn.close();
System.out.println(rc);
}
}
出错信息:
java.sql.SQLException: 不能使用于该类型的结果集
dm4.jdbc.dbaccess.DBError.throwSQLException(DBError.java:55)
dm4.jdbc.driver.DmdbResultSet.last(DmdbResultSet.java:2975)
com.onceas.pool.jdbc.B.last(com/onceas/pool/jdbc/B)
org.apache.jsp.datacata.test_jsp._jspService(test_jsp.java:60)
问题分析:
如果是 ResultSet.TYPE_FORWARD_ONLY类型的结果集,那么只能用next()方法来逐行扫描而不能利用first()、last()等方法。
first()、last()等方法是滚动结果集(TYPE_SCROLL_INSENSITIVE 或TYPE_SCROLL_SENSITIVE )所特有的。
解决方案:
用制定结果集类型的方法来创建句柄conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);