mybatis查询报错Parameter index out of range (3 > number of parameters, which is 2).

最新推荐文章于 2025-05-19 07:00:00 发布

黄三yeah

最新推荐文章于 2025-05-19 07:00:00 发布

阅读量1.4k

点赞数

分类专栏：报错解决方案

本文链接：https://blog.csdn.net/Huangcsdnjava/article/details/79933434

版权

报错解决方案专栏收录该内容

14 篇文章

订阅专栏

本文介绍了一个复杂的SQL查询案例，该查询用于统计不同公司业务的数据，包括案例数量、业务数量及查询数量等。通过左连接多个表，并使用条件过滤，实现了灵活的数据汇总。

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

<select id="getDistinctCompanyBusiness"
        parameterType="java.util.Map"
        resultType="com.qy.insurance.ls.adjust.dto.company.CompanyStatisticsResponse">

    SELECT
    e.client_name as companyName,
    d.class_name as termName,
    COUNT(a.flow_Id) as caseAmount,
    COUNT(c.id) as businessAmount,
    COUNT(b.id) as queryAmount
    FROM
    t_amount_case a
    LEFT JOIN
    t_calc_billinfo b
    ON
    a.flow_Id=b.flowId
    LEFT JOIN
    t_amount_business c
    ON
    a.flow_Id=c.flow_Id
    LEFT JOIN
    t_class d
    ON
    c.class_code=d.class_code
    LEFT JOIN
    t_client e
    ON
    a.client_code=e.client_code
    GROUP BY
    a.client_code

    <where>
        <if test="startDate != null">
            AND a.statistical_time >= #{startDate}
        </if>
        <if test="endDate != null">
            AND a.statistical_time &lt;= #{endDate}
        </if>
        <if test="client_code != '' and client_code != null">
            AND a.client_code = #{clientCode,jdbcType=VARCHAR}
        </if>
        <if test="classCode != '' and classCode != null">
            AND c.class_code = #{classCode,jdbcType=VARCHAR}
        </if>
        <if test="businessType != '' and businessType != null">
            AND a.bill_type = #{businessType,jdbcType=VARCHAR}
        </if>
    </where>

</select>