Mybatis动态sql

if语句

select * from user where 1=1

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

--------------------------------------------------

<select id="getEmp" parameterType="map" resultType="map">
        select * from emp
        <where>
            <if test="job!=null and job!=''">
                and job=#{job}
            </if>
            <if test="startDate!=null and startDate!=''">
                and hiredate &gt; to_date(#{startDate},'yyyy-mm-dd')
            </if>
            <if test="endDate!=null and endDate!=''">
                and hiredate &lt; to_date(#{endDate},'yyyy-mm-dd')
            </if>
        </where>
    </select>

--------------------------------------------------

    <select id="getListParam" parameterType="map" resultType="map">
        select * from emp
        <where>
            <choose>
                <when test="empno!=null and empno!=0">
                    and empno =#{empNo}
                </when>
                <when test="job!=null and job!=0">
                    and job =#{job}
                </when>
                <when test="startDate!=null and startDate!=''">
                    and hiredate &gt; to_date(#{startDate},'yyyy-mm-dd')
                </when>
                <otherwise>
                    and deptno=10
                </otherwise>
            </choose>
        </where>
    </select>

--------------------------------------------

    <select id="getListByList" parameterType="map" resultType="map">
        select * from emp where empno in
        <foreach collection="list" item="i" open="(" close=")" separator=",">
              #{i}
        </foreach>
    </select>

   <!--

            collection:指定输入对象中的集合属性

            item:每次遍历生成的对象

            open:开始遍历时的拼接字符串

            close:结束时拼接的字符串

            separator:遍历对象之间需要拼接的字符串

            select * from user where 1=1 and (id=1 or id=2 or id=3)

          -->