<insert id="insert" parameterType="ssm.item.admin.bean.Depart" useGeneratedKeys="true"
//开始添加
keyProperty="departId">
<selectKey keyProperty="departId" resultType="java.lang.String"
order="BEFORE">
select replace(uuid(),'-','') from dual
</selectKey>
//结束添加
insert into depart (depart_id, depart_name, depart_code
)
values (#{departId,jdbcType=VARCHAR}, #{departName,jdbcType=VARCHAR}, #{departCode,jdbcType=VARCHAR}
)
</insert>
<insert id="insertSelective" parameterType="ssm.item.admin.bean.Depart" useGeneratedKeys="true" keyProperty="departId">
<selectKey keyProperty="departId" resultType="java.lang.String"
order="BEFORE">
select replace(uuid(),'-','') from dual
</selectKey>
insert into depart
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="departId != null">
depart_id,
</if>
<if test="departName != null">
depart_name,
</if>
<if test="departCode != null">
depart_code,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="departId != null">
#{departId,jdbcType=VARCHAR},
</if>
<if test="departName != null">
#{departName,jdbcType=VARCHAR},
</if>
<if test="departCode != null">
#{departCode,jdbcType=VARCHAR},
</if>
</trim>
</insert>
在mapper.xml文件中的insert中增加以下标红的代码 实现id采用自增方式写入数据库,并且写入一个uuid字符
最新推荐文章于 2022-11-12 23:51:04 发布