JAVA 取数据库里的汇总数据
各位大虾:
有如下一条sql语句:select sum(Ototal) as tsum from Psale
我现在要在java中取到这个汇总的tsum 怎么取呢?
sql = "select sum(Ototal) as tsum from v_isale";
rs=stmt.executeQuery();
rs.next();
Fsale fsale = new Fsale();
fsale.setCname("总销售额:");
fsale.setOtotal(rs.getFloat("tsum"));
我这样set值的时候出错,错误信息是:
java.sql.SQLException: Column 'tsum' not found.
求帮忙解决。