Node.js+Express+MongoDB用户模型问题排查及多模型连接疑问

Do You Need to Connect MongoDB in Every Model? #

Absolutely not! Mongoose maintains a global connection pool once you run mongoose.connect() in your main application file (like index.js). All your models will automatically use this single connection—you don’t need to repeat the connection code in every model. In fact, adding mongoose.connect() in multiple models can cause redundant connection attempts, conflicts, or unexpected behavior, which might be contributing to your POST request issue.

Fixing Your users.js Model #

Looking at your code snippet, the first red flag is calling mongoose.connect() directly in the model. Let’s rewrite it properly to follow best practices:

// users.js model
const mongoose = require('mongoose');

// Define your User Schema with appropriate fields (customize these to your needs)
const UserSchema = new mongoose.Schema({
  username: { type: String, required: true, unique: true },
  email: { type: String, required: true, unique: true },
  password: { type: String, required: true },
  createdAt: { type: Date, default: Date.now }
});

// Export the User model to use in your routes
module.exports = mongoose.model('User', UserSchema);

Then, move your MongoDB connection code to your main index.js file (do this once, not in every model):

// index.js
const express = require('express');
const mongoose = require('mongoose');
const app = express();

// Connect to MongoDB (run this once at app startup)
mongoose.connect('mongodb://localhost:27017/your-database-name')
  .then(() => console.log('Successfully connected to MongoDB'))
  .catch(err => console.error('MongoDB connection error:', err));

// Critical middleware: Parse JSON request bodies (required for POST requests!)
app.use(express.json());

// Import and use your routes
const userRoutes = require('./routes/users');
const orderRoutes = require('./routes/orders');

app.use('/api/users', userRoutes);
app.use('/api/orders', orderRoutes);

// Start your server
const PORT = process.env.PORT || 3000;
app.listen(PORT, () => console.log(`Server running on port ${PORT}`));

Troubleshooting the POST Request Not Loading #

If your POST request still isn’t working, check these common issues:

• Missing JSON Parsing Middleware: Ensure you’ve added app.use(express.json()) in index.js—without this, Express can’t read the JSON body of your POST request, so req.body will be undefined.
• Route Setup Mistakes: Verify your users.js route correctly imports the User model and handles the POST request properly. Example route code:

  // routes/users.js
  const express = require('express');
  const router = express.Router();
  const User = require('../models/users'); // Double-check this file path!
  
  router.post('/', async (req, res) => {
    try {
      const newUser = new User(req.body);
      const savedUser = await newUser.save();
      res.status(201).json(savedUser);
    } catch (err) {
      res.status(400).json({ error: err.message });
    }
  });
  
  module.exports = router;
  

• Console Error Checks: Look at your Node.js terminal for error messages—connection failures, schema validation errors, or route misconfigurations will show up here and point you to the problem.
• Test with a Tool: Use Postman, Thunder Client, or curl to send a POST request to your endpoint (e.g., http://localhost:3000/api/users) with a valid JSON body to rule out client-side issues.

内容的提问来源于stack exchange，提问作者Apoorv Srivastava