Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2"); rs.afterLast() ; rs.previous(); int number = rs.getRow();number 是你要的记录数
Statement smt=con.createStatement(); ResultSet rst=smt.executeQuery("SELECT * FROM Table1"); int i=0; while(rst.next()) { i++; } System.out.println(i);
java中数据集没有这样的属性!
con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2");
rs.afterLast() ;
rs.previous();
int number = rs.getRow();number 是你要的记录数
ResultSet rst=smt.executeQuery("SELECT * FROM Table1");
int i=0;
while(rst.next())
{
i++;
}
System.out.println(i);
Statement stmt =
con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
取出结果集rs后,取其最后一条记录的row值,就是结果条数
if(rs.last()) {//跳到最后一条记录
int i = rs.getRow();
System.out.println(i);//i即为所求
}
然后计算数组的长度