方法一:
PreparedStatement st = conn.prepareStatement("select count(*) from jinchun");
ResultSet rs=st.executeQuery();
while(rs.next())
{
//打印的就是总记录数。把检索结果看成只有一跳记录一个字段的表
System.out.println(rs.getInt(1));
}
方法二:
String sql_total = "select count(*) forom table";
pstmt_total = dbUtil.getConnection().prepareStatement(sql_total);
rs_total = pstmt_total.executeQuery();
rs_total.next();
int count = rs_total.getInt(1);