mysql insert后获取主键_mysql执行insert后获得主键

1、XyzMapper.xml

...

或

...

2、XyzMapper.java

public int doSomething(Map parameters);

or

public int doSomething(YourClass c);

3、要在map或c中有一个字段名为yourId，Mybatis会自动把主键值赋给这个字段。

Map parameters = new HashMap();

parameters.put(“yourId”, 1234);

...

mapper.doSomething(parameters);

System.out.println(“id of the field that is primary key” + parameters.get(“yourId"))

或

YourClass c = new YourClass();

...

mapper.doSomething(c);

System.out.println(“id of the field that is primary key” + c.yourId);

注意：

获得的主键在查询条件中，如parameters.get("yourId")或c.yourId