var express = require('express'); //引入express模塊
var mysql = require('mysql'); //引入mysql模塊
var fs = require('fs');
var URL = require('url');
var app = express(); //創建express的實體
var bodyParser = require('body-parser');
//const bodyParser = require('body-parser');
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
var connection = mysql.createConnection({ //創建mysql實體
host: '192.168.48.128',
port: '3306',
user: 'root',
password: 'password',
database: 'mydb'
});
connection.connect();
// 下面是解決跨域請求問題
app.all('*', function (req, res, next) {
res.header("Access-Control-Allow-Origin", "*");
res.header("Access-Control-Allow-Headers", "X-Requested-With");
res.header("Access-Control-Allow-Methods", "PUT,POST,GET,DELETE,OPTIONS");
res.header("X-Powered-By", ' 3.2.1');
res.header("Content-Type", "application/json;charset=utf-8");
next();
});
var sql = 'SELECT * FROM goods';
var text=" ";
connection.query(sql, function (err, result) {
if (err) {
console.log('[SELECT ERROR]:', err.message);
}
text = JSON.stringify(result);
console.log(result); //資料庫查詢結果回傳到result中
});
//connection.destroy();
var router = express.Router();
router.get('/', function (req, res,next ) {
res.send('welcome');
//res.sendStatus(200);
});
var temp = " ";
router.get('/read', function (req, res, next) {
var params = URL.parse(req.url, true).query;
//connection.connect();
connection.query('select * from goods where id=' + params.id +';', function (err, result,next ) {
if (err) {
console.log('[SELECT ERROR]:', err.message);
} temp = JSON.stringify(result);
console.log(temp); //資料庫查詢結果回傳到result中
});
res.send(temp);
//res.sendStatus(200);
//connection.destroy();
});
router.get('/h', function (req, res) {
res.send("h");
});
router.get('/G', function (req, res) {
res.send("G");
});
app.use('/', router);
//connection.end();
app.listen(1337, function () {
//監聽3000埠
console.log('Server running at 1337 port');
});
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/268354.html
標籤：JavaScript
上一篇：求好心人幫忙，正則運算式
下一篇：ajax 檔案上傳