美文网首页
uncategorized SQLException小错误

uncategorized SQLException小错误

作者: 王侦 | 来源:发表于2020-05-15 15:19 被阅读0次
### Cause: java.sql.SQLException: sql injection violation, comment not allow : UPDATE membership_member_level
         SET growth_value=?,
            level=?,
            update_time=? 
        WHERE id=#[id}
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, comment not allow : UPDATE membership_member_level
         SET growth_value=?,
            level=?,
            update_time=? 
        WHERE id=#[id}; nested exception is java.sql.SQLException: sql injection violation, comment not allow : UPDATE membership_member_level
         SET growth_value=?,
            level=?,
            update_time=? 
        WHERE id=#[id}

sql语句:

    <update id="update" parameterType="com.wz.eshop.membership.domain.MemberPointDO">
        UPDATE membership_member_point
        SET point=#{point},update_time=#{updateTime}
        WHERE id=#[id}
    </update>

原因是 WHERE id=#[id}括号错了,坑死自己

相关文章

网友评论

      本文标题:uncategorized SQLException小错误

      本文链接:https://www.haomeiwen.com/subject/yfvcohtx.html