SpringBoot框架处理外键约束异常无法捕获到SQLIntegrityConstraintViolationException处理办法

豆浆油条啦啦啦

已于 2024-08-06 11:27:26 修改

阅读量477

点赞数 2

CC 4.0 BY-SA版权

于 2024-08-06 11:26:03 首次发布

本文链接：https://blog.csdn.net/weixin_49703353/article/details/140951116

Spring框架把SQLIntegrityConstraintViolationException异常包装成了DataIntegrityViolationException导致没办法捕获到SQLIntegrityConstraintViolationException异常

代码只能写为


    /**
     * 外键约束异常
     */
    @ExceptionHandler(DataIntegrityViolationException.class)
    public AjaxResult handleSQLIntegrityConstraintViolationException(DataIntegrityViolationException e, HttpServletRequest request) {
        String requestURI = request.getRequestURI();
        if (e.getMessage().contains("Cannot delete or update a parent row: a foreign key constraint fails")) {
            log.error("请求地址'{}',发生外键约束异常.", requestURI, e);
            return AjaxResult.error("操作失败：存在外键约束，无法删除或更新相关数据。");
        }
        //返回数据完整性约束违反
        log.error("请求地址'{}',发生数据完整性约束异常.", requestURI, e);
        return AjaxResult.error("操作失败：数据完整性约束违反。");
    }