<%
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql = "select round(MAX(userId)) maxId from t_user";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next())
{
int empNo = rs.getInt("maxId");
out.print(empNo);
}
%>
-- 从sqlplus下查询最大userId是3,这里取出的却是0。究竟是哪的问题?
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql = "select round(MAX(userId)) maxId from t_user";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next())
{
int empNo = rs.getInt("maxId");
out.print(empNo);
}
%>
-- 从sqlplus下查询最大userId是3,这里取出的却是0。究竟是哪的问题?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货