Mybatis动态sql----if--where

     <select id="SelectifwhereTestMap" parameterType="map" resultType="user">
    select * from user
    <where>
    <if test="username!=null and username!=''">
    and username like '%${username}%' 
    </if>
    
    <if test="sex!=null and sex!=''">
    and sex=#{sex} 
    </if>
    
    <if test="address!=null and address!=''">
    and address like '%${address}%' 
    </if>
    </where><!--where可以去除第一个空格或者OR-->
    </select> 
    ```

<select id="SelectifwhereTestUser" parameterType="user" resultType="user">
select * from user
<where><!--where可以去除第一个空格或者OR-->
<if test="username!=null and username!=''">
and username like '%${username}%' 
</if>

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

<if test="address!=null and address!=''">
and address like '%${address}%' 
</if>
</where>
</select>