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

最新推荐文章于 2025-05-22 12:47:44 发布

csmzl

最新推荐文章于 2025-05-22 12:47:44 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： JS和JQuery 数据库文章标签： sql javascript 高强度密码

本文链接：https://blog.youkuaiyun.com/csmzl/article/details/60135150

JS和JQuery 同时被 2 个专栏收录

28 篇文章

订阅专栏

数据库

6 篇文章

订阅专栏

本文探讨了两种方法来生成高强度密码，包括JavaScript（JS）实现和SQL（结构化查询语言）实现，旨在确保密码的安全性和复杂性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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