一些代码o

vue ：获取数据库连接的代码  

API/user.js

let db = require('../db/index')

exports.get = (req, res) => {
    var sql = 'select * from boss'
    db.query(sql, (err, data) => {
        if(err) {
            return res.send('错误：' + err.message)
        }
        res.send(data)
    })
}

db/index.js

let mysql = require('mysql')

let db = mysql.createPool({
    host: '192.168.67.121',     //数据库IP地址
    user: 'root',          //数据库登录账号
    password: '123456',      //数据库登录密码
    database: 'user'       //要操作的数据库
})

module.exports = db

router.js

let express = require('express')
let router = express.Router()
let user = require('./API/user')

router.get('/user', user.get)

module.exports = router

app.js

let express = require('express')
let app = express()
let cors = require('cors')
let bodyParser = require('body-parser')
let router = require('./router')

app.use(bodyParser.json());  //配置解析，用于解析json和urlencoded格式的数据
app.use(bodyParser.urlencoded({extended: false}));
app.use(cors())              //配置跨域
app.use(router)              //配置路由

app.listen(80, () => {
    console.log('服务器启动成功');
})

显示代码

<template>
  <div id="centerLeft1">
    <div>
      <button @click="all">获取user表数据</button>
    </div>
    <tr>
      <th></th>
    </tr>
    <tr v-for="(item, index) in info"  v-bind:key="index"> 
         
        <td>{{ item.id}}</td>
        <td>{{ item.username}}</td>
        <td>{{ item.userpassword}}</td>
    </tr>
  </div>
</template>

<script>
import axios from "axios"
export default {
  data () {
    return {
      id : '',
      name: '',
      userpassword: ' ',
      info: []
    };
  },
  methods: {
    all() {    //查找info表全部数据
      axios.get('http://127.0.0.1/user').then(res=>{
           console.log(res.data);
          this.info = res.data
      }).catch(err=>{
          console.log("获取数据失败" + err);
      })
    }
  }
}
</script>