mybatis insert插入语句以后一直报错怎么回事怎么在保存以后获取保存对象的id

项目采用的框架是springmvc mybatis
数据库 mysql

控制器代码：

还有怎么在保存一一张表的同时保存到另一张表把A表的id 保存到B表（关联的表）

 List<EarDiseaseSwtj> listEdSwtj=earStudyService.findEdByid(id1);
            if (listEdSwtj.size() != 0) {
                //int num2 = earDisease100Service.updateEdSwtj(id1, name, desc);// 修改的仅是ear_disease_100这个表
                int num2=earStudyService.updateEdSwtj(id1, name, desc);
                if (num2 != 0) {
                    request.setAttribute("ok", "修改成功");
                }
                return "manage/forJsp.do?&requestType=17&num1=" + currentPageNum1;
            } else {
                //earStudyService.saveEdSwtj(id1, name, desc);
                earStudyService.saveEdSwtj(name, desc);
                request.setAttribute("ok", "添加成功");
                return "manage/forJsp.do?&requestType=17&num1=" + currentPageNum1;
            }
        }

mybatis sql如下：

 <insert id="saveEd" parameterType="EarDiseaseSwtj">
        insert into dt_ear_disease_swtj
        (name,desc)
        values
        (#{name},#{desc})
    </insert>

报错代码如下：

HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

type Exception report

message Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc)
        values
        ('qqqe','eqeqe')' at line 2
### The error may involve com.app.dao.mapper.EarDiseaseSwtjMapper.saveEd-Inline
### The error occurred while setting parameters
### SQL: insert into dt_ear_disease_swtj   (name,desc)   values   (?,?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc)
        values
        ('qqqe','eqeqe')' at line 2
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc)
        values
        ('qqqe','eqeqe')' at line 2
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:656)
    org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
root cause

org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc)
        values
        ('qqqe','eqeqe')' at line 2
### The error may involve com.app.dao.mapper.EarDiseaseSwtjMapper.saveEd-Inline
### The error occurred while setting parameters
### SQL: insert into dt_ear_disease_swtj   (name,desc)   values   (?,?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc)
        values
        ('qqqe','eqeqe')' at line 2
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc)
        values
        ('qqqe','eqeqe')' at line 2
    org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
    org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
    org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:365)
    sun.proxy.$Proxy10.insert(Unknown Source)
    org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:237)
    org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:79)
    org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
    sun.proxy.$Proxy39.saveEd(Unknown Source)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:601)
    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
    org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    sun.proxy.$Proxy40.saveEd(Unknown Source)
    com.app.dao.impl.EarDiseaseSwtjDaoImpl.saveEd(Unknown Source)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:601)
    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
    org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    sun.proxy.$Proxy41.saveEd(Unknown Source)
    com.app.service.impl.EarStudyServiceImpl.saveEdSwtj(Unknown Source)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:601)
    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
    org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    sun.proxy.$Proxy99.saveEdSwtj(Unknown Source)
    com.app.totalController.ManageController.forJsp(Unknown Source)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:601)
    org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
    org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:427)
    org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:415)
    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:788)
    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:717)
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
    org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
root cause

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除
收藏举报

8条回答

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
Bug开发攻城狮 2016-07-25 10:08
关注
1.报错，是因为desc是关键字，用引号引起来就好

2.获得插入的id，用keyProperty
相关资料，http://chenzhou123520.iteye.com/blog/1849881

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

java使用mybatis-plus自带方法时，一直出现报错【insert插入方法】 java mysql 数据库
2022-04-09 14:08

回答 2 已采纳 order是关键字，加反引号
MyBatis内SQL语句报错 eclipse java java-ee spring
2020-01-12 22:37

回答 3 已采纳你的有一个参数名叫 describe ，这个在MYSQL中和 EXPLAIN 是同义词，建议你换一个参数名，或者这样使用 ``` insert into t_fix ( `descr
mybatis添加语句一直报空指针 java mysql
2019-10-15 14:59

回答 4 已采纳检查一下dao调用mapper的方法是否使用param注解指定了参数名称，如果传入的是对象的话，在insert标签中需要写上入参类型， ``` parameterType="F728040Req"
mybatis mysql insert 空值_mybatis插入语句空值没有设置jdbcType报错
2021-01-27 20:16

higf12586的博客 nested exception is java.sql.SQLException: 无效的列类型: 1111 需要在插入语句中设置jdbcType 如下 insert into customer_log ( ID, CUSTOMER_SERVICE_USER_NAME, user_name , CONTENT, LOG_FIRST_TYPE, STATUS,...
mysql中执行没问题，mybatis语法报错怎么回事 java mysql spring boot
2022-07-11 15:19

回答 1 已采纳 &lt；来代替看看 https://zhuanlan.zhihu.com/p/101026748
关于mybatis insert语句返回自增id的问题 mysql xml 数据库
2022-07-14 10:47

回答 2 已采纳参考按照如下步骤添加用户信息即可获取自增id. User user = new User(); user.setUserName("张三"); user
mybatis中文插入数据库报错 java spring
2020-01-08 19:07

回答 1 已采纳 https://blog.csdn.net/l1509214729/article/details/80781740
Mybatis mapper.insert插入数据id为null报错
2023-01-04 19:49

ZZULI丶TiAmo的博客要将url中的分号改成&，否则会报错。
关于mybatis执行sqlserver 的with as报错问题 java sql sqlserver
2022-08-16 14:16

回答 3 已采纳看一下你的这个接口是否涉及到分页，如果是需要分页的话，就是先统计总数有段时间没用sqlserver了，忘了是否还支持with as这种写法，oracle这种写法用的比较多。如果直接在sqlserve
mybatis执行select子查询分页报错 sql
2017-11-14 02:45

回答 6 已采纳 SELECT count(0) FROM ad_headhunter_related ah LEFT JOIN ad_release_record adr ON ah.post_id = adr.po
Mybatis-plus代码生成器报错 java maven spring boot
2022-09-30 09:35

回答 3 已采纳你这大括号都不对应啊，肯定报错了，下边方法单独拎出去，放main方法之外
mybatis plus执行insert不生效 mybatis新增数据失败 insert不报错
2022-07-08 16:30

帅杰IT大神的博客 mybatis plus
mybatis 的 insert 语句怎么写
2017-03-13 03:08

回答 6 已采纳问题已经解决 sqlsession 没有commit
Oracle+Mybatis的foreach insert批量插入报错的快速解决办法
2021-05-10 11:01

(-2^63)~(2^63-1)的博客本文给大家介绍Oracle+Mybatis的foreach insert批量插入报错的快速解决办法，非常不错，具有参考借鉴价值，感兴趣的朋友参考下吧最近做一个批量导入的需求，将多条记录批量插入数据库中。解决思路：在程序中...
Oracle+Mybatis的foreach insert批量插入报错的解决办法
2020-08-16 15:11

xiaokanfuchen86的博客转载请注明来源-作者@loongshawn：...而当前这个工程是Oracle+Mybatis，惯性思维就是把那段“foreach insert批量插入”SQL拷贝过来，结果运行就报错了。执行的SQL语句如下： <sql id="attachmentColumn"&
没有解决我的问题, 去提问

悬赏问题

¥15 YoloV5 第三方库的版本对照问题
¥15 请完成下列相关问题！
¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像，如何解决？
¥15 求daily translation（DT）偏差订正方法的代码
¥15 js调用html页面需要隐藏某个按钮
¥15 ads仿真结果在圆图上是怎么读数的
¥20 Cotex M3的调试和程序执行方式是什么样的？
¥20 java项目连接sqlserver时报ssl相关错误
¥15 一道python难题3
¥15 牛顿斯科特系数表表示

mybatis insert插入语句以后 一直报错怎么回事 怎么在保存以后获取保存对象的id

8条回答

悬赏问题

mybatis insert插入语句以后一直报错怎么回事怎么在保存以后获取保存对象的id