daocha_serve/Source/server/gltfdataServer/sqlUtil.js

// 路径漫游专属添加 勿用
function load(req) {
  let tablename = req.body.tablename;
  let start = req.body.start;
  let num = req.body.num;
  let sql = `select * from ${tablename} order by id asc limit ${num} offset ${start};`;
  console.log(sql);
  return sql;
}

function savepos(req) {
  let tablename = req.body.tablename;
  let name = req.body.name;
  let posvalue = req.body.posvalue;
  let sql = `UPDATE  ${tablename} SET pos='${posvalue}' WHERE name = '${name}'  ;`;

  console.log(sql);
  return sql;
}

module.exports = {
  load,
  savepos,
};