String sql="SELECT count(*) as ResidentCount FROM Resident r ,house h WHERE r.houseid = h.ID and h.buildingid = '"+Sid+"'"; ResultSet rs=stmt.executeQuery(sql); String COUNT= rs.getInt("ResidentCount");这样吗?
String sql="select * from Building where id like '"+Sid+"'"; String sqll ="SELECT count(*) as ResidentCount FROM Resident r ,house h WHERE r.houseid = h.ID and h.buildingid = '"+Sid+"'"; ResultSet rss=stmt.executeQuery(sqll); String count = rss.getInt("ResidentCount"); System.out.println(count); ResultSet rs=stmt.executeQuery(sql);
ResultSet rss=stmt.executeQuery(sqll); int count = rss.getInt("ResidentCount"); 加了这个数据库连不上了
基础 ResultSet rs=stmt.executeQuery(sql); if(rs.next()){ int count = rs.getInt("ResidentCount"); System.out.println(count); }
String sql="select * from Building where id like '"+Sid+"'"; String sqll ="SELECT count(*) as ResidentCount FROM Resident r ,house h WHERE r.houseid = h.ID and h.buildingid = '"+Sid+"'"; ResultSet rss=stmt.executeQuery(sqll); String count=""; String Fool=""; String Area=""; while(rss.next()){ count= rss.getString(1); System.out.println(count); } ResultSet rs=stmt.executeQuery(sql); while(rs.next()){ Fool=rs.getString(3); Area=rs.getString(5); }能不能把2个查询并成一个
加了这个数据库连不上了
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
int count = rs.getInt("ResidentCount");
System.out.println(count);
}
ResultSet rs=stmt.executeQuery(sql); while(rs.next()){ Fool=rs.getString(3); Area=rs.getString(5);
}能不能把2个查询并成一个