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

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

原创最新推荐文章于 2025-05-19 07:00:00 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

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

14 篇文章

订阅专栏

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

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