<insert id="add" parameterClass="User">
<selectKey resultClass="java.lang.String" keyProperty="userId">
SELECT rawtohex(sys_guid()) AS userId FROM DUAL
</selectKey>
insert into users (userId,account,username,password,status,institutionId)
values (#userId#,#account#,#username#,#password#,#status#,#institutionId#)
</insert>
<selectKey resultClass="java.lang.String" keyProperty="userId">
SELECT rawtohex(sys_guid()) AS userId FROM DUAL
</selectKey>
insert into users (userId,account,username,password,status,institutionId)
values (#userId#,#account#,#username#,#password#,#status#,#institutionId#)
</insert>