mybatis sql 的几种不常见用法-mybatis-复制代码（fuzhicode.com）

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

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

for 循环or

SQL

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

<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>