var express =require("express")
var app=express();
app.listen(3000,()=>{
    console.log("服務器在3000端口監(jiān)聽")
})
// 解決跨域問題
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();
})
//