java生成随机八位数编码,且用户编码唯一
private String creatUserCodeU() {
boolean b = true;
String usercode = "";
while (b) {
usercode = String.valueOf((int) ((Math.random() * 9 + 1) * 100000*100));
int have = sysUserMapper.selectUserCount(usercode);
if (have == 0) {
b = false;
}
}
return usercode;
}
查看数据库是否有此随机的编码
<select id="selectUserCount" parameterType="String" resultType="int">
select count(0) from XXX where user_code = #{userCode}
</select>