多类型查询

最新推荐文章于 2024-08-21 23:39:15 发布

fm2zhaoyong2

最新推荐文章于 2024-08-21 23:39:15 发布

阅读量293

点赞数

分类专栏： mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/fm2zhaoyong2/article/details/73457868

版权

mybatis 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<select id="getByCondition" resultMap="BaseResultMap">
SELECT
sm.id id,
sm.scene_id scene_id,
sm.name name,
sm.unit unit,
sm.relation_id relation_id,
sm.relation_type relation_type,
sm.icon icon,
sm.description description,
sm.device_name device_name,
sm.create_time create_time,
sm.last_update_time last_update_time,
sm.last_update_account last_update_account
FROM sm_monitorpoint sm
LEFT JOIN dm_virtualdeviceparam dvp ON sm.relation_id=dvp.id
LEFT JOIN dm_virtualdevice dv ON dv.id=dvp.device_id
WHERE relation_type=#{relationType}
<if test="deviceTypeList!=null and deviceTypeList.size>0">
AND dv.device_type_id IN
<foreach collection="deviceTypeList" separator="," open="(" close=")" index="index">
#{deviceTypeList[${index}]}
</foreach>
</if>
<if test="sceneIdList!=null and sceneIdList.size>0">
AND sm.scene_id IN
<foreach collection="sceneIdList" separator="," open="(" close=")" index="index">
#{sceneIdList[${index}]}
</foreach>
</if>
<if test="keywords!=null and keywords!=''">
AND (sm.name LIKE CONCAT('%',#{keywords},'%'))
</if>
</select>