public int getCount() throws SQLException {
int count = 0;
Connection conn = JDBCUtil.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = null;
String sql = "SELECT COUNT(bid) FROM book";
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if (rs.next()) {
count = rs.getInt(1);
}
} finally {
JDBCUtil.closeConn(conn, null, stmt, rs);
}
return count;
}
使用JDBC获取select count(*) from xxx的结果,受影响行数
最新推荐文章于 2022-08-25 15:50:24 发布