java.sql.SQLException: Parameter index out of range (5 > number of parameter

hk_life

于 2019-05-14 11:26:38 发布

阅读量575

点赞数 1

CC 4.0 BY-SA版权

分类专栏：后端异常

本文链接：https://blog.csdn.net/hk_life/article/details/90202869

后端异常专栏收录该内容

2 篇文章

订阅专栏

本文通过一个具体的MyBatis动态SQL示例，详细解析了如何使用if标签进行条件判断，实现SQL语句的动态拼接。通过这个例子，读者可以了解到如何在SQL查询中灵活地加入或排除某些条件，从而提高SQL语句的灵活性和复用性。

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

<select id="selectLtygoodList" resultMap="BaseResultMap">
        select t1.*,giftGoods.id as goodsId,
        giftGoods.goods_type,
        giftGoods.picture,
        giftGoods.rech_value,
        giftGoods.cpn_id
        from gift_ltygoods t1 LEFT join gift_goods giftGoods on t1.goods_id = giftGoods.id
        <where>
            t1.act_id = #{actid} and t1.term_id = #{termid} and t1.del_flag = '0'
            <if test="giftName!=null and giftName!=''">
                AND t1.gift_name like concat('%','${giftName}','%')
            </if>
            ORDER BY t1.create_date asc limit ${limit}
        </where>
        /*where t1.act_id = #{actid} and t1.term_id = #{termid} and t1.del_flag = '0' and giftGoods.del_flag = '0'
        ORDER BY t1.create_date asc limit #{limit}*/
    </select>

下面有注释的sql，导致出了这么个异常