ResultSet rs = stmt.executeQuery("select classname,(select count(id) from hinfo_list) as num from hinfo_class");
while( rs.next() ) {
String cName = rs.getString("classname");
}
rs.close();
stmt.close();
while( rs.next() ) {
String cName = rs.getString("classname");
}
rs.close();
stmt.close();
stat
ResultSet rs = stmt.executeQuery("SELECT classname FROM hinfo_class");
while(rs.next()){
String cName = rs.getString("classname");
ResultSet rss = stmt.executeQuery("SELECT COUNT(id) AS num FROM hinfo_list");
rss.next();
int num = rss.getInt("num"); }
ResultSet rss = stmt1.executeQuery("SELECT COUNT(id) AS num FROM hinfo_list");