Mybatis+mysql UUID primary key generation policy

<insert id= "Insert" parametertype= "Com.gzwb.wbspm.model.SpmInvoice" >

<selectkey keyproperty= "Invoiceid"//Primary key column name resulttype= "string"//Primary key type order= "before"//first get primary key before executing INSERT statement >

SELECT REPLACE (UUID (), '-', ') from DUAL

</selectKey>

Insert into Spm_invoice (Invoiceid, Invoicenum, Invoiceitem,

Invoicedate, Invoicemoney, ClientId,

Clientdepid, Linkman, Invoicestatusid,

Uploadfilename, Uploadfilepath, Uploadfiledate,

Remark

VALUES (#{invoiceid,jdbctype=varchar}, #{invoicenum,jdbctype=varchar}, #{invoiceitem,jdbctype=varchar},

#{invoicedate,jdbctype=date}, #{invoicemoney,jdbctype=double}, #{clientid,jdbctype=integer},

#{clientdepid,jdbctype=integer}, #{linkman,jdbctype=varchar}, #{invoicestatusid,jdbctype=varchar},

#{uploadfilename,jdbctype=varchar}, #{uploadfilepath,jdbctype=varchar}, #{uploadfiledate,jdbctype=timestamp},

#{remark,jdbctype=longvarchar})

</insert>

Mybatis+mysql UUID primary key generation policy