sql中使用判断，如果---否者

最新推荐文章于 2024-03-29 21:49:42 发布

蚂蚁一般黑

最新推荐文章于 2024-03-29 21:49:42 发布

阅读量920

点赞数

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

本文链接：https://blog.csdn.net/qq_34295227/article/details/108371970

版权

sql 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<select id="getMerchantCount" parameterType="com.ssay.merchant.search.MerchantBean" resultType="INTEGER">
   SELECT
   count(1)
   FROM
   `t_sys_merchant` AS m
   WHERE m.`del` = '1'
   AND m.`enable` = '1'
   <choose>
       <when test="merchantType != null">
           and m.merchant_type = #{merchantType}
       </when>
       <otherwise>
           and m.merchant_type = 0
       </otherwise>
   </choose>
   <if test=" startDate != null and startDate != '' ">
       AND m.`create_time` >= #{startDate}
   </if>
   <if test=" endDate != null and endDate != '' ">
       AND m.`create_time` <= #{endDate}
   </if>
   <if test=" merchantCode != null and merchantCode != '' ">
   AND m.`merchant_code` = #{merchantCode}
   </if>
   <if test=" merchantName != null and merchantName != '' ">
   AND m.`merchant_name` like"%"#{merchantName}"%"
   </if>
</select>