sql语句 map参数查询 include的refid 示例

    <select id="listDeviceInfo" parameterType="java.util.Map"
            resultMap="DeviceInfoVO">
        <include refid="selectDeviceInfoVO"></include>
        <where>
            <foreach collection="_parameter" item="tm" index="key">
                <if test='tm != null and tm.toString().trim() != ""'>
                    ${key} #{tm}
                </if>
            </foreach>
        </where>
    </select>


    <sql id="selectDeviceInfoVO">
        select id,
                device_no,
                device_type,
                version,
                mac_address,
                mac_address,
                serial_no,
                create_time,
                create_user,
                end_time,
                device_status
        from tb_device_info
    </sql>

Mapper
List<DeviceInfo> listDeviceInfo(Map map);


Map<String, String> deviceInfoMap = new HashMap<>();
deviceInfoMap.put("and device_no = ", deviceParam.getDeviceNumber());
List<DeviceInfo> deviceInfoList = deviceInfoMapper.listDeviceInfo(deviceInfoMap);