wsz987

兴趣使然 & 见证成长

0%

Node MySQL配置及登录注册接口实例

发表于 分类于 Valine：

安装MySQL依赖

1
npm install mysql --save

连接MySQL

1
2
3
4
5
6
7
8
9
10
const mysql = require('mysql')
const connection = mysql.createConnection({
    host     : 'localhost',
    user     : 'root',
    password : 'root',
    port: 3306,
    database : 'workshop'
  })
connection.connect()
module.exports = connection

已知问题 MySQL 连接存在睡眠期 会断开连接

在需要的页面引用即可

1
const connection =require('../sqlConfig');

login.js

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
const connection =require('../sqlConfig');
const Response = require('./response');
const md5 = require('blueimp-md5')

function login(req,res) {
    let param = req.body;
    console.log("login -> param", param)
    let username = param.username;
    let password = md5(param.password);
    let response = new Response(false,'',-1);
    if(username && password){
        //1、查询数据库中是否有用户名
        connection.query("SELECT * FROM USER WHERE username = ?",[username], function (error, results, fields) {
            if (error) throw error;
            if(results.length >= 1){
                //2、如果有用户名，查询密码是否相同
                if(password == results[0].password){
                    //3、密码相同则登陆成功
                    response = new Response(true,'登陆成功',200);
                    res.send(response);
                }else {
                    response = new Response(false,'登陆失败，密码错误',400);
                    res.send(response);
                }
            }else {
                response = new Response(false,'登陆失败，没有此用户名',400);
                res.send(response);
            }
        });
    }else {
        response = new Response(false,'登陆失败，用户名或密码不能为空',400);
        res.send(response);
    }
}
module.exports = login;

register.js

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
const connection =require('../sqlConfig');
const Response = require('./response');

const md5 = require('blueimp-md5')

function register(req,res) {
    const param = req.body;
    const username = param.username;
    const password = md5(param.password);
    var response = new Response(false,'',-1);
    if(username && password){
        //1、查看数据库中是否有相同用户名
        connection.query("SELECT * FROM USER WHERE username = ?",[username], function (error, results, fields) {
            if (error) throw error;
            if(results.length >= 1){
                //2、如果有相同用户名，则注册失败，用户名重复
                response = new Response(false,'注册失败，用户名重复',422);
                res.send(response);
            }else{
                connection.query("INSERT INTO user(username,password) VALUES(?,?)", [username,password],function (error, results, fields) {
                    if (error) throw error;
                    //3、如果没有相同用户名，并且有一条记录，则注册成功
                    if(results.affectedRows==1){
                        response = new Response(true,'注册成功',201);
                        res.send(response);
                    }else {
                        response = new Response(false,'注册失败',400);
                        res.send(response);
                    }
                });
            }
        })
    }else{
        response = new Response(false,'注册失败，用户名、密码不能为空',-1);
        res.send(response);
    }
}
module.exports = register;

response.js 封装

1
2
3
4
5
6
7
8
9
10
class Response{
    constructor(success,msg,code,result){
       this.success = success;
       this.msg = msg;
       this.code = code;
       this.result = result;
       this.data='666'
    }
}
module.exports = Response;