sanwei_server/Source/module/DingDei/sql.js

/* sqlHelper */

//查询表qinshui_xiang数据 只显示name和geom字段，st_asgeojson(geom)可将geom字段转为geojson格式存在st_asgeojson字段中
function qureyAll(req) {
  let sql = `select name,st_asgeojson(geom) from public.qinshui_xiang where name = '${req.query.xiang}'  `

  return sql
}

module.exports = {
  qureyAll
}