mybatis动态sql拼接实现 A and (B or C) B和C为集合

最新推荐文章于 2024-07-20 16:09:10 发布

程序员JavaWind

最新推荐文章于 2024-07-20 16:09:10 发布

阅读量387

点赞数 2

文章标签： mybatis sql 数据库

本文链接：https://blog.csdn.net/weixin_40587144/article/details/129178002

版权

如下代码：

<where>
         and  cost_belong_date = #{yearMonth}
       <trim prefix="and (" suffixOverrides="or" suffix=")">
            <if test="projectCode != null and projectCode.size() > 0">
                tec.project_code in
                <foreach collection="projectCode" item="item" open="(" close=")" separator=",">
                    #{item}
                </foreach>
                or
            </if>
            <if test="deptId != null and deptId.size() > 0">
                tec.dept_id in
                <foreach collection="deptId" item="item" open="(" close=")" separator=",">
                    #{item}
                </foreach>
                or
            </if>
        </trim>
        and version = 2 
</where>