js和SQL方式随机生成高强度密码

89 阅读 0 评论 59 点赞

我是靠谱客的博主温婉星星，这篇文章主要介绍js和SQL方式随机生成高强度密码，现在分享给大家，希望可以做个参考。

js和SQL方式随机生成高强度密码

JS方式

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>随机生成密码</title>
</head>
<body>
<input type="button" onclick="RanPwd()" value="生成密码" />
<span id="pwd"></span>
<script>
var numChar = ['0', '1', '2', '3', '4', '5', '6', '7', '8', '9'];
var alphChar = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'];
var syblChar = ['~', '!', '@', '#', '$', '%', '^', '&', '*', '-', '+', '?', '￥', ';', '"', '<', '>', '|'];
function generatePwd() {
var res = "";
for(let i = 0; i < 2; i++) {
var id = Math.floor(Math.random() * 10);
res += numChar[id];
}
for(let j = 0; j < 3; j++) {
var id = Math.floor(Math.random() * 26);
res += alphChar[id];
}
for(let k = 0; k < 1; k++) {
var id = Math.floor(Math.random() * 18);
res += syblChar[id];
}
return res;
}
function strengthPwd(pwd) {
var len = n = pwd.length-1;
pwd = pwd.split("");
var newPwd = "";
for(var i = 0; i <= len; i++) {
var id = Math.floor(Math.random() * n)
newPwd += pwd.splice(id,1);
n--;
}
return newPwd;
}
function RanPwd(){
var prePwd = generatePwd();
var pwd = strengthPwd(prePwd);
document.getElementById("pwd").innerHTML = pwd;
}
</script>
</body>
</html>

SQL方式

--生成高强度的随机密码
declare @strPwd varchar(82)
declare @i int
declare @n int
declare @Index int
declare @pwd varchar(6)
declare @newPwd varchar(6)
set @i = 0
set @pwd = ''
set @newPwd = ''
set @strPwd = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ~!@#$%^&*-=+?.,;:|><'
while (@i < 6)
begin
if(@i<2)
begin
set @Index = ceiling((rand() * 10))
end
else if(@i<5 and @i>=2)
begin
set @Index = ceiling(rand() * 52 + 10)
end
else if(@i=5)
begin
set @Index = ceiling(rand() * 20 + 62)
end
set @pwd = @pwd + substring(@strPwd,@Index,1)
set @i = @i + 1
end
set @i = 0
set @n = LEN(@pwd)
while (@i < 6)
begin
set @Index = ceiling(rand() * @n)
set @newPwd =
@newPwd + substring(@pwd,@Index,1)
set @pwd = STUFF(@pwd,@Index,1,'')
set @n = @n-1
set @i = @i + 1
end
select @newPwd