对于mybatisplus的queryWrapper

对于mybatisplus的queryWrapper

1.分组分页查询

 QueryWrapper<IuNotice> queryWrapper = new QueryWrapper<>();
        queryWrapper.select("count(*) as noticeNumber," +
                "standard_project_name as standardProjectName," +
                "modality as modality ,standard_second_body_part as standardSecondBodyPart")
                .groupBy("standard_project_name,modality,standard_second_body_part")
                .eq("operate_type_id", checkAnalysisVo.getOperateTypeId())
                .eq(StringUtils.isNotEmpty(checkAnalysisVo.getModality()), "modality", checkAnalysisVo.getModality())
                .ge("notice_time", checkAnalysisVo.getStartTime())
                .lt("notice_time", checkAnalysisVo.getEndTime())
                .like(StringUtils.isNotEmpty(checkAnalysisVo.getStandardProjectName()), "standard_project_name", checkAnalysisVo.getStandardProjectName())
                .like(StringUtils.isNotEmpty(checkAnalysisVo.getStandardSecondBodyPart()), "standard_second_body_part", checkAnalysisVo.getStandardSecondBodyPart())
                .orderByDesc("noticeNumber");

 Preparing: SELECT count(*) as noticeNumber,standard_project_name as standardProjectName,modality as modality ,standard_second_body_part as standardSecondBodyPart FROM iu_notice WHERE (operate_type_id = ? AND notice_time >= ? AND notice_time < ?) GROUP BY standard_project_name,modality,standard_second_body_part ORDER BY noticeNumber DESC LIMIT ?
==> Parameters: 5(String), 2021-01-14 00:00:00(String), 2023-02-13 00:00:00(String), 10(Long)
<==    Columns: noticeNumber, standardProjectName, modality, standardSecondBodyPart
<==        Row: 563, CT胸部平扫, CT, 胸部
<==        Row: 228, CT头颅平扫, CT, 头颅
<==        Row: 196, CT头颅平扫, , 头颅
<==        Row: 110, CT胸部平扫, , 胸部
<==        Row: 75, DX左足正位片, DR, 左足
<==        Row: 61, CT盆腔平扫, CT, 盆腔
<==        Row: 56, DX胸部正位片, DR, 胸部
<==        Row: 44, CT眼睛平扫, , 眼睛
<==        Row: 38, DX左足斜位片, DR, 左足
<==        Row: 28, DX右侧腕关节侧位片, DR, 右侧腕关节
<==      Total: 10

//mp中使用的一些方法
.last("limit 5")//取五条
.isNotNull("standard_project_name")//is not null
.ne("standard_project_name", "")//不等于
.ge("operate_time", checkAnalysisVo.getStartTime())//大于等于 gt是大于
.lt("operate_time", checkAnalysisVo.getEndTime())//小于  le是小于等于

2.注解的方式实现

//注解的方式实现
@DS("clickhouse")
@Select("select count(his_user_id) from iu_digital_images_analysis.iu_operate " +
        "where hospital_id=#{hospitalId} and operate_type_id=#{operateTypeId}")
Integer queryCountUseTimesByHospitalId(@Param("operateTypeId") String operateTypeId, @Param("hospitalId") String hospitalId);