Node.js拆分Express路由文件报错：Route.post()需回调函数却获undefined

后端开发新手，之前把所有GET/POST接口写在同一个文件里实现Node.js与MySQL的连接，拆分到多个文件后出现如下错误：

C:\Users\Administrator\Documents\NodeJs\node_modules\express\lib\router\route.js:211
        throw new Error(msg);
        ^

Error: Route.post() requires a callback function but got a [object Undefined]
    at Route.<computed> [as post] (C:\Users\Administrator\Documents\NodeJs\node_modules\express\lib\router\route.js:211:15)
    at app.<computed> [as post] (C:\Users\Administrator\Documents\NodeJs\node_modules\express\lib\application.js:499:19)
    at Object.<anonymous> (C:\Users\Administrator\Documents\NodeJs\register_user.js:18:5)
    at Module._compile (node:internal/modules/cjs/loader:1254:14)
    at Module._extensions..js (node:internal/modules/cjs/loader:1308:10)
    at Module.load (node:internal/modules/cjs/loader:1117:32)
    at Module._load (node:internal/modules/cjs/loader:958:12)
    at Module.require (node:internal/modules/cjs/loader:1141:19)
    at require (node:internal/modules/cjs/helpers:110:18)
    at Object.<anonymous> (C:\Users\Administrator\Documents\NodeJs\server.js:7:22)

现有代码 #

server.js（数据库连接） #

const express = require('express');
const app = express();
var parseUrl = require('body-parser');
let encodeUrl = parseUrl.urlencoded({extended: false});
const port = 3000;
const mysql = require('mysql2');
const registerUser = require('./register_user');
const con = mysql.createConnection({
    host:'localhost',
    user:'root',
    password:'',
    database:'register'
}
);

con.connect((err)=>{
    if (err) throw err;
    console.log("Database Connected");
});

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

module.exports = { con, encodeUrl};

register_user.js #

const express = require('express');
const app = express();
const connectionImports = require("./server");
const con = connectionImports.con;
const encodeUrl = connectionImports.encodeUrl

app.get('/',(req,res)=>{
    res.sendFile(__dirname+'/register.html');
});

app.get('/register',(req,res)=>{
    // res.send(req.body);
    res.send("HElllo");
    console.log(res.body.firstName)
    console.log(res.body.password)
    console.log(res.body.email)
});
app.post('/register',encodeUrl,(req,res)=>{
    const firstname = req.body.firstName;
    const password = req.body.password;
    const email = req.body.email;
    res.send(`${firstname} ${password} ${email}`);
    const query = `Insert INTO register_student VALUES ('${email}','${password}','${firstname}')`;
    con.query(query,(err,result)=>{
        if(err) throw err;
        console.log(result);
    })});

尝试过添加路由器及不同方法修复，甚至单独运行register_user.js，但都无效，请求解决错误并提供代码优化建议。

错误原因 #

1. 循环依赖：server.js 引入了 register_user.js，而 register_user.js 又反向引入 server.js，导致模块加载时 encodeUrl 还未完成赋值，传递给 app.post 的参数为 undefined，触发报错。
2. 重复创建Express实例：两个文件各自初始化了const app = express()，导致路由没有挂载到实际启动的服务实例上，即使解决依赖问题，路由也无法生效。

修复后的代码 #

1. 重构server.js #

const express = require('express');
const app = express();
const parseUrl = require('body-parser');
const port = 3000;
const mysql = require('mysql2');

// 初始化数据库连接
const con = mysql.createConnection({
    host:'localhost',
    user:'root',
    password:'',
    database:'register'
});

con.connect((err)=>{
    if (err) throw err;
    console.log("Database Connected");
});

// 全局注册body-parser中间件，无需在路由中单独传递
app.use(parseUrl.urlencoded({extended: false}));

// 先导出数据库连接，再引入路由模块避免循环依赖
module.exports = { con };

// 引入并挂载路由
const registerRoutes = require('./register_user');
app.use(registerRoutes);

// 启动服务
app.listen(port,()=>{
    console.log(`Server running on port ${port}`);
});

2. 重构register_user.js（使用Express Router） #

const express = require('express');
// 创建路由实例，而非新的Express应用
const router = express.Router();
const { con } = require("./server");

router.get('/',(req,res)=>{
    res.sendFile(__dirname+'/register.html');
});

router.get('/register',(req,res)=>{
    res.send("Hello");
    // GET请求无req.body，若需获取参数请使用req.query，此处注释无效代码
    // console.log(req.body.firstName)
    // console.log(req.body.password)
    // console.log(req.body.email)
});

router.post('/register',(req,res)=>{
    const firstname = req.body.firstName;
    const password = req.body.password;
    const email = req.body.email;
    res.send(`${firstname} ${password} ${email}`);
    
    // 使用参数化查询防止SQL注入
    const query = `INSERT INTO register_student VALUES (?, ?, ?)`;
    con.query(query, [email, password, firstname], (err,result)=>{
        if(err) throw err;
        console.log(result);
    });
});

// 导出路由实例供主服务挂载
module.exports = router;

代码优化建议 #

• 拆分数据库连接模块：将数据库连接逻辑抽离为单独的db.js，彻底避免循环依赖，同时方便其他模块复用连接。
• 强制使用参数化查询：永远不要直接拼接SQL语句，参数化查询是防止SQL注入的核心手段。
• 完善错误处理：生产环境禁止直接throw err，应返回标准化错误响应并记录日志，避免服务崩溃。
• 使用数据库连接池：mysql2的连接池比单连接更稳定高效，适合高并发场景，示例：

// db.js
const mysql = require('mysql2/promise');
const pool = mysql.createPool({
  host:'localhost',
  user:'root',
  password:'',
  database:'register',
  connectionLimit: 10,
  queueLimit: 0
});

module.exports = pool;

• 分层架构：将路由、业务逻辑、数据库操作拆分为不同层级，路由仅处理请求响应，业务逻辑放在服务层，数据库操作放在数据访问层，提升代码可维护性。

内容的提问来源于stack exchange，提问作者Aaryan Jha