工具类获取32位随机字符uuid
package
com.bgs.util;
import
java.util.UUID;
public
class
UUIDTest {
/**
* 获取32位随机字符
*/
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()