1.安装Mysql模块
1.导入mysql 并测试连接
安装 npm install mysql
const mysql =require('mysql')
const db=mysql.createPool({
host:'115.**.***.**',
user:'****',
password:'****',
database: '****'
})
db.query('SELECT 1',(err,results)=>{
if(err)return console.log(err.message)
console.log(results)
})
2.测试mysql模块
db.query('SELECT 1',(err,results)=>{
if(err)return console.log(err.message)
console.log(results)
3.查询表中所有数据
db.query('SELECT * FROM studyuser',(err,results)=>{
if(err) return console.log(err.message)
console.log(results)
4.定义插入语句
const user = { username: 'Spider-Man', password: '32222123' }
const sqlStr = 'insert into users (username, password) values (?, ?)'
db.query(sqlStr, [user.username, user.password], (err, results) => {
if (err) return console.log(err.message)
if (results.affectedRows === 1) {
console.log('插入数据成功!')
}
})
5.更新数据
const user={username:'Spider-Man',password:'0000'}
const sqlStr='UPDATE users SET ? WHERE username=?'
db.query(sqlStr,[user,user.username],(err,results)=>{
if(err) return console.log(err.message)
if(results.affectedRows ===1){
console.log('更新数据成功')
}
})
6.删除数据
const user={name:'王真'}
const sqlStr ='DELETE FROM users WHERE username=?'
db.query(sqlStr,user.name,(err,results)=>{
if(err)return console.log(err.message)
if(results.affectedRows===1){
console.log('删除成功')
}
})
7.删除数据
const user={name:'王真'}
const sqlStr ='DELETE FROM users WHERE username=?'
db.query(sqlStr,user.name,(err,results)=>{
if(err)return console.log(err.message)
if(results.affectedRows===1){
console.log('删除成功')
}
})