nodejs实现mysql增删改查基本语句

users为表名，(username,password) 为字段名

const mysql = require('mysql')
const connection = mysql.createConnection({
  host:'localhost',
  user:'数据库用户名',
  password:'数据库密码',
  database:'数据库名',
  port:3306
})
connection.connect()

// 查询
let sql = 'SELECT id,username,password FROM users'
connection.query(sql,(err,res)=>{
  if(err){
    console.log(err.message)
    return
  }
  // console.log(res)
  res.forEach(element => {
    console.log(element.id,element.username,element.password)
  });
})

// 插入
let sql = 'INSERT INTO users (username,password) VALUES (?,?)'
connection.query(sql,['admin3','123456'],(err,res) => {
  if(err){
    console.log(err.message)
    return
  }
  console.log('插入成功'+res.insertId)//insertId插入数据的id
})

// 删除
let sql = 'DELETE FROM users WHERE id=?'
connection.query(sql,4,(err,res) => {
  if(err){
    console.log(err.message)
    return
  }
  if(res.affectedRows != 0)console.log('删除成功')//affectedRows受影响行数，=0说明没有受影响行数，操作失败
  console.log('删除失败')
})

// 修改
let sql = 'UPDATE users SET password=? WHERE id=?'
connection.query(sql,['123456',3],(err,res) => {
  if(err){
    console.log(err.message)
    return
  }
  if(res.affectedRows != 0){
    console.log('修改成功')
    console.log(res)
    return
  }
  console.log('修改失败')
})
connection.end()