库存管理系统服务器端
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);
})