vue连接mysql数据库教程

npm install --save axios
npm install --save mysql

import axios from 'axios';
import mysql from 'mysql';

const connection = mysql.createConnection({
  host: 'your_mysql_host',
  user: 'your_mysql_username',
  password: 'your_mysql_password',
  database: 'your_database_name'
});

// 在需要的时候发送查询请求
axios.get('/api/data')
  .then(response => {
    // 处理响应数据
    console.log(response.data);
  })
  .catch(error => {
    // 处理错误
    console.log(error);
  });

const express = require('express');
const mysql = require('mysql');

const app = express();

const connection = mysql.createConnection({
  host: 'your_mysql_host',
  user: 'your_mysql_username',
  password: 'your_mysql_password',
  database: 'your_database_name'
});

app.get('/api/data', (req, res) => {
  // 执行SQL查询
  connection.query('SELECT * FROM your_table', (error, results) => {
    if (error) {
      // 处理错误
      console.log(error);
      res.status(500).send('Internal Server Error');
    } else {
      // 返回查询结果
      res.json(results);
    }
  });
});

app.listen(3000, () => {
  console.log('Server is running on port 3000');
});