20230221@xingjs@提交官网一张图相关内容接口

xing

2023-02-21 e1e254787f8b9327a4ed47a7559d6b56db13c80b

20230221@xingjs@提交官网一张图相关内容接口

 src/main/java/com/lf/server/controller/show/OneMapController.java

@@ -10,6 +10,7 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;
@@ -174,5 +175,16 @@
        return success(resList);
    }*/

    /**
     * 根据表名查询表字段信息
     * Query table field information according to table name
     */
    @ApiOperation(value = "根据表名查询表字段信息")
    @GetMapping("/selectTableInfo")
    public ResponseMsg<Object> selectTableInfo(@RequestParam("tableName") String tableName) {
        List<String> resList = aMapOfPipelineService.queryTableInfo(tableName);
        return success(resList);
    }


}

 src/main/java/com/lf/server/mapper/show/OneMapMapper.java

@@ -1,6 +1,7 @@
package com.lf.server.mapper.show;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
@@ -81,4 +82,11 @@
     * @return {@link List}<{@link String}>
     */
    public List<String> countProjectType1();

    /**
     * 查询表信息
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> queryTableInfo(@Param("tableName") String tableName);
}

 src/main/java/com/lf/server/service/show/OneMapService.java

@@ -110,4 +110,15 @@
    public List<String> countProjectType1() {
        return aMapOfPipelineMapper.countProjectType1();
    }


    /**
     * 查询表信息
     *
     * @return {@link List}<{@link String}>
     */
    @Override
    public List<String> queryTableInfo(String tableName) {
        return aMapOfPipelineMapper.queryTableInfo(tableName);
    }
}

 src/main/resources/mapper/show/OneMapMapper.xml

@@ -66,6 +66,22 @@
    </select>


    <!--  查询表信息  -->
    <select id="queryTableInfo" resultType="java.util.Map">
        SELECT a.attnum,
               a.attname,
               concat_ws('',t.typname,SUBSTRING(format_type(a.atttypid,a.atttypmod)
                                                FROM '\(.*\)')) AS type,d.description,typnotnull
        FROM pg_class c,pg_attribute a,pg_type t,pg_description d
        WHERE c.relname= '${tableName}'
          AND a.attnum>0
          AND a.attrelid=c.oid
          AND a.atttypid=t.oid
          AND d.objoid=a.attrelid
          AND d.objsubid=a.attnum;
    </select>