我想要将计数查询的值赋给一个整数变量
我想要将计数查询的值赋给一个整数变量
提问于 2014-03-11 12:40:27
`String query = "select count(book_id) as book_id from library_books_details where book_id = ?";`
PreparedStatement psEnd = collegeCon.prepareStatement(query);
psEnd.setInt(1, bookId);回答 2
Stack Overflow用户
发布于 2014-03-11 12:43:39
ResultSet rs = psEnd.executeQuery();
if (rs.next()) {
int count= rs.getInt(1);
System.out.println("Count= " + count);
} else {
System.out.println("error: could not get the record counts");
} Stack Overflow用户
发布于 2014-03-11 12:43:54
根据http://docs.oracle.com/javase/tutorial/jdbc/basics/processingsqlstatements.html
数据库访问的流程是
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
String strColumn = rs.getString("....");
int intColumn= rs.getInt("....");
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/22316611
复制相关文章
相似问题
腾讯云开发者
