首页 > 解决方案 > 如何在 JavaScript 中使用 put 作为路由调用

问题描述

在我的项目中,我正在尝试使用 PUT 编辑 MySQL 数据库中的读数,我认为我必须传递 2 个参数,但我收到一个错误,提示 CANNOT GET /readings/1/1 我在做什么错?,这是我的代码...

router.put('/edit/:user_id/:id', (req, res) => {
  const {
    sugarB = req.body.sugarB,
    carbsB = req.body.carbsB,
    insulinB = req.body.insulinB,
    insulinSB = req.body.insulinSB,
    insulinFB = req.body.insulinFB,
    sugarL = req.body.sugarL,
    carbsL = req.body.carbsL,
    insulinL = req.body.insulinL,
    hbp = req.body.hbp,
    lbp = req.body.lbp,
    hr = req.body.hr,
    sugarD = req.body.sugarD,
    carbsD = req.body.carbsD,
    insulinD = req.body.insulinD
  } = req.query;

  connection.query(
    UPDATE_READINGS_QUERY, + ' WHERE user_id=?,id=?',
    [req.params.user_id], [req.params.id],
    [
      sugarB,
      carbsB,
      insulinB,
      insulinSB,
      insulinFB,
      sugarL,
      carbsL,
      insulinL,
      hbp,
      lbp,
      hr,
      sugarD,
      carbsD,
      insulinD
    ],
    (err, results, fields) => {
      if (err) {
        return res.send(err.message);
      } else {
        res.send('Rows affected: ', results.affetedRows);
      }
    }
  );
});

标签: javascriptput

解决方案


推荐阅读