类型转换错误java.math.BigDecimal cannot be cast to java.lang.String
来源:互联网 发布:知乎城市冷漠 编辑:程序博客网 时间:2024/06/08 15:47
数据库获取统计参数sum()统计值,在代码转化为Integer 时,提示转换失败:java.math.BigDecimal cannot be cast to java.lang.String
解决办法:
List set= util.excuteQuery("select COALESCE(sum(1),0) as times from wlsq_data.home_pet_feeder_timing where gateway_id=? and timing_id=? and del_flag=0 ", objs);if(set !=null && set.size() >0){for(Object obj:set){HashMap<String, Object> map =(HashMap<String, Object>)obj;Integer str = Integer.parseInt(map.get("times").toString());if(str == 0){ result = 0; }else{ result = str; }} }使用coalesce 函数,解决统计数据为空,默认赋值为0;
0 0
- 类型转换错误java.math.BigDecimal cannot be cast to java.lang.String
- 类型转换错误java.math.BigDecimal cannot be cast to java.lang.String
- 类型转换错误java.math.BigDecimal cannot be cast to java.lang.String
- 类型转换错误java.math.BigDecimal cannot be cast to java.lang.String
- 类型转换错误类似java.math.BigDecimal cannot be cast to java.lang.Double 解决办法
- java.math.BigDecimal cannot be cast to java.lang.String
- java.math.BigDecimal cannot be cast to java.lang.String
- java.math.BigDecimal cannot be cast to java.lang.String错误
- 【错误集锦】——java.math.BigDecimal cannot be cast to java.lang.String
- ERROR [FileOperation] java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
- java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
- java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
- java.lang.ClassCastException:java.math.BigDecimal cannot be cast to java.lang.String
- java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
- java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String 解决
- 关于 java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
- java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
- java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
- javascript 字符串对象方法
- 解析友盟错误分析
- Java中的类详解
- Java 实现导出excel表 POI
- APP后端数据接口注意事项
- 类型转换错误java.math.BigDecimal cannot be cast to java.lang.String
- vertex cover problem with dynamic programming
- jenkins远程部署使用shell脚本进行备份
- c中的inf和nan
- linq 判断时间出错
- cygwin 上编译和安装redis
- 特征值和特征向量理解
- SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
- javascript 数组对象方法