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('/',function(req,res){
res.sendFile(__dirname+"/"+"ex9_1.html");
});
app.get('/jquery.min.js',function(req,res){
res.sendFile(__dirname+"/"+"jquery.min.js");
});
app.get('/main',function(req,res){
res.sendFile(__dirname+"/"+"main.html");
});
/*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 binary upwd=?";//记得加binary区分大小写
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));
});
app.get('/list',function(req,res){
var sql="SELECT * FROM test";
pool.getConnection((err,conn)=>{
conn.query(sql,(err,result)=>{
if(result.length>0){
res.json(result);
//res.send(result)也可
}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>Title</title>
</head>
<body>
用户名:<input type="text" name="uname" id="uname"><br/>
密码:<input type="password" name="upwd" id="upwd"><br/>
<input type="submit" id="btn_smt" value="提交">
<script src="jquery.min.js"></script>
<script>
btn_smt.οnclick=function(){
var uname=$("#uname").val();
var upwd=$("#upwd").val();
$.ajax({
type:"post",
url:"/login",
data:{uname:uname,upwd:upwd},
success:function(data){
if(data.code>0){
alert(data.msg);
location.href="/main";
}else{
alert(data.msg);
}
},
error:function(){
alert("网络故障,请检查");
}
});
}
</script>
</body>
</html>
main.html:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<table>
<thead>
<tr>
<td>tid</td>
<td>tname</td>
</tr>
</thead>
<tbody>
</tbody>
</table>
<script src="jquery.min.js"></script>
<script>
$.ajax({
type:"GET",
url:"/list",
success:function(data){
var html="";
for(var i=0;i<data.length;i++){
html+="<tr>";
html+="<td>"+data[i].tid+"</td>";
html+="<td>"+data[i].tname+"</td>";
html+="</tr>";
}
$("tbody").html(html);
},
error:function(){
alert("网络故障,请检查");
}
})
</script>
</body>
</html>