库存管理系统服务器端

库存管理系统服务器端

---

time:2016.2.6
author:fozzz

---

主要代码

---

he.js

var express = require('express');
var app = express();
var mysql = require('mysql');

app.get('/login', function(req, res) {
    var nowTime = new Date();
    var time = nowTime.getFullYear() + '/' + (nowTime.getMonth() + 1) + '/' + nowTime.getDate() + ' ' + nowTime.getHours() + ':' + nowTime.getMinutes() + ':' + nowTime.getSeconds();

    var result = 0;
    var password = '';
    var conn = mysql.createConnection({
        host: 'localhost',
        user: 'root',
        password: 'admin',
        database: 'he',
        port: 3306
    });
    conn.connect();
    conn.query('select * from t_user', function(err, rows, fields) {
        if (err) {
            throw err;
        }
        if (req.query.username == rows[0].username) {
            if (req.query.password == rows[0].password) {
                result = 1;
                console.log('IP:' + req.hostname + '工号:' + req.query.username + '-->登录成功' + '-->时间:' + time);
            }
        }
        res.json({
            result: result
        });

    });
    conn.end();

})

app.get('/forget', function(req, res) {
    var conn = mysql.createConnection({
        host: 'localhost',
        user: 'root',
        password: 'admin',
        database: 'he',
        port: 3306
    });
    conn.connect();
    conn.query('select * from t_admin', function(err, rows, fields) {
        if (err) {
            throw err;
        }
        res.json(rows);
    });
    conn.end();
})

app.get('/list', function(req, res) {
    var conn = mysql.createConnection({
        host: 'localhost',
        user: 'root',
        password: 'admin',
        database: 'he',
        port: 3306
    });
    conn.connect();
    conn.query('select * from t_list', function(err, rows, fields) {
        if (err) {
            throw err;
        }
        res.json(rows);
    });
    conn.end();
})

app.get('/reg', function(req, res) {
    var nowTime = new Date();
    var time = nowTime.getFullYear() + '/' + (nowTime.getMonth() + 1) + '/' + nowTime.getDate() + ' ' + nowTime.getHours() + ':' + nowTime.getMinutes() + ':' + nowTime.getSeconds();

    var result1 = 0;
    var conn = mysql.createConnection({
        host: 'localhost',
        user: 'root',
        password: 'admin',
        database: 'he',
        port: 3306
    });
    conn.query('select * from t_user', function(err, rows, fields) {
        if (err) {
            throw err;
        }
        if (req.query.nowU == rows[0].username) {
            if (req.query.nowP == rows[0].password) {
                result1 = 1;
                console.log(result1);
                conn.query('UPDATE t_user SET password=? where username=?', [req.query.newP, req.query.nowU]);
            }
            console.log('IP:' + req.hostname + '工号:' + req.query.nowU + '-->修改密码成功' + '-->时间:' + time);
        }
        res.json({
            result: result1
        });
    });
})

var server = app.listen(8081, function() {
    var host = server.address().address;
    var port = server.address().port;
    console.log('服务器启动成功');
    console.log('ip:' + host);
    console.log('port:'+port);
})