1234567891011121314151617181920212223242526272829303132 |
- const express = require("express");
- const router = express.Router();
- const pgClient = require("../../core/pgClient/pgClient.js");
- /* 1.获取所有数据 */
- router.post("/getList", function (req, res) {
- let tableName = req.body.tableName
- //直接拼接
- let sql = `select * from ${tableName}`;
- /* 执行-并把值返回前端 */
- pgClient.query(sql).then(data => {
- res.send(data.rows)
- });
- });
- /* 2.添加数据 */
- router.post("/addData", function (req, res) {
- let tableName = req.body.tableName;
- let name = req.body.name;
- let password = req.body.password;
- //直接拼接
- let sql = `insert into ${tableName} ("name","password") values ('${name}','${password}')`;
- console.log(sql);
- /* 执行-并把值返回前端 */
- pgClient.query(sql).then(data => {
- res.send(data)
- });
- });
- module.exports = router;
|