mybatis 特殊查询总结， like查询，in查询等

最新推荐文章于 2024-03-12 11:34:35 发布

weixin_33775572

最新推荐文章于 2024-03-12 11:34:35 发布

阅读量177

点赞数

文章标签： java python

原文链接：https://my.oschina.net/zhaolin/blog/742032

版权

2019独角兽企业重金招聘Python工程师标准>>>

一.in 查询
<select id="findByCondition4ManualRefundQuery" resultMap="BaseResultMap" parameterType="com.yufusoft.payplatform.clearing.accountbalance.po.CsPayInfo" >
SELECT * FROM CS_PAY_INFO
   where REFUND_STATUS in <foreach collection="list" item="refundStatus" open="(" separator="," close=")">
#{refundStatus}
       </foreach>
       <if test="subMerId != null and subMerId != ''">
       AND   SUB_MER_ID = #{subMerId}
       </if>
       <if test="transStatus != null and transStatus != ''">
           AND TRANS_STATUS = #{transStatus}
       </if>
       <if test="transType != null and transType != ''">
           AND TRANS_TYPE = #{transType}
       </if>
</select>

二.like查询

       <if test="customerQianZHui != null and customerQianZHui != ''">
           AND USER_ID LIKE #{customerQianZHui}||'%'
       </if>

转载于:https://my.oschina.net/zhaolin/blog/742032