<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>激活码SQL语句生成脚本</title>
</head>
<body>
<script>
function getCdKey(){
//可以生成随机密码的相关数组
var num = ["0","1","2","3","4","5","6","7","8","9"];
var english = ["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 config = num.concat(english);
//先放入一个必须存在的
var arr = [];
arr.push(getOne(num));
arr.push(getOne(english));
for(var i=2; i<6; i++){
//从数组里面抽出一个
arr.push(config[Math.floor(Math.random()*config.length)]);
}
//乱序
var newArr = [];
for(var j=0; j<6; j++){
newArr.push(arr.splice(Math.random()*arr.length,1)[0]);
}
return newArr.join("");
}
//随机从数组中抽出一个数值
function getOne(arr) {
return arr[Math.floor(Math.random()*arr.length)];
}
// 防止重复元素
var hash = {};
function isRepeat(cdkey) {
if(hash[cdkey]) {
cdkey = getCdKey();
isRepeat(cdkey);
return;
}
hash[cdkey] = true;
cdkeySql = cdkeySql + "('" + cdkey + "')";
}
var cdkeySql = "INSERT INTO new_cdkey (cdkey) VALUES ";
function create() {
document.getElementById("cdkeySql").innerHTML = "";
cdkeySql = "INSERT INTO new_cdkey (cdkey) VALUES ";
var number = document.getElementById("cdkeyNum").value;
if(number < 1){
alert("激活码数量不能小于1");
return;
}
for(var i=0; i<number; i++){
var cdkey = getCdKey();
isRepeat(cdkey);
if(i != number-1){
cdkeySql += ",";
}
}
document.getElementById("cdkeySql").innerHTML = cdkeySql;
}
function copy () {
// text是复制文本
if(document.getElementById("cdkeySql").innerHTML == ""){
alert("没有SQL语句,请生成!");
return;
}
var text = cdkeySql;
// 创建input元素
const el = document.createElement('input')
// 给input元素赋值需要复制的文本
el.setAttribute('value', text)
// 将input元素插入页面
document.body.appendChild(el)
// 选中input元素的文本
el.select()
// 复制内容到剪贴板
document.execCommand('copy')
// 删除input元素
document.body.removeChild(el)
alert('复制成功')
}
</script>
激活码生成数量: <input type="number" id="cdkeyNum" value="1">
<button type="button" οnclick="create()">开始生成</button>
<button type="button" οnclick="copy()">复制SQL语句</button>
<p id="cdkeySql"></p>
</body>
</html>
运行效果: