数据库增删改查的bs框架

// 示例代码（Node.js + Express）
const express = require('express');
const mysql = require('mysql');

const app = express();
const db = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydb'
});

db.connect((err) => {
  if (err) throw err;
  console.log('Database connected!');
});

app.get('/users', (req, res) => {
  db.query('SELECT * FROM users', (err, result) => {
    if (err) throw err;
    res.send(result);
  });
});

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

// 示例代码（Node.js + Express）
app.get('/user/:id', (req, res) => {
  const userId = req.params.id;
  db.query('SELECT * FROM users WHERE id = ?', [userId], (err, result) => {
    if (err) throw err;
    res.send(result);
  });
});

// 示例代码（Node.js + Express）
app.get('/users', (req, res) => {
  const page = req.query.page || 1;
  const limit = req.query.limit || 10;
  const offset = (page - 1) * limit;

  db.query('SELECT * FROM users LIMIT ? OFFSET ?', [limit, offset], (err, result) => {
    if (err) throw err;
    res.send(result);
  });
});