无法使用Node.js从MySQL表中正确检索数据

正确检索数据"/>

无法使用Node.js从MySQL表中正确检索数据

这是我必须在浏览器中进行的查询：

/line?l1=##&l2=##&l3=##

这是我如何使用JS实现它：

app.get('/line', (req, res) => {
  let sql = `UPDATE car_info SET
  l1 = ${parseInt(req.query.lineone)},
  l2 = ${parseInt(req.query.linetwo)},
  l3 = ${parseInt(req.query.linethree)}
  WHERE name = '${req.cookies.uName.name}'`;
  let lineQuerys = db.query(sql, (result) => {
    res.send(`l1: ${req.query.lineone}, l2: ${req.query.linetwo}, l3: ${req.query.linethree}`);
    })
});

l1，l2和l3与我的MySQL表中定义的相同。在浏览器中键入查询时，我一直得到此输出。

l1: undefined, l2: undefined, l3: undefined

您的网址应为/line?lineone=##&linetwo=##&linethree=##因为您由此获得了参数：req.query.lineone

如果要保留短URL，则查询参数应为：req.query.l1

app.get('/line', (req, res) => {
  let sql = `UPDATE car_info SET
  l1 = ${parseInt(req.query.l1)},
  l2 = ${parseInt(req.query.l2)},
  l3 = ${parseInt(req.query.l3)}
  WHERE name = '${req.cookies.uName.name}'`;
  let lineQuerys = db.query(sql, (result) => {
    res.send(`l1: ${req.query.l1}, l2: ${req.query.l2}, l3: ${req.query.l3}`);
  })
});