const mysql = require('mysql');
const connect = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'root',
database: 'blog'
});
connect.connect();
function keepalive (connect) {
connect.query('select 1', [], function (err, result) {
if (err) return console.log(err);
// Successul keepalive
});
}
//5个小时发送一次 1小时 60 * 60
setInterval(() => { keepalive(connect) }, 60 * 60 * 5);
module.exports = connect;
Cannot enqueue Handshake after invoking quit
node:events:505
let mysql = require('../../config/db.js');
//检验这个密码有没有注册过
var sql = `select id,username from blog_admin where username = '${username}'`;
console.log(sql);
mysql.query(sql, function (err, result) {
if (err) {
console.log('[SELECT ERROR] - ', err.message);
return;
}
if (result.length > 0) {
res.send("<script>alert('该用户名已存在!!');history.go(-1);</script>");
return;
}
var md5 = crypto.createHash('md5');
password = md5.update(password).digest('hex');
var time = Math.round(((new Date()).getTime()) / 1000);
var sql = `insert into blog_admin(username,password,status,time) values('${username}','${password}',${status},${time})`;
mysql.query(sql, function (err, result) {
if (err) {
console.log('[SELECT ERROR] - ', err.message);
return;
}
if (result.affectedRows == 1) {
res.send("<script>alert('添加成功');location.href='/admin/admin/add';</script>");
} else {
res.send("<script>alert('添加失败');history.go(-1);</script>");
}
console.log(result);
//res.send("<script>alert('管理员添加成功!!');</script>");
})
})