Node.js+Express+MySql实现用户登录注册
IDE:WebStorm
工程目录:
数据库表
Login.js:
var express=require ('express' );
var app=express();
var mysql=require ('mysql' );
var connection = mysql.createConnection({
host : '127.0.0.1' ,
user : 'root' ,
password : '1996112lin' ,
database : 'mydata' ,
port:'3306'
});
connection.connect();
app.get('/' ,function (req,res ) {
res.sendfile(__dirname + "/" + "index.html" );
})
app.get('/login' ,function (req,res ) {
var name=req.query.name;
var pwd=req.query.pwd;
var selectSQL = "select * from user where uname = '" +name+"' and pwd = '" +pwd+"'" ;
connection.query(selectSQL,function (err,rs ) {
if (err) throw err;
console .log(rs);
console .log('OK' );
res.sendfile(__dirname + "/" + "OK.html" );
})
})
app.get('/register.html' ,function (req,res ) {
res.sendfile(__dirname+"/" +"register.html" );
})
app.get('/register' ,function (req,res ) {
var name=req.query.name;
var pwd=req.query.pwd;
var user={uname:name,pwd:pwd};
connection.query('insert into user set ?' ,user,function (err,rs ) {
if (err) throw err;
console .log('ok' );
res.sendfile(__dirname + "/" + "index.html" );
})
})
var server=app.listen(7744 ,function ( ) {
console .log("start" );
})
Index.html:
<!DOCTYPE html>
<html lang ="en" >
<head >
<meta charset ="UTF-8" >
<title > Title</title >
</head >
<body >
<form action ="http://127.0.0.1:7744/login" >
<input type ="text" name ="name" />
<input type ="text" name ="pwd" />
<input type ="submit" value ="提交" />
</form >
<a href ="register.html" > 注册</a >
</body >
</html >
Register.html:
<!DOCTYPE html>
<html lang ="en" >
<head >
<meta charset ="UTF-8" >
<title > Title</title >
</head >
<body >
<form action ="http://127.0.0.1:7744/register" >
<input type ="text" name ="name" />
<input type ="text" name ="pwd" />
<input type ="submit" value ="提交" />
</form >
</body >
</html >