【洞库】从字符串中拆分出年份和月份，绑定到SQL查询中

需求
 从输入的参数registerTime中拆分出年份和月份，然后分别绑定到SQL查询中，进行查询。

在service拆分字符串

 拆分传入的registerTime，将年份和月份放入一个Map中，然后将该Map传递给MyBatis查询。

String registerTime = "2023/01";
String[] parts = registerTime.split("/");
Map<String,Object> params = new HashMap<>();
params.put("year",parts[0]);
params.put("month",parts[1]);

List<DaylyTemHum> results = mapper.getadDaylyTemHum(params);

mapper层接收参数

public List<DaylyTemHum> getadDaylyTemHum(Map<String,Object> params)

xml代码

<select id="getadDaylyTemHum" resultType="com.zkhh.cd.vo.DaylyTemHum">
    SELECT DAY(register_time) as day,
        AVG(dry) as tem,
        AVG(relative) as hum
    FROM
        humiture
    WHERE
        is_delete = 0
      AND
        user_cave = #{username}
      AND
        YEAR(register_time) = #{year}
      AND
        MONTH(register_time) = #{month}
    GROUP BY DAY(register_time);
</select>