List<User> find(@Param("person")Person person,@Param("name")String name);
<if test="person.list1 != null">
and id in
<foreach collection="person.list1" index="index" item="item" open="(" separator="," close=")">
'${item}'
</foreach>
</if>
<if test="person.list2 != null">
and id in
<foreach collection="person.list2" index="index" item="item" open="(" separator="," close=")">
'${item}'
</foreach>
</if>
<select id="getEidList" resultType="java.lang.String">
SELECT efe.eid from ent_file_emergent_industry efe,ent_file ef
where 1 =1
and efe.eid = ef.eid
and efe.code in (SELECT code from dict_emergent_industry where type = 2 and remark in (
<foreach collection="param.customRemarkOrCodeList" index="index" item="item" open="(" separator="," close=")" >
'${item}'
</foreach>
))
and ef.plat_from = '${param.platFrom}'
and ef.delete_flag = 0
</select>
扫码关注腾讯云开发者
领取腾讯云代金券
Copyright © 2013 - 2025 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号:粤B2-20090059 深公网安备号 44030502008569
腾讯云计算(北京)有限责任公司 京ICP证150476号 | 京ICP备11018762号 | 京公网安备号11010802020287
Copyright © 2013 - 2025 Tencent Cloud.
All Rights Reserved. 腾讯云 版权所有