小程序连接mysql

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

const app = express();
const port = 3000;

// 创建MySQL连接
const connection = mysql.createConnection({
  host: 'your_mysql_host',
  user: 'your_mysql_user',
  password: 'your_mysql_password',
  database: 'your_mysql_database',
  charset: 'utf8mb4'
});

connection.connect();

app.get('/data', (req, res) => {
  connection.query('SELECT * FROM your_table', (error, results) => {
    if (error) throw error;
    res.json(results);
  });
});

app.listen(port, () => {
  console.log(`Server running at http://localhost:${port}/`);
});

Page({
  data: {
    items: []
  },
  onLoad: function () {
    wx.request({
      url: 'http://localhost:3000/data',
      success: (res) => {
        this.setData({
          items: res.data
        });
      }
    });
  }
});