如何使用Express.js和MySQL为每首歌曲创建具有唯一网址的单独html链接？

module.exports = {
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database',
};

const express = require('express');
const mysql = require('mysql');
const config = require('./config');

const router = express.Router();

// 创建数据库连接
const connection = mysql.createConnection(config);

// 连接数据库
connection.connect((err) => {
  if (err) {
    console.error('Error connecting to database:', err);
  } else {
    console.log('Connected to database');
  }
});

// 获取所有歌曲
router.get('/songs', (req, res) => {
  const query = 'SELECT * FROM songs';

  connection.query(query, (err, results) => {
    if (err) {
      console.error('Error querying database:', err);
      res.status(500).json({ error: 'Internal server error' });
    } else {
      res.json(results);
    }
  });
});

// 获取单个歌曲
router.get('/songs/:id', (req, res) => {
  const { id } = req.params;
  const query = 'SELECT * FROM songs WHERE id = ?';

  connection.query(query, [id], (err, results) => {
    if (err) {
      console.error('Error querying database:', err);
      res.status(500).json({ error: 'Internal server error' });
    } else if (results.length === 0) {
      res.status(404).json({ error: 'Song not found' });
    } else {
      res.json(results[0]);
    }
  });
});

// 创建新歌曲
router.post('/songs', (req, res) => {
  const { title, artist, url } = req.body;
  const query = 'INSERT INTO songs (title, artist, url) VALUES (?, ?, ?)';

  connection.query(query, [title, artist, url], (err, results) => {
    if (err) {
      console.error('Error querying database:', err);
      res.status(500).json({ error: 'Internal server error' });
    } else {
      res.json({ id: results.insertId });
    }
  });
});

module.exports = router;

const express = require('express');
const songsRouter = require('./songs');

const app = express();

// 其他中间件和路由...

// 挂载songs路由
app.use('/api', songsRouter);

// 启动服务器
app.listen(3000, () => {
  console.log('Server is running on port 3000');
});