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

秒速五厘米 2022-06-02 05:17 125阅读 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>