Mybatis声明变量并使用

w_十二

于 2024-08-15 17:33:07 发布

阅读量277

点赞数 1

文章标签： mybatis 数据库

本文链接：https://blog.csdn.net/m0_46608027/article/details/141227724

版权

声明变量在sql标签中使用变量

  <sql id="column_id">
    ID, STATE, CREATE_TIME, UPDATE_TIME, SPIDER, VERSION, COMPLETED_AT, QUANTITY
    <!-- 引用sql片段时使用bind定变量 根据变量不同值 显示不同数据 -->
    <if test="role == '1'">,123 as role</if>
    <if test="role == '2'">,456 as role</if>
  </sql>

  <select id="selectTest" resultType="com.test.entity.SpiderTaskEntity">
    <if test="type == '0'.toString()">
      <bind name="role" value="'1'"/>
      select
      <include refid="column_id"/>
      from spider_task st
      where st.state = 'OK'
      and st.SPIDER = 'amac-pof-pe-issue'
    </if>
    <if test="type == '0'.toString()">
      union
      <bind name="role" value="'2'"/>
      select
      <include refid="column_id"/>
      from spider_task st
      where st.state = 'OK'
      and st.SPIDER = 'amac-pof-off'
    </if>
  </select>