微信小程序怎么连接mysql数据库

// 初始化云开发环境
wx.cloud.init({
  env: 'your-env-id' // 替换为你的云开发环境ID
});

// 创建集合引用
const db = wx.cloud.database();
const _ = db.command;

// 插入数据
db.collection('your-collection-name').add({
  data: {
    name: 'example',
    age: 20
  }
}).then(res => {
  console.log('插入成功', res);
}).catch(err => {
  console.error('插入失败', err);
});

// Node.js 示例
const express = require('express');
const mysql = require('mysql');
const app = express();

const connection = mysql.createConnection({
  host: 'your-mysql-host',
  user: 'your-username',
  password: 'your-password',
  database: 'your-database'
});

connection.connect();

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

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

wx.request({
  url: 'http://your-backend-server/api/data',
  method: 'GET',
  success: function(res) {
    console.log('获取数据成功', res.data);
  },
  fail: function(err) {
    console.error('获取数据失败', err);
  }
});

const db = wx.cloud.database();

const db = wx.cloud.database({
  env: 'your-env-id'
});

const todos = db.collection('todos');
todos.get().then(res => {
  console.log(res.data);
});

// 插入数据
todos.add({
  data: {
    title: '任务标题',
    completed: false
  }
}).then(res => {
  console.log(res);
});

// 查询数据
todos.get().then(res => {
  console.log(res.data);
});

// 更新数据
todos.doc('doc-id').update({
  data: {
    completed: true
  }
}).then(res => {
  console.log(res);
});

// 删除数据
todos.doc('doc-id').remove().then(res => {
  console.log(res);
});