Vue + Node 全栈开发

// server/index.js
// 引入编写好的api
const api = require('./api')
// 引入文件模块
const fs = require('fs')
// 引入处理路径的模块
const path = require('path')
// 引入处理post数据的模块
const bodyParser = require('body-parser')
// 引入Express
const express = require('express')
const app = express()

app.use(bodyParser.json())
app.use(bodyParser.urlencoded({extended: false}))
app.use(api)
// 访问静态资源文件 这里是访问所有dist目录下的静态资源文件
app.use(express.static(path.resolve(__dirname, '../dist')))
// 因为是单页应用 所有请求都走/dist/index.html
app.get('*', function (req, res) {
  const html = fs.readFileSync(path.resolve(__dirname, '../dist/index.html'), 'utf-8')
  res.send(html)
})

var port = 8081
var uri = 'http://localhost:' + port

// 监听端口
app.listen(port)
console.log('\n> Starting server...')
console.log('> Listening at ' + uri + '\n')

// server/db.js
// MySQL数据库连接配置
module.exports = {
  mysql: {
    host: '127.0.0.1',
    user: 'root',
    password: 'zouyong',
    database: 'my_db',
    port: 3306
  }
}

// server/api.js
var mysql = require('mysql')
var express = require('express')
var router = express.Router()

var db = require('./db')
// var $sql = require('./userSqlMapping');

// util
var extend = function (target, source, flag) {
  for (var key in source) {
    if (source.hasOwnProperty(key)) {
      flag ? (target[key] = source[key]) : (target[key] === void 0 && (target[key] = source[key]))
    }
  }
  return target
}

// 使用连接池，提升性能
var pool = mysql.createPool(extend({}, db.mysql))

// 向前台返回JSON方法的简单封装
var jsonWrite = function (res, ret) {
  if (typeof ret === 'undefined') {
    res.json({
      code: '1',
      msg: '操作失败'
    })
  } else {
    res.json(ret)
  }
}

// 查询所有用户
router.get('/api/queryAll', function (req, res, next) {
  pool.getConnection(function (err, connection) {
    if (err) return err
    connection.query('SELECT * FROM user', function (err, result) {
      if (err) return err
      jsonWrite(res, result)
      connection.release()
    })
  })
})

module.exports = router

...
 proxyTable: {
        '/api': {
        target: 'http://localhost:8081/api/',
        changeOrigin: true,
        pathRewrite: {
          '^/api': ''
        }
      }
    }
...