复制代码

为懒人提供无限可能，生命不息，code不止
人类感性的情绪，让我们知难行难
我思故我在
日拱一卒，功不唐捐

mybatis

【原创】mybatis sql 的几种不常见用法

作者: whooyun发表于: 2023-03-02 14:26

for 循环or

SQL

1
2
3
4
5
6
7
8
9
10
11
12
SELECT
    *
FROM
    acv_gds_category
WHERE
    corp_id = ?
    AND is_deleted = ?
    AND (
    cat_no LIKE CONCAT( '',?, '%' )
    OR cat_no LIKE CONCAT( '',?, '%' )
    OR cat_no LIKE CONCAT( '',?, '%' )
    )
对应mybatis的xml

1
2
3
4
5
6
<select id="selectLikeCatNos" resultType="com.zbw.saas.data.archives.goods.entity.AcvGoodsCategory">
        select * from acv_gds_category where corp_id = #{corpId} and is_deleted = #{isDeleted}
        <foreach collection="list" item="item" open="AND (" close=")" separator="or" >
            cat_no like  CONCAT('',#{item},'%')
        </foreach>
    </select>