论坛 › MySQL运维 › mybatis+MySQL UUID主键生成策略

yiwai 发表于 2018-10-1 09:36:29

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

查看完整版本: mybatis+MySQL UUID主键生成策略