MyBatis：XML中如何判断List为空并遍历拼接

最新推荐文章于 2024-10-02 06:12:20 发布

dingcho

最新推荐文章于 2024-10-02 06:12:20 发布

阅读量147

点赞数 3

分类专栏： SpringCloud 文章标签： mybatis xml list

本文链接：https://blog.csdn.net/yao_guai/article/details/141792492

版权

SpringCloud 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

判断是否为空~

<mapper namespace="com.kingbal.mapper.UserMapper">
    <select id="gettUsers" parameterType="java.util.List" resultType="com.kingbal.entity.User">
        SELECT * FROM user
        <where>
            <if test="list != null and list.size() > 0">
                AND id IN
                <foreach collection="list" item="id" open="(" separator="," close=")">
                    #{id}
                </foreach>
            </endif>
        </where>
    </select>
</mapper>

拼接~

<mapper namespace="com.kingbal.mapper.UserMapper">
    <select id="getUsers" resultType="java.lang.String">
        SELECT name, age, email FROM user
        WHERE 1=1
        <if test="list != null and list.size() > 0">
            AND (name IN
            <foreach collection="list" item="name" open="(" separator="," close=")">
                #{name}
            </foreach> OR age IN
            <foreach collection="list" item="age" open="(" separator="," close=")">
                #{age}
            </foreach>)
        </if>
    </select>
</mapper>