mybatis常用xml语法

    @Select("<script> " +
            "select " +
            "vga.plate_type as plateType," +
            "count(plate_info) as counts " +
            " from" +
            " vehicle_gangqu_all vga" +
            "<where>" +
            "<if test='crossCode != null and crossCode.size &gt;0'>" +
            " and  vga.cross_code in " +
            "                <foreach collection=\"crossCode\" item=\"item\" open=\"(\" separator=\",\" close=\")\">\n" +
            "                     #{item} \n" +
            "                </foreach>" +
            "</if>" +
            "<if test='searchCarParamDTO.startTime != null and searchCarParamDTO.startTime.length &gt;0 '>" +
            "   and toStartOfDay(vga.pass_time) BETWEEN  #{searchCarParamDTO.startTime} AND  #{searchCarParamDTO.startTime} " +
            "</if>" +
            "</where>" +
            "group by " +
            " vga.plate_type  </script>")
    L

 mysql字段按照逗号分隔查询

SELECT
    * 
FROM
    waste_room_info 
WHERE
    deleted = 0 
    AND FIND_IN_SET(1,scale_code)

 mysql的like查询和按照年月日查询

  <select id="selectAlarmData" resultType="com.zygh.hzhw.manage.dto.SiteAlarmRecordDTO">
        SELECT
            id,
            site_name,
            site_type,
            plat_number,
            alarm_state,
            alarm_time
        FROM
            site_alarm_record
        WHERE
            site_name LIKE CONCAT('%',#{siteName},'%')
          AND plat_number = #{platNumber}
          and date_format(alarm_time,'%Y-%m-%d')=#{time}
    </select>

 mybatis字符串判断

   <where>
            <if test="siteName != null and siteName!='' ">
                site_name LIKE CONCAT('%',#{siteName},'%')
            </if>
            <if test="platNumber != null and platNumber!='' ">
                AND plat_number = #{platNumber}
            </if>
            <if test="time != null and time!='' ">
                and date_format(alarm_time,'%Y-%m-%d')=#{time}
            </if>
           
        </where>