Mybatis中insert中返回主键ID的方法

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);