Mybatis使用choose when

最新推荐文章于 2024-03-11 17:41:26 发布

小驴程序源

最新推荐文章于 2024-03-11 17:41:26 发布

阅读量4.3k

点赞数

博客章节由《小驴程序源》创建，如有雷同不胜荣幸！！

本文链接：https://blog.csdn.net/qq_34238798/article/details/89210464

版权

Mybatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

Mybatis使用<choose> <when>

例子： order by

  <sql id="Base_OrderBy">
    <if test="orderBy != null and orderBy.size() &gt; 0">
      order by
      <foreach collection="orderBy" item="item" separator=",">
        <choose>
          <when test="item.name == 'codeTabUuid'">
            CODE_TAB_UUID
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <when test="item.name == 'code'">
            CODE
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <when test="item.name == 'name'">
            NAME
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <when test="item.name == 'codeType'">
            CODE_TYPE
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <when test="item.name == 'parentUuid'">
            PARENT_UUID
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <when test="item.name == 'upLimit'">
            UP_LIMIT
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <when test="item.name == 'downLimit'">
            DOWN_LIMIT
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <when test="item.name == 'srcCode'">
            SRC_CODE
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <when test="item.name == 'srcName'">
            SRC_NAME
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <when test="item.name == 'srcParentCode'">
            SRC_PARENT_CODE
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <when test="item.name == 'sortValue'">
            SORT_VALUE
            <if test="item.direction != null">
              ${item.direction}
            </if>
          </when>
          <otherwise />
        </choose>
      </foreach>
    </if>
  </sql>