mysql连接

连接mysql数据库

1. npm install mysql
2. 配置mysql

const mysql = require('mysql');
const db = mysql.createPool({
	host: '127.0.0.1',
	user: 'root',
	password: 'root',
	database: 'my_db_01'
});

3.测试连接效果

const sql = 'select * from users';
db.query(sql, (err, res) => {
	if(err) return console.log(err.message);
	console.log(res);
});

插入数据

const user = {username: 'yy', password: '123'};
const sql = 'insert into users (username, password) value (?,?)';
db.query(sql, [user.name, user.password], (err, res) => {
	if(err) return ;
	if(res.affectedRows === 1) console.log('插入成功');
});

//便捷写法
cosnt sql2 = 'insert into users set ?';
db.query(sql2, user , (err, res) => {});

更新数据

const user = { id : 1, username: 'uu', password: '22'};
const sql  = 'update users set username = ? , password = ? where id = ? ';
db.query(sql , [user.username, user.password, user.id], (err, res) => {
	if(err) return console.log(err.message);
	if(res.affectedRows === 1) console.log('更新成功');
});

//便捷写法
const sql  = 'update users set ? where id = ?';
db.query(sql, [user, user.id], (err, res) => {});

删除数据

const sql = 'delete from users where id = ? ';
db.query(sql, 1, (err, res) => {});