daocha_serve/Source/server/jiance-dataserver/util/sqlUtil.js

// 查询表内所有数据
function listTableByName(req) {
    let tbName = req.body.tbName
    let sql = `select * from ${tbName} `
    console.log(sql);
    return sql
}
// 新增某些数据
function addSome(req) {
    let tbName = req.body.tbName
    let sql = `INSERT INTO ${tbName} id,xianming VALUES (?,?) `
    console.log(sql);
    return sql
}
// 删除某些记录
function deleteSome(req) {
    let tbName = req.body.tbName
    let sql = `delete from ${tbName} where <condition> `
    console.log(sql);
    return sql
}
// 更新某些记录
function updateSome(req) {
    let tbName = req.body.tbName
    let sql = `update ${tbName} set <id=?>  where <condition> `
    console.log(sql);
    return sql
}


module.exports = {
    listTableByName
}