千家信息网

mybatis+MySQL UUID主键生成策略

发表于:2025-11-11 作者:千家信息网编辑
千家信息网最后更新 2025年11月11日,SELECT REPLACE(UUID(),'-','') FROM DUALinsert into spm_invoice (invoiceId, invoiceNum, invoiceItem,i
千家信息网最后更新 2025年11月11日mybatis+MySQL UUID主键生成策略

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})


0