~~~
const express = require("express");
const server = express();
const mysql = require("mysql");
var db = mysql.createPool({
host: "localhost",
user: "root",
password: "123456",
database: "blog"
});
server.listen(8080);
//設置允許跨域請求
server.all("*", function(req, res, next) {
res.header("Access-Control-Allow-Origin", "*"); //訪問控制允許來源：所有
res.header(
"Access-Control-Allow-Headers",
"Origin, X-Requested-With, Content-Type, Accept"
); //訪問控制允許報頭 X-Requested-With: xhr請求
res.header("Access-Control-Allow-Metheds", "PUT, POST, GET, DELETE, OPTIONS"); //訪問控制允許方法
res.header("X-Powered-By", "nodejs"); //自定義頭信息，表示服務端用nodejs
res.header("Content-Type", "application/json;charset=utf-8");
next();
});
server.get("/", function(req, res) {
db.query("SELECT * FROM banner_table", (err, data) => {
if (err) {
res
.status(500)
.send("database erro")
.end();
} else {
res.json(data);
}
});
});
~~~
