mybaits中if 多个test 和 if else 分支支持

最新推荐文章于 2023-10-10 12:10:07 发布

halfsking

最新推荐文章于 2023-10-10 12:10:07 发布

阅读量7k

点赞数

分类专栏： java 文章标签： java 数据库

本文链接：https://blog.csdn.net/halfsking/article/details/84858279

版权

java 专栏收录该内容

12 篇文章 1 订阅

订阅专栏

mybaits中if 多个test

 <select id="selectByDynamicallyWithPage" parameterType="map" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from gene_polymorphism
    <where>
      diag_id = #{conds.diagId,jdbcType=INTEGER}
      <if test="conds.chromesome!=null and conds.chromesome!=''">
        and chromesome = #{conds.chromesome,jdbcType=VARCHAR}
      </if>
      <if test="conds.startPos!=null">
        and start_pos &gt;= #{conds.startPos,jdbcType=BIGINT}
      </if>
    </where>
</select>

if else分支：

<select id="selectByDynamicallyWithPage" parameterType="map" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from gene_polymorphism
    <where>
      diag_id = #{conds.diagId,jdbcType=INTEGER}
      <if test="conds.chromesome!=null">
        and chromesome = #{conds.chromesome,jdbcType=VARCHAR}
      </if>
      <if test="conds.startPos!=null">
        and start_pos &gt;= #{conds.startPos,jdbcType=BIGINT}
      </if>
      <if test="conds.endPos!=null">
        and end_pos &lt;= #{conds.endPos,jdbcType=BIGINT}
      </if>
      <if test="conds.geneTypes!=null">
        <!--and gene_type in-->
        <!--<foreach collection="conds.geneTypes" open="(" close=")" item="item" separator="," >-->
          <!--#{item,jdbcType=VARCHAR}-->
        <!--</foreach>-->
        and (
        <foreach collection="conds.geneTypes" item="item" separator="or">
          gene_type like CONCAT('%',CONCAT(#{item,jdbcType=VARCHAR}, '%'))
        </foreach>
        )
      </if>
      <if test="conds.geneChange!=null">
        and gene_change like CONCAT('%',CONCAT(#{conds.geneChange,jdbcType=VARCHAR}, '%'))
      </if>
    </where>
    order by
    <trim suffixOverrides=",">
      <choose>
        <when test="conds.chromesomeSort!=null and conds.chromesomeSort=='asc'">
          chromesome asc ,
        </when>
        <when test="conds.chromesomeSort!=null and conds.chromesomeSort=='desc'">
          chromesome desc ,
        </when>
      </choose>
      <choose>
        <when test="conds.startPosSort!=null and conds.startPosSort=='asc'">
           start_pos asc ,
        </when>
        <when test="conds.startPosSort!=null and conds.startPosSort=='desc'">
           start_pos desc ,
        </when>
        <otherwise>
          id desc
        </otherwise>
      </choose>
    </trim>
      limit #{startRow,jdbcType=INTEGER} ,#{pageSize,jdbcType=INTEGER}
  <!--  order by id desc limit #{startRow,jdbcType=INTEGER} ,#{pageSize,jdbcType=INTEGER} -->
  </select>