Node.js 操作mySql数据库

var express =require("express")
var app=express();
app.listen(3000,()=>{
    console.log("服务器在3000端口监听")
})
// 解决跨域问题
app.all('*', function(req, res, next) {
    res.header("Access-Control-Allow-Origin", "*");
next();  
});
var mysql=require("mysql")
var connection=mysql.createConnection({
    host:"10.0.25.4",
    user:"root",
    password:"Palmap+2017",
    database:"pls"
})
connection.connect();

// 查询记录
 app.get("/",function(req,res){
    
var  sql = 'SELECT * FROM ProjectManagement;';
connection.query(sql,function (err, result) {
        if(err){
          console.log('[SELECT ERROR] - ',err.message);
          return;
        }
       console.log(result);
       res.send(result)
});
// connection.end();
})
//