Question

java rs结果集取值问题

Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql ="select count(*) from t_RndPwd where RndPwd_IsAvailability=0";
try{
conn = ConnectionPool.getConnection();
stmt = (Statement) conn.createStatement();
rs = (ResultSet) stmt.executeQuery(sql);
假如执行sql语句后的结果为8.那么请问我怎么从rs中取到8呢??谢谢
明白

Answer 1

...
stmt = (Statement) conn.createStatement();
rs = (ResultSet) stmt.executeQuery(sql);
rs.next();
int rows=rs.getInt(1);
rows就是你要的结果
_____________________________________________
第一列的内容
如一条记录为 id name,
getInt(1);
相当于getInt("id")