需要先npm install mysql 下载mysql,然后再电脑上安装mysql server端
const mysql = require('mysql')
var connection = mysql.createConnection
({
host : 'localhost',
user : 'root',
password : 'xgg001214',
database : 'zmk_pc'
});
connection.connect();
var sql = "insert into zmk_user (user_name,pwd,nick)values('"+username.value+"','"+md5_pwd+"','"+nick.value+"')";
connection.query(sql,(err,result)=>
{
if(err)
{
alert('insert error'+err.message);
return;
}
alert('insert success');
})
connection.end();