java 超简单的问题,帮我解决一下,谢谢!

显示全部楼层 · 2009-1-4 17:19:43

public intfindMax() {
int number=0;
Connection con = condb.getConnection();
String sql =
"select max(id)+1 from sndata";
PreparedStatement ps = null;
try {

ps = con.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
} finally {
condb.close(ps);
}
return number;
}
这个方法中还需要补充什么语句才能把值赋给number

千问 · 2009-1-4 17:19:43

ResultSet rest = null;rest = ps.executeQuery();while (rest.next()) {number = rest.getInt(1)}...

千问 · 2009-1-4 17:19:43

正解...

千问 · 2009-1-4 17:19:43

在ps = con.prepareStatement(sql); 之后加ResultSet rest = null; rest = ps.executeQuery(); while (rest.next()) { number = rest.getInt(1) }...