daocha_serve/Source/server/UserManageServer/sqlUtil.js

function listTable(req) {
  let tname = req.body.tbName;
  // console.log(tname);
  let sql = `select * from ${tname} order by id asc`;
  return sql;
}

function listTableDESC(req) {
  let tname = req.body.tbName;
  // console.log(tname);
  let sql = `select * from ${tname} order by id DESC`;
  return sql;
}

function lookFor(req) {
  let tname = req.body.tbName;
  let searchmsg = req.body.searchmsg;
  let sql = `select * from  ${tname}  where name like '%${searchmsg}%'`;

  return sql;
}
function lookFordaily(req) {
  let tname = req.body.tbName;
  let searchmsg = req.body.searchmsg;
  let sql = `select * from  ${tname}  where username like '%${searchmsg}%'`;

  return sql;
}
function checkName(req) {
  let tname = req.body.tbName;
  let checkName = req.body.checkName;
  let sql = `select * from  ${tname}  where name = '${checkName}'`;

  return sql;
}

function addList(req) {
  let tname = req.body.tbName;
  let name = req.body.name;
  let password = req.body.password;
  let type = req.body.type;
  let power = req.body.power;
  let sql = `insert into ${tname} ("name","password","type","power") values ('${name}','${password}','${type}','${power}') `;
  return sql;
}

function edit(req) {
  let tname = req.body.tbName;
  let id = req.body.id;
  let name = req.body.name;
  let password = req.body.password;
  let type = req.body.type;
  let power = req.body.power;
  let sql = `update ${tname} set name = '${name}',password = '${password}',type='${type}',  power = '${power}' where id = ${id}`;
  // console.log(sql);
  return sql;
}

function remove(req) {
  let tname = req.body.tbName;
  let id = req.body.id;
  let sql = `delete from ${tname} where id='${id}' `;
  // console.log(sql);
  return sql;
}

module.exports = {
  listTable,
  listTableDESC,
  addList,
  lookFor,
  checkName,
  remove,
  edit,
  lookFordaily
};