小程序连接腾讯云数据库

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

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

// 创建数据库连接池
const pool = mysql.createPool({
  host: 'your_database_host',
  user: 'your_database_user',
  password: 'your_database_password',
  database: 'your_database_name',
  port: your_database_port,
});

app.get('/data', (req, res) => {
  pool.query('SELECT * FROM your_table', (error, results) => {
    if (error) {
      return res.status(500).json({ error: error.message });
    }
    res.json(results);
  });
});

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

Page({
  data: {
    items: []
  },
  onLoad: function () {
    wx.request({
      url: 'http://your_server_url/data',
      success: (res) => {
        this.setData({ items: res.data });
      },
      fail: (err) => {
        console.error('Failed to fetch data:', err);
      }
    });
  }
});