const express = require("express");
const app = express();
const mysql = require("mysql");
const crypto = require("crypto");
app.listen(3000, function (err) {
if (!err) {
console.log("监听成功");
}
});
//链接数据库
var db = mysql.createConnection({
host: "**************",
user: "root",
password: "***",
database: "****",
});
db.connect((err) => {
if (!err) {
console.log("数据库连接成功");
}
console.log(err);
});
app.post("/register", (req, res, next)=> {
let username = req.body.username;
let password = req.body.password;
let md5 = crypto.createHash("md5");
let newpass = md5.update(password).digest("hex");
let sql = `insert into wangtinguser values('${username}','${newpass}')`;
db.query(sql, (err, result) => {
if (err) {
console.log(err);
} else {
console.log("注册成功");
}
});
});
app.get('login',(req,res,next)=>{
let username = req.query.username;
let password = req.query.password;
let md5 = crypto.createHash("md5");
let newpass = md5.update(password).digest("hex");
let sql = `select * from wangtinguser where 1=1 username = '${username}' and password ='${newpass}')`;
db.query(sql, (err, result) => {
if (err) {
console.log(err);
} else {
console.log("登录成功");
}
});
})
XHTMT|
HTML5|
CSS|
HTML DOM|
jQuery|
JSON|
AJAX|
LESS|
HTML|
Bootstrap|
Foundation|
AngularJS|
Ember.js|
TypeScript|
AngularJS2|
React|
jQuery UI|
jQuery EasyUI|
Node.js|
Highcharts|
Echarts|
Vue.js|
CoffeeScript|
Ext.js|
Meteor|
SASS|
Omi|
Markdown|
前端开发规范|
浏览器|
webpack|
JavaScript|
CSS3|
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....