node.js简单登录(无加密和session,form提交)

左手的ㄟ右手 2022-06-02 05:14 135阅读 0赞

post方式

<!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(){
    
    });

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

注：通过输入用户名和密码登录;也可以直接在地址栏输入。