public class Test {
private Connection con = null;
private PreparedStatement prepStmt = null;
private ResultSet rs = null; public void m()
{
con = new Conne().getCon();
String sql="select count(*) as a from kind";
try {
prepStmt=con.prepareStatement(sql);
rs=prepStmt.executeQuery();
String s =rs.getString("a");
System.out.println(s);
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}如何读出这个聚合函数?谢谢
private Connection con = null;
private PreparedStatement prepStmt = null;
private ResultSet rs = null; public void m()
{
con = new Conne().getCon();
String sql="select count(*) as a from kind";
try {
prepStmt=con.prepareStatement(sql);
rs=prepStmt.executeQuery();
String s =rs.getString("a");
System.out.println(s);
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}如何读出这个聚合函数?谢谢
rs.next();
int recordCount = rs.getInt(1);
rs.close();
rs.next();
int count =rs.getInt(1);
需要先调用rs的next方法,再调用getXXXX,否则有异常