MyBatis调试insert得到返回值和自增的id

最新推荐文章于 2025-06-08 23:43:27 发布

原创最新推荐文章于 2025-06-08 23:43:27 发布 · 5.5k 阅读

CC 4.0 BY-SA版权

本文主要介绍了如何在MyBatis中进行insert操作，并获取到返回值，特别是自增id。通过分析update调用链，包括SqlSessionInterceptor和SqlSessionTemplate的使用，揭示了在代码实现中如何确保得到自增id。同时，强调了在传参过程中，对于int类型，需要转换为Integer来获取自增id。

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

1.insert

package org.apache.ibatis.executor.statement;
...
public class PreparedStatementHandler extends BaseStatementHandler {

  public PreparedStatementHandler(Executor executor, MappedStatement mappedStatement, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, BoundSql boundSql) {
    super(executor, mappedStatement, parameter, rowBounds, resultHandler, boundSql);
  }

  @Override
  public int update(Statement statement) throws SQLException {
    PreparedStatement ps = (PreparedStatement) statement;
    ps.execute();
    int rows = ps.getUpdateCount();
    Object parameterObject = boundSql.getParameterObject();
    KeyGenerator keyGenerator = mappedStatement.getKeyGenerator();
    keyGenerator.processAfter(executor, mappedStatement, ps, parameterObject);
    return rows;
  }

输入输出值

public class SimpleExecutor extends BaseExecutor {

  public SimpleExecutor(Configuration configuration, Transaction transaction) {
    super(configuration, transaction);
  }

  @Override
  public int doUpdate(MappedStatement ms, Object parameter) throws SQLException {
    Statement stmt = null;
    try {
      Configuration configuration = ms.getConfiguration();
      StatementHandler handler = configuration.newStatementHandler(this, ms, parameter, RowBounds.DEFAULT, null, null);
      stmt = prepareStatement(handler, ms.getStatementLog());
      return handler.update(stmt);
    } finally {
      closeStatement(stmt);
    }
  }

这里调用update调用链的

package org.apache.ibatis.session.defaults;
public class DefaultSqlSession implements SqlSession {

调用jdk的反射基类

package java.lang.reflect;
public final class Method extends Executable {

SqlSessionInterceptor

package org.mybatis.spring;
public class SqlSessionTemplate implements SqlSession, DisposableBean {

SqlSessionTemplate

package org.mybatis.spring;
public class SqlSessionTemplate implements SqlSession, DisposableBean {

2.代码写法

@Insert("insert into table(XXX,XXX,XXX) values(#{demo.XXX},#{demo.XXX},#{demo.XXX}) ")        
@SelectKey(keyProperty = "demo.id", keyColumn = "id", statement = "select @@identity as id",resultType = Integer.class, before = false)  
public int insertdemo(@Param("demo") DemoBean demo);

调用