学步园

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);

取整数