至今还没有, 只有 resultSet.last(); int rowCount=resultSet.getRow();
但我用 resultSet.last(); int rowCount=resultSet.getRow();却抛出下列异常 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156) at oracle.jdbc.driver.BaseResultSet.last(BaseResultSet.java:75)
rs为结果集。 int row=0; if(rs.next()) { rs.last(); row=rs.getRow(); rs.beforeFirst(); }
Statement stmt = conn.createStatement();
String sql="select count(*) from nodesite where ...";
ResultSet rst = stmt.executeQuery(sql);
if(rst.next())
rst.getInt(1);
而直接select id from ....却较快
所以我想java能不能有直接取得行数的方法。
只有
resultSet.last();
int rowCount=resultSet.getRow();
resultSet.last();
int rowCount=resultSet.getRow();却抛出下列异常
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156) at oracle.jdbc.driver.BaseResultSet.last(BaseResultSet.java:75)
int row=0;
if(rs.next())
{
rs.last();
row=rs.getRow();
rs.beforeFirst();
}