mybatis如何获取oracle新插入数据记录的主键?

最新推荐文章于 2022-09-04 16:41:34 发布

不急god

最新推荐文章于 2022-09-04 16:41:34 发布

阅读量5k

点赞数 5

分类专栏： mybatis

本文链接：https://blog.youkuaiyun.com/sdzhangshulong/article/details/50729827

版权

mybatis 专栏收录该内容

15 篇文章

订阅专栏

第一用序列

  <insert id="insertSelective" parameterType="com.zehin.vpaas.base.domain.SfyHazardAnalysis">
		<selectKey resultType="java.lang.Integer" order="BEFORE" keyProperty="hazardId">
				SELECT SEQUENCE_1.NEXTVAL FROM DUAL
		</selectKey>
		insert into SFY_HAZARD_ANALYSIS
		<trim prefix="(" suffix=")" suffixOverrides=",">
			HAZARD_ID,
			<if test="hazardTime != null"> HAZARD_TIME,</if>
			<if test="hazardTitle != null"> HAZARD_TITLE,	</if>
			<if test="hazardMeasure != null"> HAZARD_MEASURE,	</if>
			<if test="buildId != null"> BUILD_ID,	</if>
		</trim>
		<trim prefix=" values(" suffix=")" suffixOverrides=",">
			#{hazardId,jdbcType=INTEGER},
			<if test="hazardTime != null">#{hazardTime,jdbcType=VARCHAR},</if>
			<if test="hazardTitle != null"> #{hazardTitle,jdbcType=VARCHAR},	</if>
			<if test="hazardMeasure != null"> #{hazardMeasure,jdbcType=VARCHAR},	</if>
			<if test="buildId != null"> #{buildId,jdbcType= INTEGER},	</if>
		</trim>
	</insert>

上面就能实现，当你在java中往数据库中插入一个对象，即一条数据时，可以获取主键值，如下所示

@RequestMapping(value = "/addConstruManageInfo")
	@ResponseBody
	public Result addConstruManageInfo(SfyBuild sfyBuild){
		System.out.println("查看传入的值====================================="+JSONObject.fromObject(sfyBuild).toString());
		System.out.println("===========================================================输入前主键值"+sfyBuild.getBuildId());//NULL
		int rows = sfyConstruManageService.insert(sfyBuild);
		System.out.println("===========================================================输入后主键值"+sfyBuild.getBuildId());//数值

第二种 guid

<insert id="insertUser" parameterType="com.danny.mybatis.po.User"> 
<selectKey keyProperty="userId" order="BEFORE" resultType="java.lang.Integer"> 
select SYS_GUID() as userId from DUAL
 </selectKey> 
insert into T_USER(userId,userName,birthday,sex,address) values (#{userId},#{userName},#{birthday},#{sex},#{address}) </insert>

以下是mysql中获取插入数据主键的配置方法

<insert id="add" parameterType="EStudent" useGeneratedKeys="true" keyProperty="id">
  insert into TStudent(name, age) values(#{name}, #{age})
</insert>