m0_63924967 2022-06-29 12:53 采纳率: 50%
浏览 30
已结题

假性删除,不知道那里错了要怎么改

HTTP状态 500 - 内部服务器错误
类型 异常报告

消息 Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:

描述 服务器遇到一个意外的情况,阻止它完成请求。

例外情况

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:

Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (javaee.student, CONSTRAINT student_ibfk_1 FOREIGN KEY (clazzid) REFERENCES clazz (id))

The error may exist in file [D:\Homework\JavaEE--何庆新\submit homework\qimo选课\out\artifacts\aaaa_war_exploded\WEB-INF\classes\com\mybatisdao\ClazzMapper.xml]

The error may involve com.mybatisdao.ClazzMapper.clazzDel-Inline

The error occurred while setting parameters

SQL: delete from clazz where id = ?

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (javaee.student, CONSTRAINT student_ibfk_1 FOREIGN KEY (clazzid) REFERENCES clazz (id))

; Cannot delete or update a parent row: a foreign key constraint fails (javaee.student, CONSTRAINT student_ibfk_1 FOREIGN KEY (clazzid) REFERENCES clazz (id)); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (javaee.student, CONSTRAINT student_ibfk_1 FOREIGN KEY (clazzid) REFERENCES clazz (id))
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

  • 写回答

1条回答 默认 最新

  • 微笑精灵 2022-06-29 13:06
    关注

    delete from clazz where id = ?
    这个表应该是有外键
    外键约束失败(javaee.student,CONSTRAINT student_ibfk_1 FOREIGN KEY (clazzid) REFERENCES clazz (id))

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

问题事件

  • 系统已结题 7月7日
  • 已采纳回答 6月29日
  • 创建了问题 6月29日

悬赏问题

  • ¥100 c语言,请帮蒟蒻写一个题的范例作参考
  • ¥15 名为“Product”的列已属于此 DataTable
  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
  • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站
  • ¥50 成都蓉城足球俱乐部小程序抢票
  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)