报错:
org.apache.ibatis.binding.BindingException: Mapper method 'com.shopping.dao.OrderMapper.selectYesterdaySales attempted to return null from a method with a primitive return type (double).
报错代码:
<select id="selectYesterdaySales" resultType="Double">
select sum(price) from orders where TO_DAYS(NOW( )) - TO_DAYS(createtime) = 1 and status !=0
</select>
原 因:price求和为空,并把null复制给了Double
解 决 方 法 :再返回值前判断是否为空,如果为空,返回0,并将Double改为double
代码修改为:
<select id="selectYesterdaySales" resultType="double">
select IFNULL(sum(price),0) from orders where TO_DAYS(NOW( )) - TO_DAYS(createtime) = 1 and status !=0
</select>