Mybatis在Spring中的使用(六)

文章概述

接上文Mybatis在Spring中的使用(五)。本文主要介绍了mybatis基于xml配置的动态sql语句使用。

if标签

直接上例子

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

where标签

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

foreach标签

 <select id="findUserInIds" resultType="user" parameterType="QueryVo">
        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>

sql标签

<!--了解的内容，抽取重复的sql语句-->
    <sql id="defaultUser">
        select * from user;
    </sql>
    <select id="findAll" resultType="user">
        <include refid="defaultUser"></include>
    </select>