``` var express = require('express'); var app = express(); var mysql = require('mysql'); var bodyParser = require('body-parser');//解析,用req.body獲取post參數 app.use(bodyParser.json()); app.use(bodyParser.urlencoded({ extended: false })); //設置跨域訪問 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 connection = mysql.createConnection({ host: 'localhost',//主機 user: 'root',//mysql認證的用戶名 password: '123456',//mysql用戶密碼 database: 'test',//數據庫名 port: '3306'//端口號 }); connection.connect(); var questions = [ { data: 213, num: 444, age: 12 } ]; //列表 app.get('/list', function (req, res) { var sql = 'SELECT * FROM hello'; connection.query(sql, function (err, result) { if (err) { console.log('[SELECT ERROR] - ', err.message); return; } res.json(result) }); }); //新增插入 app.get('/list_add', function (req, res) { var addSql = 'INSERT INTO hello(name) VALUES(?)'; var addSqlParams = req.query.name; connection.query(addSql, addSqlParams, function (err, result) { if (err) { console.log('[INSERT ERROR] - ', err.message); return; } res.json({ success: '添加成功' }) }); }); //修改 app.get('/list_edit', function (req, res) { var modSql = 'UPDATE hello SET name = ? WHERE Id = ?'; var modSqlParams = [req.query.edit, req.query.id]; //改 connection.query(modSql, modSqlParams, function (err, result) { if (err) { console.log('[UPDATE ERROR] - ', err.message); return; } res.json({ success: '修改成功' }) }); }); //刪除 app.get('/list_del', function (req, res) { var delSql = "DELETE FROM hello WHERE Id = ?" //刪 var delid = [req.query.id]; connection.query(delSql, delid, function (err, result) { if (err) { console.log('[DELETE ERROR] - ', err.message); return; } res.json({ success: '刪除成功' }) }); // console.log("主頁 POST 請求"); // res.send('Hello POST'); }) //登錄接口 app.get('/user', function (req, res) { res.status(200), res.json(questions) }); //post接口 獲取參數req.body app.post('/demo', function (req, res) { // console.log("主頁 POST 請求"); var delSql = "DELETE FROM hello WHERE Id = ?" var delid = [req.body.id]; // console.log(req.body.id) connection.query(delSql, delid, function (err, result) { if (err) { console.log('[SELECT ERROR] - ', err.message); return; } res.json(result) }); }) //配置服務端口 var server = app.listen(3000, function () { var host = server.address().address; var port = server.address().port; console.log('Example app listening at http://%s:%s', host, port); }) ```