js链接mySQl数据库

//下载第三方mysql命令：npm install mysql

const mysql = require('mysql') //引入mysql安装包

//创建数据库链接对象
const loyObj = mysql.createConnection({
    host:'localhost',
    port:3306,
    user:'root',
    password:'123',
    database:'mygoods'
})

//链接数据库
loyObj.connect()

//执行sql语句
let sql = 'select id,name,price from product'
loyObj.query(sql,function(err,result){
    if(err){
        console.log('数据库出错',err);
        return
    }
    console.log(result);
})
loyObj.end()//结束