Mybatis+MySQL UUID primary key generation strategy
SELECT REPLACE (UUID (),'-',') FROM DUAL
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})