mybatis xml 常用标签

mybatis xml常用标签 括号 if for

xml里面的括号

 prefixOverrides 可省略，前缀覆盖AND
<trim prefix="(" suffix=")" prefixOverrides="AND">
<trim>

if

            <if test="id != null and id != ''">
                AND id = #{id}
            </if>

if for 循环

            <if test="ids != null and ids.size() > 0">
                mx.ID in
                <foreach collection="ids" item="item" open="(" close=")" separator=",">
                    #{item}
                </foreach>
            </if>