今天看书写一个小项目例子, 遇到一个小问题 查询一个表中记录总数, 百度了好久没找到怎么解决!后来问一一下群里面的前辈 就解决了
贴上代码就明白了
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");
}
}