node.js 登录跳转(无加密,无session,ajax,post)

最新推荐文章于 2022-06-01 09:30:33 发布

spfLinux

最新推荐文章于 2022-06-01 09:30:33 发布

阅读量671

点赞数

分类专栏： node.js 文章标签： node.js 登录跳转无加密无session ajax post

node.js 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

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(){

});

<!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>

spfLinux

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
node.js 登录跳转(无加密,无session,ajax,post)

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 urlenc
复制链接

扫一扫