方法一
rsOld = stmt.executeQuery("select * from randnumber");
if(rsOld.isBeforeFirst()){
System.out.println("isBeforeFirst is true");
}else{
System.out.println("isBeforeFirst is false");
}
方法二
首先跳转到 ResultSet 最后一行,然后获取该行行号,若行号为0,则 ResultSet 为空。
rsOld = stmt.executeQuery("select * from randnumber");
rsOld.last();
if(rsOld.getRow()==0){
System.out.println("数据库存储记录为空++++++++++++++++++++++");
}
方法三
rsOld = stmt.executeQuery("select * from randnumber");
if(rsOld.next()){
System.out.println("rsOld.next() is true");
}else{
System.out.println("rsOld.next() is false");
}