Request method 'POST' not supported的错误

最新推荐文章于 2024-07-04 22:17:11 发布

草球

最新推荐文章于 2024-07-04 22:17:11 发布

阅读量1.3w

点赞数

分类专栏：解决问题

本文链接：https://blog.csdn.net/weixin_44955631/article/details/95597184

版权

解决问题专栏收录该内容

1 篇文章 0 订阅

订阅专栏

今天做一个简单的修改出现这样的错。在这里插入图片描述
如果传输方式没没错，一般就是传输参数有问题，还有就是mapper书写错误。而笔者是使用的自动生成工具，所以没有仔细看，导致mapper错误。
这是正确的代码


    <update id="updateSelective" parameterType="com.hxzy.entity.Member">
        update member
        <set>
            <if test="email != null">
                email = #{email,jdbcType=VARCHAR},
            </if>
            <if test="credit != null">
                credit = #{credit,jdbcType=INTEGER},
            </if>
            <if test="gold != null">
                gold = #{gold,jdbcType=DOUBLE},
            </if>
            <if test="realname != null">
                realname = #{realname,jdbcType=VARCHAR},
            </if>
            <if test="mobile != null">
                mobile = #{mobile,jdbcType=VARCHAR},
            </if>
            <if test="pwd != null">
                pwd = #{pwd,jdbcType=VARCHAR},
            </if>
            <if test="createtime != null">
            createtime =#{createtime，jdbcType=INTEGER},
            </if>
            <if test="istemplate != null">
                istemplate = #{istemplate,jdbcType=INTEGER},
            </if>
            <if test="status != null">
                `status` = #{status,jdbcType=INTEGER},
            </if>
            <if test="experience != null">
                experience = #{experience,jdbcType=INTEGER},
            </if>
            <if test="avatar != null">
                avatar = #{avatar,jdbcType=VARCHAR},
            </if>
            <if test="outgold != null">
                outgold = #{outgold,jdbcType=DOUBLE},
            </if>
            <if test="outgoldinfo != null">
                outgoldinfo = #{outgoldinfo,jdbcType=VARCHAR},
            </if>
            <if test="weixinOpenid != null">
                weixin_openid = #{weixinOpenid,jdbcType=VARCHAR},
            </if>
            <if test="alipayOpenid != null">
                alipay_openid = #{alipayOpenid,jdbcType=VARCHAR},
            </if>
        </set>
        where openid = #{openid,jdbcType=VARCHAR}
    </update>

这是错误的代码


    <update id="updateSelective" parameterType="com.hxzy.entity.Member">
        update member
        <set>
            <if test="email != null">
                email = #{email,jdbcType=VARCHAR},
            </if>
            <if test="credit != null">
                credit = #{credit,jdbcType=INTEGER},
            </if>
            <if test="gold != null">
                gold = #{gold,jdbcType=DOUBLE},
            </if>
            <if test="realname != null">
                realname = #{realname,jdbcType=VARCHAR},
            </if>
            <if test="mobile != null">
                mobile = #{mobile,jdbcType=VARCHAR},
            </if>
            <if test="pwd != null">
                pwd = #{pwd,jdbcType=VARCHAR},
            </if>
       
            createtime =#{createtime，jdbcType=INTEGER},

            <if test="istemplate != null">
                istemplate = #{istemplate,jdbcType=INTEGER},
            </if>
            <if test="status != null">
                `status` = #{status,jdbcType=INTEGER},
            </if>
            <if test="experience != null">
                experience = #{experience,jdbcType=INTEGER},
            </if>
            <if test="avatar != null">
                avatar = #{avatar,jdbcType=VARCHAR},
            </if>
            <if test="outgold != null">
                outgold = #{outgold,jdbcType=DOUBLE},
            </if>
            <if test="outgoldinfo != null">
                outgoldinfo = #{outgoldinfo,jdbcType=VARCHAR},
            </if>
            <if test="weixinOpenid != null">
                weixin_openid = #{weixinOpenid,jdbcType=VARCHAR},
            </if>
            <if test="alipayOpenid != null">
                alipay_openid = #{alipayOpenid,jdbcType=VARCHAR},
            </if>
        </set>
        where openid = #{openid,jdbcType=VARCHAR}
    </update>

是的代码生成工具没有判断createtime 是否为null,导致错误。