在项目中使用MySQL

 

const mysql = require('mysql')
const db = mysql.createPool({
       host:'127.0.0.1',
       port:'3306',
       user:'root',
       password:'admin123',
       database:'jyd'
}) 

 

 解决问题：参考链接：(19条消息) node.js连接mysql出现错误ER_NOT_SUPPORTED_AUTH_MODE Client does not support authentication protocol..._leilei__66的博客-CSDN博客

 

 

 

 

 

 

 

 

const user = {username:"spider-man3",password:"pcc123"}
const sqlStr = 'INSERT INTO users SET ?'
db.query(sqlStr,user,(err,results) => {
    if(err) return console.log(err.message)   // 失败情况下
    if(results.affectedRows ===1) {
        console.log('插入数据成功')           
    }
})

 

 

const user = {id:10,username:"spider-man-xx",password:"pc1234"}
const sqlStr = 'update users set username=?,password=? where id=?'
db.query(sqlStr,[user.username,user.password,user.id],(err,results) => {
    if(err) return console.log(err.message)   // 失败情况下
    if(results.affectedRows ===1) {
        console.log('更新数据成功')           
    }
})

 

 +

 

 

const user = {id:10,username:"spider-man-xx1",password:"pc1234"}
const sqlStr = 'update users set ? where id=?'
db.query(sqlStr,[user,user.id],(err,results) => {
    if(err) return console.log(err.message)   // 失败情况下
    if(results.affectedRows ===1) {
        console.log('更新数据成功')           
    }
})

 

 

 

 

// 删除id为10的用户
const sqlStr = 'delete from users where id=?'
db.query(sqlStr,10,(err,results) => {
    if(err) return console.log(err)
    if(results.affectedRows === 1) {
        console.log('删除数据成功')
    }
})

 

 

 

 

const sqlStr = 'update users set status=? where id=?'
db.query(sqlStr,[1,11],(err,results) => {
    if(err) return console.log(err)
    if(results.affectedRows === 1) {
        console.log('标记删除数据成功')
    }
})