(转载)Java java.sql.ResultSet 获得总行数

Statement stmt = con.createStatement();
ResultSet rset = stmt.executeQuery("select * from yourTableName");
rset.last(); // 将光标移动到最后一行
int rowCount = rset.getRow(); // 得到当前行号,即结果集记录数

Ref:

  1. https://blog.csdn.net/caixiexin/article/details/6670498
  2. https://blog.csdn.net/magi1201/article/details/32370659
posted @ 2021-10-23 13:46  摘叶飞镖  阅读(122)  评论(0)    收藏  举报