mybatis MySQL返回插入的主键ID,oracle不行

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

...

</insert>

 

或

 

 

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

...

</insert>

 

直接用插入对象的ID来接收就行

 

User user = new User(); user.setUserName("chenzhou"); user.setPassword("xxxx"); user.setComment("测试插入数据返回主键功能"); System.out.println("插入前主键为："+user.getUserId()); userDao.insertAndGetId(user);//插入操作 System.out.println("插入后主键为："+user.getUserId());

 

转载于:https://www.cnblogs.com/whc321/p/5090788.html