select UserName,MachineName,sum(TotalPages) as TotalPages ,isnull(sum(Count),'0') as TotalCount,isnull(Dept,'非域登录帐号') as Dept,isnull(SysUserName,UserName) as SysUserName,isnull(MajorName,'') as MajorName from PrintLog Group by UserName,MachineName,Dept,SysUserName,MajorName order by Dept,UserName Desc
是用sql语句直接得到Object obj = rs.getObject(colsName[i]);
其中isnull(sum(Count),'0') 得到的值是0.00
最后算出来的结果是是数字类型,不能用int 或者long double取
需要DecimalFormat 来取
DecimalFormat decimalFormat = new DecimalFormat( ".00 "); //保留2个小数点
String s = decimalFormat.format(rows.get("TotalCount"));
double a=Double.parseDouble(s);
cost=(int)a;
System.out.println(cost);
取整数