？？求助？？如何得到数据库中记录个数？？

Question

str = "select count(*) from trade";
rs3 = stmt.executeQuery(str);
if(rs3 != null && rs3.next())
{
   int nCount = rs3.getInt(1);
}

Answer 1

/**
           * 返回记录集总数
           * @param rs
           * @return 返回记录集总数
           */
          public static int getResultSetCount(ResultSet rs){
              try{
                  if (rs.next()){
                     rs.last();
                     int cnt = rs.getRow();
                     rs.beforeFirst();
                     return cnt;
                  } else
                      return 0;
              } catch (Exception e){
                  return 0;
                }
          }

Answer 2

建议使用select count(*) from trade

Answer 3

建议使用 gloomyboy() ( ) 的