const express = require("express");
const app = express();
const mysql = require("mysql");
// 创建连接
const db = mysql.createConnection({
host:"localhost",
user:"root",
password:"qwe123",
database:"exapp"
});
// 连接数据库
db.connect( (err) => {
if(err) throw err;
console.log('连接成功');
});
// 插入数据
app.get("/add",(req,res) => {
let post = {category:"node"};
let sql = "INSERT INTO cate SET ?";
db.query(sql,post,(err,result) => {
if(err){
console.log(err);
}else{
console.log(result);
res.send("cate added....")
}
})
});
// 查询内容
app.get("/getex",(req,res) => {
let sql = "SELECT * FROM cate";
db.query(sql,(err,result) => {
if(err){
console.log(err);
}else{
console.log(result);
// res.send("查询成功")
res.json(result)
}
})
});
// 查询单条内容
app.get("/getone/:id",(req,res) => {
const {id} = req.params;
let sql = `SELECT * FROM cate WHERE id = ${id}`;
db.query(sql,(err,result) => {
if(err){
console.log(err);
}else{
console.log(result);
res.json(result)
}
})
});
// 更新内容
app.get("/updateex/:id",(req,res) => {
const {id} = req.params;
let sql = `UPDATE cate SET category = 'vue1111111' WHERE id = ${id}`;
db.query(sql,(err,result) => {
if(err){
console.log(err);
}else{
console.log(result);
res.send(`update ${req.params.id} success....`)
}
})
});
// 删除内容
app.get("/deleteone/:id",(req,res) => {
let sql = `DELETE FROM cate WHERE id = ${req.params.id}`;
db.query(sql,(err,result) => {
if(err){
console.log(err);
}else{
console.log(result);
res.send("删除成功.....")
}
})
});
app.listen(3000, () => {
console.log("服务器开启在3000端口....");
});
01-21
1306
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
05-28
2810
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
06-13
1218
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)