怎么得到PreparedStatement查询条数的结果

mac2025-05-13  12

方法一:

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);
最新回复(0)