Mybatis返回插入主键id的方法_Java教程

Mybatis返回插入主键id的方法

2020-09-10 14:08Mr_YarNell Java教程

这篇文章主要介绍了 Mybatis返回插入主键id的方法，在文章底部给大家补充了Mybatis中insert中返回主键ID的方法，非常不错，需要的朋友可以参考下

在mapper的xml文件中配置 useGeneratedKeys

以及 keyProperty 返回Id即可

id="highlighter_288088">

									<insert id="insertObject" useGeneratedKeys="true"  keyProperty="id" parameterType="www.change.tm.model.Orders" >

									insert into orders

									<trim prefix="(" suffix=")" suffixOverrides=",">

									<if test="number!=null">

									OrderNumber,

									</if>

									<if test="orderTime!=null">

									orderTime,

									</if>

									</trim>

									values

									<trim prefix="(" suffix=")" suffixOverrides=",">

									<if test="number!=null">

									#{number},

									</if>

									<if test="orderTime!=null">

									#{orderTime},

									</if>

									</trim>

									</insert>

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