MyBatis-Plus sum函数求和

MyBatis-Plus 中使用 sum函数求和

QueryWrapper<CmsVideo> ew = new QueryWrapper<>();
ew.eq("user_id", userId );
ew.select("IFNULL(sum(give_num),0) AS giveNum");
Map<String, Object> map = cmsVideoService.getMap(ew);
System.out.println(map);

打印 map结果

{giveNum=15}

对应的sql语句

==>  Preparing: SELECT IFNULL(sum(give_num),0) AS giveNum FROM cms_video WHERE (user_id = ?) 
==> Parameters: 1(Long)
<==    Columns: giveNum
<==        Row: 15
<==      Total: 1