怎样用变量接收select语句获取的最大值

显示全部楼层 · 2011-6-9 08:32:23

String sql2="select max(zong) from t_weisheng where year=? and month=?";
pstat=conn.prepareStatement(sql2);
pstat.setString(1,year);
pstat.setString(2,month);
rs1=pstat.executeQuery();
rs1.getInt("zong");这样获取zong列的值，会说列名无效
怎么获取呢谢谢

千问 · 2011-6-9 08:32:23

String sql2="select max(zong) as maxZong from t_weisheng where year=? and month=?";pstat=conn.prepareStatement(sql2);pstat.setString(1,year);pstat.setString(2,month);rs1=pstat.executeQuery();rs1.getInt("maxZong");...

千问 · 2011-6-9 08:32:23

rs1[0][0]...

千问 · 2011-6-9 08:32:23

while(rs1.next()){
int x=rs1.getInt("zong");}...