mybatis记录

1. 条件查询：

（1）接口：

@Mapper
public interface PlanBrightnessMapper extends BaseMapper<GuideScreenSyncMonitoring> {

    List<GuideScreenSyncVo> getPis (Map<String, Object> params);
}

（2）实现：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.cars.ict.rbpsems.additional.device.mapper.PlanBrightnessMapper">
    <select id="getPis" parameterType="map"
            resultType="com.cars.ict.rbpsems.vo.controlpisled.GuideScreenSyncVo">
        SELECT
            g.device_name AS ledName,
            g.ip,
            g.station AS stationName,
            g.STATUS AS faultStatus,
            rd.s_address AS region,
            g.modify_time AS modifyTime,
            rd.s_id AS deviceId,
            rd.s_device_code AS deviceCode,
            IF
            ( camera.camera_id IS NULL, '0', '1' ) AS isCamera,
            g.cpu,
            g.disk,
            g.memory,
            c.s_code AS deviceTypeCode
        FROM
            guide_screen_sync_monitoring g
            LEFT JOIN rec_device rd ON rd.s_ip = g.ip
            LEFT JOIN camera_config camera ON camera.guid = rd.s_id
            LEFT JOIN b_stationinfrelatree srd ON srd.id = rd.s_station_region_id
            LEFT JOIN rec_device_category c ON c.s_id = rd.s_device_category_id
        <where>
            c.s_code IN ( '0203' )
            <if test="stationId != null and stationId != ''">
                and rd.s_station_id = #{stationId}
            </if>
            <if test="regionName != null and regionName != ''">
                and srd.inf_name = #{regionName}
            </if>
            <if test="deviceType != null and deviceType != ''">
                and rd.s_device_category_id = #{deviceType}
            </if>
            <if test="deviceName != null and deviceName != ''">
                and rd.s_name LIKE CONCAT('%', #{deviceName} ,'%')
            </if>
        </where>
        ORDER BY
            modify_time DESC
    </select>
</mapper>