ssm项目报错：Data truncation: Truncated incorrect DOUBLE XXX

最新推荐文章于 2023-08-02 16:43:28 发布

Solitude_dong

最新推荐文章于 2023-08-02 16:43:28 发布

阅读量98

点赞数

分类专栏： Mybatis 文章标签： java

本文链接：https://blog.csdn.net/qq_30072161/article/details/118191853

版权

Mybatis 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

原因：在mybatis的xml文件的sql语句中，set后面更改不止一个字段，用了and连接

    <update id="updateMerchantPushedAndTimes">
        update ouser.merchant_org_info
        <if test="pushedFlag == true">
            set is_pushed = 'Y'  and pushe_times = pushe_times+1
        </if>
        <if test="pushedFlag == false ">
            set is_pushed = 'N' and pushe_times = pushe_times+1
        </if>
        where id = #{id,jdbcType=BIGINT}
    </update>

解决：and改为逗号

    <update id="updateMerchantPushedAndTimes">
        update ouser.merchant_org_info
        <if test="pushedFlag == true">
            set is_pushed = 'Y' , pushe_times = pushe_times+1
        </if>
        <if test="pushedFlag == false ">
            set is_pushed = 'N' , pushe_times = pushe_times+1
        </if>
        where id = #{id,jdbcType=BIGINT}
    </update>