谷粒学苑P98踩坑 e.GlobalExceptionHandler : null

报错情况

2022-07-15 15:49:50.651 ERROR 10152 --- [nio-8001-exec-1] c.a.s.e.GlobalExceptionHandler           : null
2022-07-15 15:49:50.654 ERROR 10152 --- [nio-8001-exec-1] c.a.s.e.GlobalExceptionHandler           : GuliException(code=20002, msg=添加课程分类失败)

GuliException(code=20002, msg=添加课程分类失败)
	at com.atguigu.eduservice.service.impl.EduSubjectServiceImpl.saveSubject(EduSubjectServiceImpl.java:38)
	at com.atguigu.eduservice.service.impl.EduSubjectServiceImpl$$FastClassBySpringCGLIB$$e3ec89f4.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)
	at com.atguigu.eduservice.service.impl.EduSubjectServiceImpl$$EnhancerBySpringCGLIB$$51228585.saveSubject(<generated>)
	at com.atguigu.eduservice.controller.EduSubjectController.addSubject(EduSubjectController.java:39)

代码功能

实现读取本地excel，将数据上传到数据库

错误分析

上面的报错信息也是 从这里抛出的，但是我水平有限，无法分析出什么内容，所以尝试将原装的错误输出。
将上面的catch 修改

catch (Exception e){
            e.printStackTrace();
        }

就可以看到下面的报错

com.alibaba.excel.exception.ExcelAnalysisException: 
### Error updating database.  Cause: java.sql.SQLException: Field 'gmt_create' doesn't have a default value
### The error may involve com.atguigu.eduservice.mapper.EduSubjectMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO edu_subject  ( id, title, parent_id )  VALUES  ( ?, ?, ? )
### Cause: java.sql.SQLException: Field 'gmt_create' doesn't have a default value
; Field 'gmt_create' doesn't have a default value; nested exception is java.sql.SQLException: Field 'gmt_create' doesn't have a default value

修改bug

当修改或创建的时候都需要 给它们默认值，我们已经封装了自动赋值的handler

这里封装的自动填充类