mybatis报错：当要返回刚刚插入数据的id时

最新推荐文章于 2024-08-22 19:04:56 发布

coci曹

最新推荐文章于 2024-08-22 19:04:56 发布

阅读量9.9k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： mybatis+ibatis

本文链接：https://blog.youkuaiyun.com/CociJava/article/details/50354306

mybatis+ibatis 专栏收录该内容

8 篇文章

订阅专栏

本文解决了一个在使用MyBatis进行数据库操作时遇到的问题：在插入数据后获取自动生成的主键ID。问题源于配置文件中未正确指定返回类型，通过明确设置resultType=int得以解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: org.apache.ibatis.executor.ExecutorException: Error selecting key or setting result to parameter object. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.coci.entity.addUser!selectKey'. It's likely that neither a Result Type nor a Result Map was specified.
### The error may involve com.coci.entity.addUser!selectKey-Inline
### The error occurred while setting parameters
### Cause: org.apache.ibatis.executor.ExecutorException: Error selecting key or setting result to parameter object. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.coci.entity.addUser!selectKey'. It's likely that neither a Result Type nor a Result Map was specified.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:104)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:91)
at com.coci.test.Test1.addUser(Test1.java:98)
at com.coci.test.Test1.main(Test1.java:24)
Caused by: org.apache.ibatis.executor.ExecutorException: Error selecting key or setting result to parameter object. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.coci.entity.addUser!selectKey'. It's likely that neither a Result Type nor a Result Map was specified.
at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:60)
at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processAfter(SelectKeyGenerator.java:32)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:26)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:73)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:43)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:102)
... 3 more
Caused by: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.coci.entity.addUser!selectKey'. It's likely that neither a Result Type nor a Result Map was specified.
at org.apache.ibatis.executor.resultset.FastResultSetHandler.validateResultMapsCount(FastResultSetHandler.java:111)
at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:95)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:40)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:95)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:50)

... 10 more

原因：

在mybatis的mapper配置中，在插入一条数据之后，要返回刚刚插入这条数据的ID，这里必须要设置id的返回类型（ resultType="int"），否则会报以上的错误

<insert id="addUser" parameterType="com.coci.entity.User">
	
		<selectKey order="AFTER" keyProperty="uid" resultType="int">

			select LAST_INSERT_ID()
		</selectKey>
		insert into user(uname,uage) values(#{uname},#{uage})
</insert>