调用其中一个'IN‘变量是来自Express API的列表的存储过程

DELIMITER //

CREATE PROCEDURE GetUserDetails(IN userIds VARCHAR(255))
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE id INT;
    DECLARE result VARCHAR(255) DEFAULT '';

    WHILE i <= LENGTH(userIds) DO
        SET id = SUBSTRING_INDEX(SUBSTRING_INDEX(userIds, ',', i), ',', -1);
        SET result = CONCAT(result, (SELECT CONCAT('ID: ', id, ', Name: ', name) FROM users WHERE id = id), '; ');
        SET i = i + 1;
    END WHILE;

    SELECT result;
END //

DELIMITER ;

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

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

const connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'password',
    database: 'testdb'
});

connection.connect();

app.get('/users', (req, res) => {
    const userIds = req.query.userIds; // 假设传递的参数是 '1,2,3'
    const query = `CALL GetUserDetails('${userIds}')`;

    connection.query(query, (error, results) => {
        if (error) throw error;
        res.send(results[0][0]);
    });
});

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