常用动态动态SQL

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.kaung.dao.BlogMapper">
    <sql id="if-title-author">
        <if test="title != null">
            and title = #{title}
        </if>
        <if test="author != null">
            and author = #{author}
        </if>
    </sql>
    <insert id="addBlog" parameterType="Blog">
        insert into mybatis2.blog (id, title, author, create_time, views)
        values (#{id}, #{title},#{author}, #{createTime}, #{views}) ;
    </insert>
  <select id="queryBlogIF" parameterType="map" resultType="Blog">
      select * from mybatis2.blog
        <where>
            <include refid="if-title-author"></include>
        </where>
  </select>
    <select id="queryBlogChoose" parameterType="map" resultType="Blog">
        select * from mybatis2.blog
        <where>
            <choose>
                <when test="title!= null">
                    title = #{title}
                </when>
                <when test="author != null">
                    and author =#{author}
                </when>
                <otherwise>
                    and views = #{views}
                </otherwise>
            </choose>
        </where>
    </select>


    <update id="updateBlog" parameterType="map">
        update mybatis2.blog
        <set>
            <if test="title != null" >
                title = #{title},
            </if>
            <if test="author!= null">
                author = #{author}
            </if>
        </set>
        where id =#{id}
    </update>

    <!--select * from mybatis2.blog2 where 1=1 and  (id=1 or id=2 or id=3)
        我们现在传递一个万能的map,这个map中可以存在一个集合 -->
    <select id="queryBlogForeach" parameterType="map" resultType="Blog">
        select * from mybatis2.blog
        <where>
            <foreach collection="ids" item="id" open="and (" close=")" separator="or">
                id = #{id}
            </foreach>
        </where>
    </select>
</mapper>