const express = require('express');
const mysql = require('mysql');
const app = express();
const db = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'mysql',
database: 'test'
});
// 创建数据库
app.get('/createDB', (req, res) => {
let sql = "CREATE DATABASE test";
db.query(sql, (err, rs) => {
if (err) throw err;
res.send('test 数据库 加载完成!');
});
});
// 创建表格 boxs
app.get('/createBoxs', (req, res) => {
let sql =
`CREATE TABLE Boxs(
id int AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
descript VARCHAR(255) NOT NULL,
PRIMARY KEY(id)
)`;
db.query(sql, (err, rs) => {
if (err) {
console.log(err);
res.send('Boxs 表格已经存在!');
}
console.log(rs);
res.send('Boxs 表格创建成功!');
})
});
// 添加数据
app.get('/boxsAdd', (req, res) => {
var addSql = 'INSERT INTO Boxs(Id,name,descript) VALUES(0,?,?)';
var addSqlParams = ['菜鸟工具', 'https://c.runoob.com'];
let box = { name: "xxxxx", descript: "yyyyyyyyyy" };
let sql = 'INSERT INTO boxs SET ?';
db.query(addSql, addSqlParams, (err, rs) => {
// db.query(sql, box, (err, rs) => {
if (err) {
console.log(err);
res.send('Boxs 数据添加失败!');
}
console.log(rs);
res.send('Boxs 数据添加成功!');
})
});
// 查询数据
app.get('/boxs', (req, res) => {
let sql = 'SELECT * FROM boxs';
db.query(sql, (err, rs) => {
if (err) {
console.log(err);
res.send('Boxs 数据查询失败!');
}
console.log(rs);
res.send(rs);
})
});
// 查询数据:id
app.get('/boxs/:id', (req, res) => {
let sql = 'SELECT * FROM boxs WHERE id="' + req.params.id +'"';
db.query(sql, (err, rs) => {
if (err) {
console.log(err);
res.send('Boxs 数据查询失败!');
}
console.log(rs);
res.send(rs);
})
});
// 更新数据:id
app.get('/boxsUpdate/:id', (req, res) => {
let name = "asdasdfasdfasdfasd";
let sql = 'UPDATE boxs SET name="' + name + '" WHERE id="' + req.params.id +'"';
db.query(sql, (err, rs) => {
if (err) {
console.log(err);
res.send('Boxs 数据更新失败!');
}
console.log(rs);
res.send('Boxs 数据更新成功!');
})
});
// 删除数据:id
app.get('/boxsDelete/:id', (req, res) => {
let sql = 'DELETE FROM boxs WHERE id="' + req.params.id +'"';
db.query(sql, (err, rs) => {
if (err) {
console.log(err);
res.send('Boxs 数据删除失败!');
}
console.log(rs);
res.send('Boxs 数据删除成功!');
})
});
app.get('/', (req, res) => {
res.send('Hello World!');
})
app.listen('3001', (req, res) => {
console.log('已经正常运行');
})
学习node.js链接mysql
最新推荐文章于 2021-05-26 17:56:56 发布