下载第三方mysql命令:npm install mysql
const mysql = require('mysql')
//引入第三方mysql安装包
const connectObj = mysql.createConnection({
host:'localhost',
port:3306,
user:'root',
password:'b123',
database:'mydb'
})
//创建数据库连接对象
connectObj.connect()
//连接数据库
//执行sql语句
let sql = 'select id,name,price,num from product'
connectObj.query(sql,function(err,result){
if(err){
console.log('查询数据库出错 ',err);
return
}
// console.log(result);
for(let i = 0; i < result.length; i++){
console.log(result[i].id,'\t',result[i].name,'\t',result[i].price,'\t',result[i].num);
}
})
