node+express 后台连接MySQL

创建server
全局下载 npm install express-generator@4 -g
进入目录 与src同级 express --view=ejs server
进入server目录 cd server
下载依赖 cnpm install
启动服务器 npm start

---

server/db/index.js

var mysql      = require('mysql');
var conn = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'rootroot',
  database : 'test'
});

conn.connect();

module.exports = conn;

---

routes/index.js

var express = require('express');
var router = express.Router();
var conn = require('../db'); //引入db

/* GET home page. */
router.get('/getBannerData', function(req, res, next) {//首页swiper接口
  conn.query('select * from banner', function (error, results, fields) {
     if (error) throw error;
     res.json({
       results
     })
   });
});
router.get('/getTabData', function(req, res, next) {//首页swiper下方tab接口
  conn.query('select * from tabnav', function (error, results, fields) {
     if (error) throw error;
     res.json({
       results
     })
   });
});

module.exports = router;