1.为项目新建包管理模块
npm init -y
2.下载mysql包
npm i mysql
3.导入mysql
const mysql = require('mysql')
4.新建数据库连接池
const db = mysql.createPool({
host:'127.0.0.1',//填你的数据库所在的ip地址
user:'root',//账号名
password:'root',//密码
database:'my_db_01'//填要连接的数据库名
})
5.对数据库进行增删查改
①查询数据库
db.query('select * from users', (err, res) => {
if(err)return console.log(err)
console.log(res)
})
结果:
db.query('select * from users where id=9', (err, res) => {
if(err)return console.log(err)
console.log(res)
})
结果:
②插入数据
const user ={
password:'6666',
username:'负拾捌',
}
db.query('insert into users (username,password) value (?, ?)',[user.username,user.password],(err, res) => {
if(err)return console.log(err.message)
console.log(res.affectedRows)//受影响的行数
})
效果:
简易写法:
const user ={
password:'8888',
username:'耶耶耶',
}
db.query('insert into users set ?',user,(err, res) => {
if(err)return console.log(err.message)
console.log(res.affectedRows)
})
效果:
③更新数据
const user ={
password:'1111',
username:'噢噢噢',
id:12
}
db.query('update users set username=?, password=? where id=?',[user.username, user.password,user.id],(err, res) => {
if(err)return console.log(err.message)
console.log(res.affectedRows)
})
简易写法:
const user ={
password:'kkkk',
username:'嗯嗯嗯',
id:12
}
db.query('update users set ? where id=?',[user, user.id],(err, res) => {
if(err)return console.log(err.message)
console.log(res.affectedRows)
})
效果:
④删除数据
db.query('delete from users where id=?',12,(err, res) => {
if(err)return console.log(err.message)
console.log(res.affectedRows)
})