工具類擷取32位随機字元uuid
package com.bgs.util;
import java.util.UUID;
public class UUIDTest { public String getId() { String uuid = UUID.randomUUID().toString(); String id = uuid .substring(0, 8)+ uuid .substring(9,13)+ uuid .substring(14,18)+ uuid .substring(19,23)+ uuid .substring(24);//用substring()去除‘-’,得到由數字組成的uuid return id ; } }
sql語句插入uuid
<!-- int addCustomers(Customers customers); --> < insert id = "addCustomers" parameterType = "Customers" > insert into customers values(null,#{name},#{phoneNumber},#{gender},#{qq},#{email},#{address}, uuid(),#{activeDate}) </ insert >
直接在需要插入uuid的地方使用uuid()