<insert id="createUser" parameterClass="ScimUser">
insert into IAS_USER_INFO(
id,mail,loginname,firstname,lastname,displayname,title
)
values(
#id#,#mail#, #loginName#, #firstName#, #lastName#, #displayName#,#title#
)
<selectKey resultClass="String" keyProperty="id" type="pre" >
SELECT REPLACE(uuid(),'-','') as id
</selectKey>
</insert>
<insert id="createUser" parameterClass="ScimUser">
insert into IAS_USER_INFO(
id,mail,loginname,firstname,lastname,displayname,title
)
values(
#id#,#mail#, #loginName#, #firstName#, #lastName#, #displayName#,#title#
)
<selectKey resultClass="int" keyProperty="id" type="pre" >
SELECT @@IDENTITY AS id
</selectKey>
</insert>
来自为知笔记(Wiz)