动态sql

DBAA12138

于 2021-01-19 12:02:32 发布

阅读量76

点赞数

分类专栏： Mybatis

本文链接：https://blog.csdn.net/DBAA12138/article/details/112591063

版权

Mybatis 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

什么时动态sql：就是根据不同的条件，生成不同的sql语句

搭建环境

工具类

id随机

@SuppressWarnings("all")
public class IDUtils {
    public static  String getId(){
        return UUID.randomUUID().toString().replaceAll("-","");
    }

    @Test
    public void test(){
        System.out.println(IDUtils.getId());
        System.out.println(IDUtils.getId());
        System.out.println(IDUtils.getId());
    }
}

实体类

public class Blog {
    private String id;
    private String title;
    private String author;
    private Date createTime;  //属性名和字段名不一致
    private int views;

}

choose(when,otherwise)

 <where>
            <choose>
                <when test="title!=null">
                    title=#{title}
                </when>

                <when test="author!=null">
                    and author=#{author}
                </when>

                <otherwise>
                    and views=#{views}
                </otherwise>
            </choose>
        </where>

trim(where,set)

   <update id="upDateBlog" parameterType="map">
        update blog
        <set>
            <if test="title!=null">
                title=#{title},
            </if>

            <if test="author!=null">
                author=#{author}
            </if>
        </set>
        where id=#{id}
    </update>

  <select id="queryBlogIF" parameterType="map" resultType="blog">
        select * from blog where 1=1
        <if test="title!=null">
            and title =#{title}
        </if>
        <if test="author!=null">
            and author=#{author}
        </if>
    </select>