From 8e7b698e9ccb2a2bb6b3f6d5df0e5406c509b864 Mon Sep 17 00:00:00 2001 From: Surpriseplus <845948745@qq.com> Date: 星期一, 26 九月 2022 15:38:44 +0800 Subject: [PATCH] 查询表名,中文名字典管理 --- src/main/java/com/lf/server/controller/data/DictController.java | 5 +++++ src/main/java/com/lf/server/mapper/data/DictMapper.java | 8 ++++++++ src/main/java/com/lf/server/controller/data/DirController.java | 2 ++ src/main/resources/mapper/data/DictMapper.xml | 6 ++++++ src/main/java/com/lf/server/service/data/DictService.java | 7 +++++++ 5 files changed, 28 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/lf/server/controller/data/DictController.java b/src/main/java/com/lf/server/controller/data/DictController.java index d930425..703d766 100644 --- a/src/main/java/com/lf/server/controller/data/DictController.java +++ b/src/main/java/com/lf/server/controller/data/DictController.java @@ -64,4 +64,9 @@ return dictService.selectDictAll(); } + + @GetMapping(value = "/selectDictTab") + public List<DictEntity> selectDictTab() { + return dictService.selectDictTab(); + } } diff --git a/src/main/java/com/lf/server/controller/data/DirController.java b/src/main/java/com/lf/server/controller/data/DirController.java index 7c4bca8..d66fab8 100644 --- a/src/main/java/com/lf/server/controller/data/DirController.java +++ b/src/main/java/com/lf/server/controller/data/DirController.java @@ -71,4 +71,6 @@ return dirService.selectDirAll(); } + + } diff --git a/src/main/java/com/lf/server/mapper/data/DictMapper.java b/src/main/java/com/lf/server/mapper/data/DictMapper.java index d2d8eb3..57655cf 100644 --- a/src/main/java/com/lf/server/mapper/data/DictMapper.java +++ b/src/main/java/com/lf/server/mapper/data/DictMapper.java @@ -61,4 +61,12 @@ * @return */ public List<DictEntity> selectDictAll(); + + /** + * 鏌ヨ琛ㄦ牸涓枃鍚� + * @return + */ + public List<DictEntity> selectDictTab(); + + } diff --git a/src/main/java/com/lf/server/service/data/DictService.java b/src/main/java/com/lf/server/service/data/DictService.java index 492c4a4..b443d4d 100644 --- a/src/main/java/com/lf/server/service/data/DictService.java +++ b/src/main/java/com/lf/server/service/data/DictService.java @@ -53,4 +53,11 @@ public List<DictEntity> selectDictAll() { return dictMapper.selectDictAll(); } + + @Override + public List<DictEntity> selectDictTab() { + return dictMapper.selectDictTab(); + } + + } \ No newline at end of file diff --git a/src/main/resources/mapper/data/DictMapper.xml b/src/main/resources/mapper/data/DictMapper.xml index d2abeee..102a0c3 100644 --- a/src/main/resources/mapper/data/DictMapper.xml +++ b/src/main/resources/mapper/data/DictMapper.xml @@ -10,6 +10,11 @@ <result property="updateUser" column="update_user"></result> <result property="updateTime" column="update_time"></result> </resultMap> + + <select id="selectDictTab" resultMap="resultMap" resultType="com.lf.server.entity.data.DictEntity"> + select Distinct tab,tab_desc from lf.sys_dict; + </select> + <select id="selectDictAll" resultMap="resultMap" resultType="com.lf.server.entity.data.DictEntity"> select * from lf.sys_dict </select> @@ -52,4 +57,5 @@ update lf.sys_dict set ns=#{ns},tab=#{tab},tab_desc=#{tabDesc},field=#{field},alias=#{alias},type=#{type}, len=#{len},precision=#{precision}, order_num=#{orderNum},update_user=#{updateUser},update_time=now(),bak=#{bak} where id=#{id} </update> + </mapper> \ No newline at end of file -- Gitblit v1.9.3