Mybaits配置文件之动态SQL配置备忘录

<select id="querymessagelist" parametertype="com.imooc.bean.message"
    resultmap="messageresult">
    select id,command,description,content from message where 1=1
    <if test="command !=null &&!"".equals(command.trim())">
      and command=#{command}
    </if>
    <if test="description != null and !"".equals(description.trim())">
      and description like '%' #{description} '%'
    </if>
  </select>

<delete id="deleteone" parametertype="int">
    delete from message where id = #{_parameter}
</delete>

  <delete id="deletebatch" parametertype="java.util.list">
    delete from message where id in (
    <foreach collection="list" item="item" separator=",">
      #{item}
    </foreach>
    )
  </delete>