1.mysql模块安装
npm install mysql --save
2.连接数据库:db_config.js
const mysql = require('mysql')
//创建连接
const conn = mysql.createConnection({
host:'112.126.63.18',
user:'lijing',
password:'lijing123',
port:'3306',
database:'zhifu'
})
//建立连接
conn.connect()
let sql = 'select * from user'
//执行sql语句
conn.query(sql,(err,result)=>{
if(err) throw err
console.log(result)
})
//关闭连接
conn.end()
结果:
3.通过占位符实现传参,query方法第二参数就是会填充sql语句里的?
const mysql = require('mysql')
//创建连接
const conn = mysql.createConnection({
host:'112.126.63.18',
user:'lijing',
password:'lijing123',
port:'3306',
database:'zhifu'
})
//建立连接
conn.connect()
let sql = 'select * from user where name = ? and id = ?'
//执行sql语句
conn.query(sql,['fff','1'],(err,result)=>{
if(err) throw err
console.log(result)
})
//关闭连接
conn.end()
4. mysql连接池与普通连接的区别以及它的使用方法
4.1 频繁的创建、关闭连接会减低系统的性能,提高系统的开销