在对于数据求和时返回值为null , 报如下错误:
![](https://img-blog.csdn.net/20180812194136222?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoaWNodXd1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70)
数据库语句如下:
SELECT
FROM
user
WHERE
user_id =#{userid} and YEARWEEK(date_format(create_time,'%Y-%m-%d')) = YEARWEEK(now())-1 and is_delete!='1'
报错原因:数据库中没有符合该条件记录 , 求和没有结果
解决方法:在数据库语句中加个Case语句
SELECT
CASE
WHEN
SUM(integral) is null Then 0
ELSE SUM(integral)
END
FROM
user
WHERE
user_id =#{userid} and YEARWEEK(date_format(create_time,'%Y-%m-%d')) = YEARWEEK(now())-1 and is_delete!='1'
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)