node搭建服务器,简单实现增删改查接口
const express = require("express")
const mysql = require("mysql")
const querystring = require("querystring");
const app = express()
const bodyParser = require("body-parser");
app.use(bodyParser.urlencoded({ extended: false }));
app.use(bodyParser.json());
const db = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'xxxxxxxx',
database: 'nodeTest',
useConnectionPooling: true
})
db.connect(err => {
if(err) {
console.log(err);
console.log("数据库连接失败!");
} else console.log("数据库连接成功!");
})
app.get('/', (req, res) => {
res.send("hello world")
})
app.get('/getAllUser', (req, res) => {
const str = "select * from user"
db.query(str, (err, result) => {
if(err) return console.log(err);
res.send(result)
})
})
app.get('/delUser', (req, res) => {
let id = req.query.id;
const str = `DELETE from user where id=${id}`
db.query(str, (err, result) => {
if(err) return console.log(err);
if(result.affectedRows >= 0) {
const data = {
status: 200,
}
res.send(data)
}
})
})
app.post('/addUser', (req, res) => {
let postparams = req.body;
let name = postparams.name;
let age = postparams.age;
let sex = postparams.sex;
const str = `insert into user(name,age,sex) VALUES("${name}","${age}","${sex}")`
db.query(str, (err, result) => {
if(err) return console.log(err)
console.log(result.affectedRows)
if(result.affectedRows >= 0) {
const data = {
status: 200,
}
res.send(data)
}
})
})
app.post('/editUser', (req, res) => {
let postparams = req.body;
let id = postparams.id;
let name = postparams.name;
let age = postparams.age;
let sex = postparams.sex;
const str = `update user
SET name='${name}',age=${age},sex='${sex}'
WHERE id=${id}`
db.query(str, (err, result) => {
if(err) return console.log(err)
if(result.affectedRows >= 0) {
const data = {
status: 200,
}
res.send(data)
}
})
})
app.listen(8888, () => {
console.log("服务器启动成功! 端口8888")
})