快捷導(dǎo)航

MybatisPlus結(jié)合groupby實(shí)現(xiàn)分組和sum求和的步驟

更新時(shí)間：2023年12月11日 09:53:42 作者：知識(shí)淺談

這篇文章主要介紹了MybatisPlus結(jié)合groupby實(shí)現(xiàn)分組和sum求和的步驟,這次使用的是LambdaQueryWrapper,使用QueryWrapper相對(duì)來(lái)說(shuō)簡(jiǎn)單點(diǎn)就不寫(xiě)了,本文分步驟給大家介紹的非常詳細(xì),感興趣的朋友一起看看吧

?MybatisPlus結(jié)合groupby實(shí)現(xiàn)分組和sum求和

這次使用的是LambdaQueryWrapper，使用QueryWrapper相對(duì)來(lái)說(shuō)簡(jiǎn)單點(diǎn)就不寫(xiě)了

??實(shí)現(xiàn)GroupBy分組

第一步: 實(shí)體類中新增一個(gè)字段count

@TableName(value ="user")
@Data
public class User implements Serializable {
    @TableId(type = IdType.AUTO)
    private Integer id;
    @TableField(value = "name")
    private String name;
    @TableField(value = "age")
    private Integer age;
    @TableField(value = "state")
    private String state;
    @TableField(exist = false)
    private static final long serialVersionUID = 1L;
	//這個(gè)地方
    @TableField(value = "count(*)",insertStrategy = FieldStrategy.NEVER,updateStrategy = FieldStrategy.NEVER)
    private  Integer count;
}

第二步：查詢接口中修改

   @GetMapping("/count")
   public List<User> count(){
       new QueryWrapper<>()
       LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
       queryWrapper.select(User::getState,User::getCount);
       queryWrapper.groupBy(User::getState);
       List<User> list = userService.list(queryWrapper);
       return list;
   }

返回的結(jié)果

[
{
"id": null,
"name": null,
"age": null,
"state": "1",
"count": 3
},
{
"id": null,
"name": null,
"age": null,
"state": "2",
"count": 2
}
]

??實(shí)現(xiàn)GroupBy分組之后再sum求和

第一步: 實(shí)體類中新增一個(gè)字段count

@TableName(value ="user")
@Data
public class User implements Serializable {
    @TableId(type = IdType.AUTO)
    private Integer id;
    @TableField(value = "name")
    private String name;
    @TableField(value = "age")
    private Integer age;
    @TableField(value = "state")
    private String state;
    @TableField(exist = false)
    private static final long serialVersionUID = 1L;
    @TableField(value = "count(*)",insertStrategy = FieldStrategy.NEVER,updateStrategy = FieldStrategy.NEVER)
    private  Integer count;
	//這個(gè)地方
    @TableField(value = "sum(age)",insertStrategy = FieldStrategy.NEVER,updateStrategy = FieldStrategy.NEVER)
    private  Integer ages;
}

第二步：查詢接口中修改

   @GetMapping("/count")
   public List<User> count(){
       new QueryWrapper<>()
       LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
       //這個(gè)地方新增了一個(gè)字段
       queryWrapper.select(User::getState,User::getCount,User::getAges);
       queryWrapper.groupBy(User::getState);
       List<User> list = userService.list(queryWrapper);
       return list;
   }

返回的結(jié)果

[
{
"id": null,
"name": null,
"age": null,
"state": "1",
"count": 3,
"ages": 6
},
{
"id": null,
"name": null,
"age": null,
"state": "2",
"count": 2,
"ages": 9
}
]

??總結(jié)

到此這篇關(guān)于MybatisPlus結(jié)合groupby實(shí)現(xiàn)分組和sum求和的文章就介紹到這了,更多相關(guān)MybatisPlus分組sum求和內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！