mysql执行insert后获得主键

2019独角兽企业重金招聘Python工程师标准>>>

1、XyzMapper.xml

<insertid=“doSomething"parameterType="map"useGeneratedKeys="true" keyProperty=“yourId">
...
</insert>

或

<insert id=“doSomething" parameterType=“com.xx.yy.zz.YourClass" useGeneratedKeys="true" keyProperty=“yourId">
...
</insert>

2、XyzMapper.java

public int doSomething(Map<String, Object> parameters);

or

public int doSomething(YourClass c); 

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

Map<String, Object> parameters = new HashMap<String, Object>();
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

转载于:https://my.oschina.net/yiqifendou/blog/801423