daocha_serve/Source/server/RouteroamServer/sqlUtil.js

// 路径漫游专属添加 勿用
function addroute(req) {
  let tname = req.body.tbname;
  let name = req.body.name;
  let time = req.body.time;
  let pointarr = req.body.pointArr;
  let sql = `INSERT INTO ${tname} (name,time,pointarr) VALUES ('${name}','${time}','${pointarr}');`;
  return sql;
}
// 路径漫游专属删除 勿用
function removeroute(req) {
  let tname = req.body.tbname;
  let id = req.body.id;
  let sql = `DELETE FROM ${tname} WHERE id= '${id}';`;

  return sql;
}
// 路径漫游专属修改 勿用
function modifyroute(req) {
  let tname = req.body.tbname;
  let id = req.body.id;
  let name = req.body.name;
  let sql = `UPDATE  ${tname} SET name ='${name}' WHERE id= '${id}';`;

  return sql;
}
// 路径漫游专属查询 勿用
function selectroute(req) {
  let tname = req.body.tbname;

  let name = req.body.name;

  let sql = `SELECT name FROM ${tname}  WHERE name = '${name}';`;

  return sql;
}

// 通用 通用 通用 通用 通用 通用 通用 通用 通用 通用 通用 通用 通用
// getALLlist
function listTable(req) {
  let tname = req.body.tbname;
  let sql = `select * from ${tname} order by id asc`;
  return sql;
}
module.exports = {
  addroute,
  removeroute,
  modifyroute,
  selectroute,
  listTable,
};