Mybaties插入生成UUID并返回主键
PGSQL
PGSQL
<insert id="insertData" parameterType="Object">
<selectKey resultType="long" keyProperty="Object_id">
select uuid_generate_v4();
</selectKey>
insert...语句
</insert>
ORACLE在这里插入代码片
<insert id="AltName.insert" parameterType="AltName">
<selectKey keyProperty="id" resultType="String" order="BEFORE">
select sys_guid() from dual
</selectKey>
insert into ...
</insert>
MYSQL
<insert id="insert" parameterType="com.mawulou.model.Functions" >
<selectKey keyProperty="pkGlobalId" resultType="String" order="BEFORE">
select uuid() from dual
</selectKey>
insert into ...
</insert>