post方式
login.html:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>login</title>
</head>
<body>
<form action="http://127.0.0.1:8081/login" method="POST">
登录名:<input type="text" name="uname"><br>
密码:<input type="password" name="upwd"><br>
<input type="submit" value="Submit">
</form>
</body>
</html>
server.js:
/**
* Created by web-01 on 2018/1/4.
*/
var express=require('express');
var app=express();
var bodyParser=require('body-parser');
var m=require("./init1.js");
var pool=m.pool;
var urlencodedParser=bodyParser.urlencoded({extended:false});
app.use(express.static('public'));
app.get('index.html',function(req,res){
res.sendFile(__dirname+"/"+"index.html");
});
app.post('/login',urlencodedParser,function(req,res){
var response={
"uname":req.body.uname,
"upwd":req.body.upwd
};
console.log(response.uname);
var sql="SELECT * FROM t_user WHERE uname=? AND upwd=?";
pool.getConnection((err,conn)=>{
conn.query(sql,[response.uname,response.upwd],(err,result)=>{
if(result.length>0){
res.json({code:1,msg:"登录成功"});
}else{
res.json({code:-1,msg:"用户名或密码错误"});
}
conn.release();
});
})
//res.end(JSON.stringify(response));
});
var server=app.listen(8081,function(){
});
注:通过html界面输入用户名和密码登录。
-------------------------------------------------------------------------
get方式
server.js:
/**
* Created by web-01 on 2018/1/4.
*/
var express=require('express');
var app=express();
var m=require("./init1.js");
var pool=m.pool;
app.get("/login",(req,res)=>{
var uname=req.query.uname;
var upwd=req.query.upwd;
var sql="SELECT uid FROM t_user WHERE uname=? AND upwd=?";
pool.getConnection((err,conn)=>{
conn.query(sql,[uname,upwd],(err,result)=>{
if(result.length>0){
res.json({code:1,msg:"登录成功"});
}else{
res.json({code:-1,msg:"用户名或密码错误"});
}
conn.release();
});
});
});
var server=app.listen(8081,function(){
});
login.html:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>login</title>
</head>
<body>
<form action="http://127.0.0.1:8081/login" method="get">
登录名:<input type="text" name="uname"><br/>
密码:<input type="password" name="upwd"><br/>
<input type="submit" value="提交">
</form>
</body>
</html>
注:通过输入用户名和密码登录;也可以直接在地址栏输入。