MyBatis 利用foreach处理数组参数传入

最新推荐文章于 2023-07-04 16:41:20 发布

落叶尘枫

最新推荐文章于 2023-07-04 16:41:20 发布

阅读量2.1k

点赞数 1

分类专栏： Oracle 数据库应用文章标签： mysql

本文链接：https://blog.youkuaiyun.com/fhlu18/article/details/108767759

版权

Oracle 数据库应用专栏收录该内容

4 篇文章

订阅专栏

本文介绍了如何使用MyBatis的foreach标签处理数组参数，生成如'BUSINESS_CUSTOMER in ('AMAZON', 'BAIDU')'这样的SQL片段，应用于多条件查询。" 118190663,10500202,Apache ECharts 中的旭日图(Sunburst)详解,"['数据可视化', 'ECharts', '旭日图']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. 使用IN实现多条件查询，传入的参数是String数组，如 issuePriority = ["ABC","BCD","EFG"]
2. 在MyBatis xml文件中，使用foreach,其中，需要使用$ 而不是#， {item}需要用单引号括起来，如'${item}'
<if test="issuePriority != null and issuePriority.length > 0 "> 
    and ISSUE_PRIORITY in <foreach collection="issuePriority" item="item" index="index" open="(" close=")" separator=","> 
'${item}'
 </foreach> </if>

<!-- 根據查詢條件，查詢需求信息 -->
<select id="getDailyWorkingIssueListWithArrayParameters" resultMap="DailyWorkingIssue">
    SELECT *
    FROM MES_KPI_ISSUE_T
    WHERE 1=1
    <if test="issueId != null and issueId != ''">
        and ISSUE_ID = #{issueId}
    </if>
    <if test="issueSubject != null and issueSubject != ''">
        and ISSUE_SUBJECT = #{issueSubject}
    </if>
    <if test="issuePriority != null and issuePriority.length > 0 ">
        and ISSUE_PRIORITY in
            <foreach collection="issuePriority" item="item" index="index" open="(" close=")" separator=",">
                '${item}'
            </foreach>
    </if>
    <if test="beginDate != null ">
        AND date_format(BEGIN_DATE,'%Y-%m-%d') &gt;= date_format(#{beginDate},'%Y-%m-%d')
    </if>
    <if test="endDate != null ">
        AND date_format(BEGIN_DATE,'%Y-%m-%d') &lt;= date_format(#{endDate},'%Y-%m-%d')
    </if>
</select>

最后生成的SQL语句

SELECT * FROM MES_KPI_ISSUE_T WHERE 1=1 and BUSINESS_LEVEL in ( 'L6' ) and BUSINESS_CUSTOMER in ( 'AMAZON' , 'BAIDU' )

SELECT * FROM MES_KPI_ISSUE_T WHERE 1=1 and ISSUE_PRIORITY in ( 'A' )