vue+mysql+express+node项目搭建

1、建立项目

2、安装mysql依赖包：npm install mysql

3、新建文件夹

4、配置文件：

db.js

module.exports = {
 mysql: {
    host: 'localhost',        // 地址
    user: 'root',             // 账号
    password: 'root',         // 密码
    port: '3306',             // 端口号
    database: 'jewelrysystem' // 数据库的名称
  }
}

---

index.js

// node 后端服务器
const adminApi = require('./api/admin');
const userApi = require('./api/user');
const fs = require('fs');
const path = require('path');
const bodyParser = require('body-parser');
const express = require('express');
const app = express();

app.use(bodyParser.json());
app.use(bodyParser.urlencoded({extended: false}));

// 后端api路由
app.use('/api/admin', adminApi);
app.use('/api/user', userApi);


// 监听端口
app.listen(3000);
console.log('success listen at port:3000......');

---

config--index.js

dev: {
    proxyTable: {
	    '/api': {
			target: 'http://127.0.0.1:3000/api/',
			changeOrigin: true,
			pathRewrite: {
			    '^/api': ''
			}
		}
    },
}

---

admin.js--登录操作

var models = require('../db');
var express = require('express');
var router = express.Router();
var mysql = require('mysql');

// 连接数据库
var conn = mysql.createConnection(models.mysql);

conn.connect();
var jsonWrite = function(res, ret) {
    if(typeof ret === 'undefined') {
        res.json({
            code: '1',
            msg: '操作失败'
        });
    } else {
        res.json(ret);
    }
};


// 登录
router.post('/adminLogin', (req, res) => {
  var sql = 'select * from admin_info where adminName = ? and adminPassword = ? and IsDelete = 1'
  var params = req.body;
  conn.query(sql, [params.adminName, params.adminPassword], function(err, result) {
    if (err) {
      console.log(err);
    }
    if (result) {
      jsonWrite(res, result);
    }
  })
});

// 一定要加
module.exports = router;

---

vue页面

login(){
    this.$http.post('/api/admin/adminLogin', {
        adminName: this.adminName,
        adminPassword: this.password,
    },{}).then((res) => {
        console.log(res);
    }).catch(err => {
        console.log('登录失败', err)
    })
}

---

在测试前要打开数据库，在server文件夹中启动cmd：node index