首页 > 代码库 > Mybatis中insert中返回主键ID的方法

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