mybatis-02-动态sql

最新推荐文章于 2023-08-14 23:29:59 发布

假装得大佬

最新推荐文章于 2023-08-14 23:29:59 发布

阅读量50

点赞数

分类专栏： mybatis 文章标签： mybatis sql

本文链接：https://blog.csdn.net/qq_44895567/article/details/129728713

版权

mybatis 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

where

去除子句头部的or或者and

<select id="findActiveBlogLike"
     resultType="Blog">
  SELECT * FROM BLOG
  <where>
    <if test="state != null">
         state = #{state}
    </if>
    <if test="title != null">
        AND title like #{title}
    </if>
  </where>
</select>

set

去除子句尾部的逗号

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

trim

定制标签元素。比如自定义set或者自定义where标签

//自定义where
<trim prefix="WHERE" prefixOverrides="AND |OR ">
  ...
</trim>
//自定义set
<trim prefix="SET" suffixOverrides=",">
  ...
</trim>

if,choose/when/otherwise

choose/when/otherwise等同于switch语句

foreach

集合遍历

<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>