CRUD应用程序Node.js更新表单

Question

表单会更新，但只更新数据库中的第一个条目。它不会更新指定id的条目。

这是我的模式：

var mongoose = require('mongoose');
mongoose.connect('mongodb://localhost/myDB');
var dbSchema = mongoose.Schema({
objID : String,
productName : String,
price : String,
quantity: Number
});
var Document = mongoose.model('Document', dbSchema);

app.post Document.update没有在指定的id上创建文档。当信息通过我的表单发布时，更新发生在第一个数据库条目上。

app.get('/update', function(req, res,) {
res.render('update', { title: 'Express' });
});
app.post('/updated/',
function(req, res) {
Document.update({
objID : req.body.id_name,
productName : req.body.product_name,
price : req.body.price_name,
quantity: req.body.quantity_name
}, function(err, obj) {
if (!err) {
res.redirect('/update');}
else {
res.send(err)
}
});
});

我也试过这两种方法。

app.post('/updated',
function(req, res) {
Document.findOneAndUpdate({objID: req.params.objID}, req.body, {new: true},
(err, obj) => {
if (!err) {
res.redirect('/update');
}
else {
res.send(err)
}
});
});

app.post('/updated/',
function (req,res) {
Document.findByIdAndUpdate(req.params.objID, {$set: req.body}, function (err, product) {
if (err) return next(err);
res.send('Product udpated.');
});
});

如果有人能最后一次帮助我，我将非常感谢。

这是我的update.pug文件。

doctype html
head
meta(charset='utf-8')
meta(name='viewport' content='width=device-width, initial-scale=1.0')
title Superb Grocery IS
link(rel='stylesheet' type="text/css" href='stylesheets/style.css')
script(type='text/javascript' src='javascripts/validate.js')
.main-nav
ul.nav
li.name Superb Grocery IS
li
a(href='index') Home
li
a(href='listing') Listing
li
a(href='entry') Add
li
a(href='update') Update
li
a(href='delete') Delete
header
#wrapperr
h1(align='center' style='color:blueviolet') Update Products
form(name='form3' action='/updated' method='post' style='margin-top: 
20px')
input(name='_method', value='PUT', type='hidden')
table#table2(align='center' border='3')
tr
td
label(for='entry_id') ID:
td
input#entry_id(type='text' name='id_name' pattern='^[a-zA-Z][a-zA-Z0-9-_.]{5}$' placeholder='RWS35O' onblur='alphanumeric(this)' required='')
tr
td
label(for='entry_product') Product:
td
input#entry_product(type='text' name='product_name' onblur='letpattern(this)' required='')
tr
td
label(for='entry_price') Price:
td
input#entry_price(type='text' name='price_name' placeholder='9999 OR 9999.99' onblur='price(this)' required='')
tr
td
label(for='entry_quantity') Quantity:
td
input#entry_quantity(type='text' name='quantity_name' placeholder='9999' pattern='[0-9]' onblur='numeric(this)' required='')
tr
td(colspan='2' align='center')
button.reset(type='reset' value='Reset') Reset
button.update_btn(type='submit' value='Submit') Update

Answer 1

在开始编码之前，您必须阅读mongoose官方文档，http://mongoosejs.com/docs/api.html#model_Model.update。update函数需要两个参数：condition和obj，您没有condition，因此您的系统不知道必须更新什么记录。我看到你想更新objID(？？？：|：/(，在你的情况下，你必须保留旧的objID来更新你想要更新的对象。

Document.update({objID: req.body.old_id_name}, {
objID : req.body.id_name,
productName : req.body.product_name,
price : req.body.price_name,
quantity: req.body.quantity_name
}, function(err, obj) {
if (!err) {
res.redirect('/update');}
else {
res.send(err)
}
});

Answer 2

const User = require('../models/user')
const jwt = require('../helpers/jwt')
module.exports = class {
static register(req, res, next) {
let user = {
name: req.body.name,
email: req.body.email,
password: req.body.password
}
User.create(user)
.then(result => {
res.status(201).json(result)
})
.catch(err => {
next(err)
})
}
static login(req, res, next) {
let user = {
email: req.body.email,
password: req.body.password
}
// console.log(user);
User.findOne(user)
.then(userLogin => {
let token = jwt.generateToken({
email: userLogin.email,
id: userLogin._id
})
res.status(200).json({ token: token })
})
.catch(err => {
;(err.statusCode = 400), (err.message = 'Email or Password is invalid')
next(err)
})
}
static getUser(req, res, next) {
try {
let user = {
_id: req.body.user._id,
name: req.body.user.name,
email: req.body.user.email,
imageUrl: req.body.user.imageUrl,
role: req.body.user.role,
balance: req.body.user.balance
}
res.status(200).json(user)
} catch (err) {
next(err)
}
}
static logout(req, res, next) {
res.status(200).json({
message: 'Successfully logout',
accountType: req.body.user.accountType
})
}
}
==== router index ====
const express = require('express')
const router = express.Router()
// router.get('/', )
router.use('/users', require('./users'))
router.use('/products', require('./product'))
router.use('/transactions', require('./transaction'))
module.exports = router
==== router user ====
const express = require('express')
const router = express.Router()
const User = require('../controllers/userController')
const auth = require('../middlewares/auth')
/* GET users listing. */
router.post('/register', User.register)
router.post('/login', User.login)
router.get('/', auth.authentication, User.getUser)
router.post('/logout', auth.authentication, User.logout)
module.exports = router
===env===
jwt_key, port, db_uri