mybatis的动态sql语句

动态sql标签一般在多条件查询sql时使用

一、if标签

<select id="findUserByCondition" parameterType="user" resultType="user">
        select * from user
        <where>
            <if test="username != null">
                and username = #{username}
            </if>
        </where>
       
    </select>

二、foreach标签

collection属性作为Quryvo实体类的属性，open和close组成完整的sql语句，item作为遍历每一项的名称，separator作为每个id的分隔符

 <select id="findUserBySomeId" parameterType="queryvo" resultType="user">
        select * from user
        <where>
            <if test="ids != null and ids.size()>0">
                <foreach collection="ids" open="and id in (" close=")" item="id" separator=",">
                    #{id}
                </foreach>
            </if>
        </where>
    </select>

下一篇