http://hi.baidu.com/wszfer/item/242640c2bd121fc6994aa0cf
今天看书写一个小项目例子, 遇到一个小问题 查询一个表中记录总数, 百度了好久没找到怎么解决!后来问一一下群里面的前辈 就解决了
贴上代码就明白了
- Connection conn = DBConnection.getConnection();
- String countSQL = "select count(*) as result from message";
- PreparedStatement pstmt = null;
- ResultSet rs = null;
- int count = 0;
- try
- {
- pstmt = conn.prepareStatement(countSQL);
- rs = pstmt.executeQuery();
- while(rs.next())
- {
- count = rs.getInt(1); // count = rs.getInt("result");
- }
- }