java 中 从ResultSet获取select count统计结果

存档

 

//获取总记录数
      ResultSet rs = statement.executeQuery("select count(*) from user_info where userid='00000001' and userpass='admin'" );

     if (rs.next())
       {

             //rs.getInt(int columnIndex )-------->columnIndex the first column is 1, the second is 2, ...
             recordCount = rs.getInt(1);
       }

       就是rs.getInt(1)而已！