🐵node开发接口， 环境及配置—demo

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);
})