mybatis_05动态SQL_if和where

<resultMap id="userByresultmap" type="user">
    <id property="id" column="id_"></id>
    <result property="username" column="username_"></result>
    <result property="birthday" column="birthday_"></result>
    <result property="sex" column="sex_"></result>
    <result property="address" column="address_"></result>
</resultMap>

<select id="findUserByifwhere" parameterType="userQueryVO" resultMap="userByresultmap">

  select * from USER

  <where>
      <if test="user!=null and user!=‘‘">

          <if test="user.sex!=null and user.sex!=‘‘">
<!—也可以写成and sex=#{user.sex},系统会自动去掉-->
              sex=#{user.sex}
          </if>
          <if test="user.username!=null and user.username!=‘‘">
              and username LIKE "%${user.username}%"
          </if>
      </if>

  </where>

  </select>