IFNULL()方法
IFNULL(expr1,expr2)
如果expr1不是NULL,IFNULL()返回expr1,否则它返回expr2。IFNULL()返回一个数字或字符串值
String sql = "SELECT IFNULL(SUM(order_amount),0) FROM order_card_device WHERE user_id = '"+ userId +"'"+"AND pay_status = 1 AND del_flag = 0 AND iz_refund = 0" ; List<Map<String, Object>> maps = baseInfoService.selectForSql(sql); System.out.println(maps);
List<Map<String, Object>> maps = baseInfoService.selectForSql(sql); System.out.println(maps);