mybatis动态sql语句

select语句下的：

  <if xx!=null >

     and  xx=#{xx}

  </if>

  <choose>

      <when   xx==null>

         and xx=#{xx}

      </when>

      <otherwise>
           AND featured = 1
      </otherwise>

</choose>

<trim  prefix="WHERE" prefixOverrides="AND |OR "> //当遇到<if>并且通过后，直接添加where关键字，当遇到and或者or时，把and、or去掉保持正常的sql语句

  <if xx!=null >

     xx=#{xx}

  </if>

  <if xx!=null >

     and  xx=#{xx}

  </if>

</trim>

<select id="selectPostIn" resultType="domain.blog.Post">
SELECT *
FROM POST P
WHERE ID in
<foreach item="item" index="index" collection="list"
open="(" separator="," close=")">

#{item}
</foreach>
</select>

另一种foreach的写法：

<foreach item="item" index="index" collection="list" separator=",">

   (#{item.name},#{item.code},#{item.email})

</foreach>

update语句下的：

<set>
<if test="username != null">username=#{username},</if>
<if test="password != null">password=#{password},</if>
<if test="email != null">email=#{email},</if>
<if test="bio != null">bio=#{bio}</if>
</set>
where id=#{id}