From 642ebd764c51c99b4ab1c3cf8bccd333ee79eed3 Mon Sep 17 00:00:00 2001
From: Surpriseplus <845948745@qq.com>
Date: 星期五, 23 九月 2022 16:32:31 +0800
Subject: [PATCH] 111
---
data/db.sql | 71 ++++++
src/main/java/com/lf/server/entity/organization/DepEntity.java | 213 +++++++++++++++++++
data/dep.xls.LOCAL.xls | 0
src/main/java/com/lf/server/service/oraganization/DepService.java | 48 ++++
src/main/resources/mapper/oraganization/DepMapper.xml | 16 +
data/dep.xls.REMOTE.xls | 0
data/menu.csv | 149 +++++++++++++
src/main/java/com/lf/server/LfApplication.java | 2
data/dep.xls.BASE.xls | 0
src/main/java/com/lf/server/mapper/oraganization/DepMapper.java | 50 ++++
src/main/java/com/lf/server/controller/organization/DepController.java | 52 ++++
src/main/resources/application.yml | 4
12 files changed, 598 insertions(+), 7 deletions(-)
diff --git a/data/db.sql b/data/db.sql
index 339c06e..6c1e417 100644
--- a/data/db.sql
+++ b/data/db.sql
@@ -37,6 +37,8 @@
comment on column lf.sys_menu.update_time is '鏇存柊鏃堕棿';
comment on column lf.sys_menu.bak is '澶囨敞';
+--update lf.sys_menu set bak=null,create_time=now() where 1=1;
+
select * from lf.sys_menu;
----------------------------------------------------------------------------------------------------- 缁勭粐鏈烘瀯琛�
-- DROP TABLE IF EXISTS lf.sys_dep;
@@ -44,7 +46,7 @@
id serial primary key,
pid integer,
name varchar(150),
- short varchar(50),
+ sname varchar(50),
code varchar(50),
uncode varchar(50),
addr varchar(300),
@@ -66,7 +68,7 @@
comment on column lf.sys_dep.id is '涓婚敭';
comment on column lf.sys_dep.pid is '鐖禝D,鏍硅妭鐐�-0';
comment on column lf.sys_dep.name is '鍚嶇О';
-comment on column lf.sys_dep.short is '绠�绉�';
+comment on column lf.sys_dep.sname is '绠�绉�';
comment on column lf.sys_dep.code is '缂栫爜';
comment on column lf.sys_dep.uncode is '鏈烘瀯浠ｇ爜';
comment on column lf.sys_dep.addr is '鍦板潃';
@@ -83,13 +85,72 @@
comment on column lf.sys_dep.update_time is '鏇存柊鏃堕棿';
comment on column lf.sys_dep.bak is '澶囨敞';
-update lf.sys_dep set bak=null where 1=1;
+--alter table lf.sys_dep rename short to sname;
+--update lf.sys_dep set bak=null,create_time=now() where 1=1;
+
select * from lf.sys_dep;
+----------------------------------------------------------------------------------------------------- 鐩綍绠＄悊
+-- DROP TABLE IF EXISTS lf.sys_dir;
+create table lf.sys_dir(
+ id serial primary key,
+ pid integer,
+ name varchar(150),
+ short varchar(50),
+ code varchar(50),
+ uncode varchar(50),
+ addr varchar(300),
+ contact varchar(50),
+ fax varchar(50),
+ email varchar(50),
+ post varchar(20),
+ website varchar(1024),
+ level integer,
+ order_num integer,
+ create_user integer,
+ create_time timestamp(6) without time zone default now(),
+ update_user integer,
+ update_time timestamp(6) without time zone,
+ bak varchar(256)
+);
+
+comment on table lf.sys_dir is '鍗曚綅琛�';
+comment on column lf.sys_dir.id is '涓婚敭';
+comment on column lf.sys_dir.pid is '鐖禝D,鏍硅妭鐐�-0';
+comment on column lf.sys_dir.name is '鍚嶇О';
+
+comment on column lf.sys_dep.short is '绠�绉�';
+comment on column lf.sys_dep.code is '缂栫爜';
+comment on column lf.sys_dep.uncode is '鏈烘瀯浠ｇ爜';
+comment on column lf.sys_dep.addr is '鍦板潃';
+comment on column lf.sys_dep.contact is '鑱旂郴鏂瑰紡';
+comment on column lf.sys_dep.fax is '浼犵湡';
+comment on column lf.sys_dep.email is '鐢靛瓙閭欢';
+comment on column lf.sys_dep.post is '閭斂缂栫爜';
+comment on column lf.sys_dep.website is '缃戠珯鍦板潃';
+comment on column lf.sys_dep.level is '灞傜骇,鏍硅妭鐐�-0';
+comment on column lf.sys_dep.order_num is '鎺掑簭鍙�';
+
+comment on column lf.sys_dir.create_user is '鍒涘缓浜篒D';
+comment on column lf.sys_dir.create_time is '鍒涘缓鏃堕棿';
+comment on column lf.sys_dir.update_user is '鏇存柊浜篒D';
+comment on column lf.sys_dir.update_time is '鏇存柊鏃堕棿';
+comment on column lf.sys_dir.bak is '澶囨敞';
+
+--update lf.sys_dir set bak=null,create_time=now() where 1=1;
+
+select * from lf.sys_dir;
-----------------------------------------------------------------------------------------------------------
+select * from public.addr
-
-
+CREATE TABLE IF NOT EXISTS public.data_dir
+(
+ id integer NOT NULL,
+ name character varying(60) COLLATE pg_catalog."default",
+ pid integer NOT NULL,
+ oid integer DEFAULT 1,
+ CONSTRAINT data_dir_pkey PRIMARY KEY (id)
+)
diff --git a/data/dep.xls.BASE.xls b/data/dep.xls.BASE.xls
new file mode 100644
index 0000000..716b0d2
--- /dev/null
+++ b/data/dep.xls.BASE.xls
Binary files differ
diff --git a/data/dep.xls.LOCAL.xls b/data/dep.xls.LOCAL.xls
new file mode 100644
index 0000000..e1c90d2
--- /dev/null
+++ b/data/dep.xls.LOCAL.xls
Binary files differ
diff --git a/data/dep.xls.REMOTE.xls b/data/dep.xls.REMOTE.xls
new file mode 100644
index 0000000..c985177
--- /dev/null
+++ b/data/dep.xls.REMOTE.xls
Binary files differ
diff --git a/data/menu.csv b/data/menu.csv
new file mode 100644
index 0000000..fb94556
--- /dev/null
+++ b/data/menu.csv
@@ -0,0 +1,149 @@
+1,0,管道基础大数据平台,Pipeline Basic Big Data Platform,,,0,,0,1,0,1,,,,
+2,1,综合展示,Comprehensive Display,,,1,,1,2,1,1,,,,
+3,2,综合展示,Comprehensive Display,Synthesis,,1,,2,1,1,1,,,,
+4,3,图层,Coverage,,,2,,3,1,1,1,,,,
+5,3,视图,Viewport,,,2,,3,2,1,1,,,,
+6,3,漫游,Wander,,,2,,3,3,1,1,,,,
+7,3,分析,Analyse,,,2,,3,4,1,1,,,,
+8,3,查询,IQuery,,,2,,3,5,1,1,,,,
+9,3,定位,Orientation,,,2,,3,6,1,1,,,,
+10,3,测量,Measurement,,,2,,3,7,1,1,,,,
+11,3,标绘,Plotting,,,2,,3,8,1,1,,,,
+12,2,专题图,Thematic Maps,Thematic,,1,,2,2,1,1,,,,
+14,2,资料馆,Data Library,Archive,,1,,2,3,1,1,,,,
+15,14,查看,Check,,,2,,3,1,1,1,,,,
+16,14,新增,Insert,,,2,,3,2,1,1,,,,
+17,14,修改,Update,,,2,,3,3,1,1,,,,
+18,14,删除,Delete,,,2,,3,4,1,1,,,,
+19,14,下载,Download,,,2,,3,5,1,1,,,,
+20,1,数据管理,Data Manage,,,1,,1,3,1,1,,,,
+21,20,目录管理,CatalogueManage,catalogueManage,,1,,2,1,1,1,,,,
+22,21,查看,Check,,,2,,3,1,1,1,,,,
+23,21,新增,Insert,,,2,,3,2,1,1,,,,
+24,21,修改,Update,,,2,,3,3,1,1,,,,
+25,21,删除,Delete,,,2,,3,4,1,1,,,,
+26,20,数据上传,Data Updata,dataUpdata,,1,,2,2,1,1,,,,
+27,26,查看,Check,,,2,,3,1,1,1,,,,
+28,26,新增,Insert,,,2,,3,2,1,1,,,,
+29,26,修改,Update,,,2,,3,3,1,1,,,,
+30,26,删除,Delete,,,2,,3,4,1,1,,,,
+31,20,元数据管理,MetadataManage,metadataManage,,1,,2,3,1,1,,,,
+32,31,查看,Check,,,2,,3,1,1,1,,,,
+33,31,新增,Insert,,,2,,3,2,1,1,,,,
+34,31,修改,Update,,,2,,3,3,1,1,,,,
+35,31,删除,Delete,,,2,,3,4,1,1,,,,
+36,31,下载,Download,,,2,,3,5,1,1,,,,
+37,20,数据入库,DataLoading,dataLoading,,1,,2,4,1,1,,,,
+38,37,查看,Check,,,2,,3,1,1,1,,,,
+39,37,新增,Insert,,,2,,3,2,1,1,,,,
+40,37,修改,Update,,,2,,3,3,1,1,,,,
+41,37,删除,Delete,,,2,,3,4,1,1,,,,
+42,20,空间数据管理,SpatialData,SpatialData,,1,,2,5,1,1,,,,
+43,42,查看,Check,,,2,,3,1,1,1,,,,
+44,42,新增,Insert,,,2,,3,2,1,1,,,,
+45,42,修改,Update,,,2,,3,3,1,1,,,,
+46,42,删除,Delete,,,2,,3,4,1,1,,,,
+47,20,版本管理,VersionManage,versionManage,,1,,2,6,1,1,,,,
+48,47,查看,Check,,,2,,3,1,1,1,,,,
+49,47,新增,Insert,,,2,,3,2,1,1,,,,
+50,47,修改,Update,,,2,,3,3,1,1,,,,
+51,47,删除,Delete,,,2,,3,4,1,1,,,,
+52,20,字典管理,DictionaryManage,dictionaryManage,,1,,2,7,1,1,,,,
+53,52,查看,Check,,,2,,3,1,1,1,,,,
+54,52,新增,Insert,,,2,,3,2,1,1,,,,
+55,52,修改,Update,,,2,,3,3,1,1,,,,
+56,52,删除,Delete,,,2,,3,4,1,1,,,,
+57,20,样式管理,StyleManage,styleManage,,1,,2,8,1,1,,,,
+58,57,查看,Check,,,2,,3,1,1,1,,,,
+59,57,新增,Insert,,,2,,3,2,1,1,,,,
+60,57,修改,Update,,,2,,3,3,1,1,,,,
+61,57,删除,Delete,,,2,,3,4,1,1,,,,
+62,1,运维管理,Operat Manage,,,1,,1,4,1,1,,,,
+63,62,系统配置,System Layout,,,1,,2,1,1,1,,,,
+64,63,菜单配置,Menu Settings,menuSettings,,1,,3,1,1,1,,,,
+65,64,查看,Check,,,2,,4,1,1,1,,,,
+66,64,新增,Insert,,,2,,4,2,1,1,,,,
+67,64,修改,Update,,,2,,4,3,1,1,,,,
+68,64,删除,Delete,,,2,,4,4,1,1,,,,
+69,63,参数配置,ParameterConfiguration,parameterConfiguration,,1,,3,2,1,1,,,,
+70,69,查看,Check,,,2,,4,1,1,1,,,,
+71,69,新增,Insert,,,2,,4,2,1,1,,,,
+72,69,修改,Update,,,2,,4,3,1,1,,,,
+73,69,删除,Delete,,,2,,4,4,1,1,,,,
+74,63,其他,Rests,rests,,1,,3,3,1,1,,,,
+75,74,查看,Check,,,2,,4,1,1,1,,,,
+76,74,新增,Insert,,,2,,4,2,1,1,,,,
+77,74,修改,Update,,,2,,4,3,1,1,,,,
+78,74,删除,Delete,,,2,,4,4,1,1,,,,
+79,62,安全管理,Safety Management,safetyManagement,,1,,2,2,1,1,,,,
+80,79,查看,Check,,,2,,3,1,1,1,,,,
+81,79,新增,Insert,,,2,,3,2,1,1,,,,
+82,79,修改,Update,,,2,,3,3,1,1,,,,
+83,79,删除,Delete,,,2,,3,4,1,1,,,,
+84,62,运行监控,Operation Monitoring,,,1,,2,3,1,1,,,,
+85,84,事件日志管理,Event Log Manage,eventlogManage,,1,,3,1,1,1,,,,
+86,85,查看,Check,,,2,,4,1,1,1,,,,
+87,85,新增,Insert,,,2,,4,2,1,1,,,,
+88,85,修改,Update,,,2,,4,3,1,1,,,,
+89,85,删除,Delete,,,2,,4,4,1,1,,,,
+90,84,登录日志,ConLog,logLog,,1,,3,2,1,1,,,,
+91,90,查看,Check,,,2,,4,1,1,1,,,,
+92,90,新增,Insert,,,2,,4,2,1,1,,,,
+93,90,修改,Update,,,2,,4,3,1,1,,,,
+94,90,删除,Delete,,,2,,4,4,1,1,,,,
+95,84,操作日志,Operation Log,operationLog,,1,,3,3,1,1,,,,
+96,95,查看,Check,,,2,,4,1,1,1,,,,
+97,95,新增,Insert,,,2,,4,2,1,1,,,,
+98,95,修改,Update,,,2,,4,3,1,1,,,,
+99,95,删除,Delete,,,2,,4,4,1,1,,,,
+100,84,数据库监控,Database Monitoring,databaseMonitoring,,1,,3,4,1,1,,,,
+101,100,查看,Check,,,2,,4,1,1,1,,,,
+102,100,新增,Insert,,,2,,4,2,1,1,,,,
+103,100,修改,Update,,,2,,4,3,1,1,,,,
+104,100,删除,Delete,,,2,,4,4,1,1,,,,
+105,84,服务资源实时监控,System Monitoring,systemMonitoring,,1,,3,5,1,1,,,,
+106,105,查看,Check,,,2,,4,1,1,1,,,,
+107,105,新增,Insert,,,2,,4,2,1,1,,,,
+108,105,修改,Update,,,2,,4,3,1,1,,,,
+109,105,删除,Delete,,,2,,4,4,1,1,,,,
+110,84,黑白名单,Black/White List,blackwhiteList,,1,,3,6,1,1,,,,
+111,110,查看,Check,,,2,,4,1,1,1,,,,
+112,110,新增,Insert,,,2,,4,2,1,1,,,,
+113,110,修改,Update,,,2,,4,3,1,1,,,,
+114,110,删除,Delete,,,2,,4,4,1,1,,,,
+115,84,Token工具,Token Tool,tokentool,,1,,3,7,1,1,,,,
+116,115,查看,Check,,,2,,4,1,1,1,,,,
+117,115,新增,Insert,,,2,,4,2,1,1,,,,
+118,115,修改,Update,,,2,,4,3,1,1,,,,
+119,115,删除,Delete,,,2,,4,4,1,1,,,,
+120,62,用户管理,User Manage,,,1,,2,5,1,1,,,,
+121,120,用户信息管理,User Information Manage,userInfoManage,,1,,2,1,1,1,,,,
+122,121,查看,Check,,,2,,3,1,1,1,,,,
+123,121,新增,Insert,,,2,,3,2,1,1,,,,
+124,121,修改,Update,,,2,,3,3,1,1,,,,
+125,121,删除,Delete,,,2,,3,4,1,1,,,,
+126,120,组织机构管理,Org Manage,orgManage,,1,,2,2,1,1,,,,
+127,126,查看,Check,,,2,,3,1,1,1,,,,
+128,126,新增,Insert,,,2,,3,2,1,1,,,,
+129,126,修改,Update,,,2,,3,3,1,1,,,,
+130,126,删除,Delete,,,2,,3,4,1,1,,,,
+131,120,用户审核,User Auditing,userAuditing,,1,,2,3,1,1,,,,
+132,131,查看,Check,,,2,,3,1,1,1,,,,
+133,131,新增,Insert,,,2,,3,2,1,1,,,,
+134,131,修改,Update,,,2,,3,3,1,1,,,,
+135,131,删除,Delete,,,2,,3,4,1,1,,,,
+136,120,角色管理,Role Manage,roleManage,,1,,2,4,1,1,,,,
+137,136,查看,Check,,,2,,3,1,1,1,,,,
+138,136,新增,Insert,,,2,,3,2,1,1,,,,
+139,136,修改,Update,,,2,,3,3,1,1,,,,
+140,136,删除,Delete,,,2,,3,4,1,1,,,,
+141,120,群组管理,Group Manage,groupManage,,1,,2,5,1,1,,,,
+142,141,查看,Check,,,2,,3,1,1,1,,,,
+143,141,新增,Insert,,,2,,3,2,1,1,,,,
+144,141,修改,Update,,,2,,3,3,1,1,,,,
+145,141,删除,Delete,,,2,,3,4,1,1,,,,
+146,120,权限管理,Permission management,authorityManage,,1,,2,6,1,1,,,,
+147,146,查看,Check,,,2,,3,1,1,1,,,,
+148,146,新增,Insert,,,2,,3,2,1,1,,,,
+149,146,修改,Update,,,2,,3,3,1,1,,,,
+150,146,删除,Delete,,,2,,3,4,1,1,,,,
diff --git a/src/main/java/com/lf/server/LfApplication.java b/src/main/java/com/lf/server/LfApplication.java
index 592648c..12d0aa3 100644
--- a/src/main/java/com/lf/server/LfApplication.java
+++ b/src/main/java/com/lf/server/LfApplication.java
@@ -1,5 +1,6 @@
package com.lf.server;
+import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@@ -8,6 +9,7 @@
* @author
*/
@SpringBootApplication
+
public class LfApplication {
public static void main(String[] args) {
SpringApplication.run(LfApplication.class, args);
diff --git a/src/main/java/com/lf/server/controller/organization/DepController.java b/src/main/java/com/lf/server/controller/organization/DepController.java
new file mode 100644
index 0000000..836acc7
--- /dev/null
+++ b/src/main/java/com/lf/server/controller/organization/DepController.java
@@ -0,0 +1,52 @@
+package com.lf.server.controller.organization;
+
+import com.lf.server.entity.Result;
+import com.lf.server.entity.organization.DepEntity;
+import com.lf.server.service.oraganization.DepService;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+/**
+ * 缁勭粐鏈烘瀯
+ * @author sws
+ * @date 2022-09-23
+ */
+
+@RestController
+@RequestMapping("/dep")
+public class DepController {
+ @Autowired
+ DepService depService;
+
+ @RequestMapping(value ="/insertDep", method = RequestMethod.POST, produces = "application/json; charset=UTF-8")
+ public Boolean insertDep(DepEntity depEntity){
+ return depService.insertDep(depEntity);
+ }
+
+ @ResponseBody
+ @RequestMapping(value ="/delecteDep", method = RequestMethod.POST, produces = "application/json; charset=UTF-8")
+ public Boolean delecteDep(int id){
+ return depService.delecteDep(id);
+ }
+
+
+ @ResponseBody
+ @RequestMapping(value ="/updateDep", method = RequestMethod.POST, produces = "application/json; charset=UTF-8")
+ public Boolean updateDep(DepEntity depEntity){
+ return depService.updateDep(depEntity);
+ }
+
+
+ @GetMapping(value ="/selectDep")
+ public DepEntity selectDep(DepEntity depEntity){
+ return depService.selectDep(depEntity);
+ }
+
+ @GetMapping(value ="/selectDepAll")
+ public List<DepEntity> selectDepAll( ){
+ return depService.selectDepAll( );
+ }
+
+}
diff --git a/src/main/java/com/lf/server/entity/organization/DepEntity.java b/src/main/java/com/lf/server/entity/organization/DepEntity.java
new file mode 100644
index 0000000..2fc45f8
--- /dev/null
+++ b/src/main/java/com/lf/server/entity/organization/DepEntity.java
@@ -0,0 +1,213 @@
+package com.lf.server.entity.organization;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.io.Serializable;
+import java.sql.Timestamp;
+import java.util.Date;
+
+/**
+ * sys_dep
+ * @author www
+ * @date 2022-09-23
+ */
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class DepEntity implements Serializable {
+
+ private static final long serialVersionUID = -3673810416800666364L;
+
+ private int id;
+
+ private int pid;
+
+ private String name;
+
+ private String sname;
+
+ private String code;
+
+ private String uncode;
+
+ private String addr;
+
+ private String contact;
+
+ private String fax ;
+
+ private String email;
+
+ private String post;
+
+ private String website;
+
+ private int level;
+
+ private int orderNum;
+
+ private int createUser;
+
+ private Timestamp createTime;
+
+ private int updateUser;
+
+ private Timestamp updateTime;
+
+ private String bak;
+
+ public int getId() {
+ return id;
+ }
+
+ public void setId(int id) {
+ this.id = id;
+ }
+
+ public int getPid() {
+ return pid;
+ }
+
+ public void setPid(int pid) {
+ this.pid = pid;
+ }
+
+ public String getName() {
+ return name;
+ }
+
+ public void setName(String name) {
+ this.name = name;
+ }
+
+ public String getSname() {
+ return sname;
+ }
+
+ public void setSname(String sname) {
+ this.sname = sname;
+ }
+
+ public String getCode() {
+ return code;
+ }
+
+ public void setCode(String code) {
+ this.code = code;
+ }
+
+ public String getUncode() {
+ return uncode;
+ }
+
+ public void setUncode(String uncode) {
+ this.uncode = uncode;
+ }
+
+ public String getAddr() {
+ return addr;
+ }
+
+ public void setAddr(String addr) {
+ this.addr = addr;
+ }
+
+ public String getContact() {
+ return contact;
+ }
+
+ public void setContact(String contact) {
+ this.contact = contact;
+ }
+
+ public String getFax() {
+ return fax;
+ }
+
+ public void setFax(String fax) {
+ this.fax = fax;
+ }
+
+ public String getEmail() {
+ return email;
+ }
+
+ public void setEmail(String email) {
+ this.email = email;
+ }
+
+ public String getPost() {
+ return post;
+ }
+
+ public void setPost(String post) {
+ this.post = post;
+ }
+
+ public String getWebsite() {
+ return website;
+ }
+
+ public void setWebsite(String website) {
+ this.website = website;
+ }
+
+ public int getLevel() {
+ return level;
+ }
+
+ public void setLevel(int level) {
+ this.level = level;
+ }
+
+ public int getOrderNum() {
+ return orderNum;
+ }
+
+ public void setOrderNum(int orderNum) {
+ this.orderNum = orderNum;
+ }
+
+ public int getCreateUser() {
+ return createUser;
+ }
+
+ public void setCreateUser(int createUser) {
+ this.createUser = createUser;
+ }
+
+ public Timestamp getCreateTime() {
+ return createTime;
+ }
+
+ public void setCreateTime(Timestamp createTime) {
+ this.createTime = createTime;
+ }
+
+ public int getUpdateUser() {
+ return updateUser;
+ }
+
+ public void setUpdateUser(int updateUser) {
+ this.updateUser = updateUser;
+ }
+
+ public Timestamp getUpdateTime() {
+ return updateTime;
+ }
+
+ public void setUpdateTime(Timestamp updateTime) {
+ this.updateTime = updateTime;
+ }
+
+ public String getBak() {
+ return bak;
+ }
+
+ public void setBak(String bak) {
+ this.bak = bak;
+ }
+}
diff --git a/src/main/java/com/lf/server/mapper/oraganization/DepMapper.java b/src/main/java/com/lf/server/mapper/oraganization/DepMapper.java
new file mode 100644
index 0000000..4f568dd
--- /dev/null
+++ b/src/main/java/com/lf/server/mapper/oraganization/DepMapper.java
@@ -0,0 +1,50 @@
+package com.lf.server.mapper.oraganization;
+
+import org.apache.ibatis.annotations.Mapper;
+import org.springframework.stereotype.Repository;
+import com.lf.server.entity.organization.DepEntity;
+
+import java.util.List;
+
+/**
+ * 缁勭粐鏈烘瀯
+ * @author sws
+ * @date 2022-09-23
+ */
+@Mapper
+@Repository
+public interface DepMapper {
+ /**
+ * 娣诲姞鏁版嵁
+ * @param depEntity
+ * @return
+ */
+ public Boolean insertDep(DepEntity depEntity);
+
+ /**
+ * 鍒櫎鏁版嵁
+ * @param id
+ * @return
+ */
+ public Boolean delecteDep(int id);
+
+ /**
+ * 淇敼鏁版嵁
+ * @param depEntity
+ * @return
+ */
+ public Boolean updateDep(DepEntity depEntity);
+
+ /**
+ * 鏌ヨ鍗曟潯鏁版嵁
+ * @param depEntity
+ * @return
+ */
+ public DepEntity selectDep(DepEntity depEntity);
+
+ /**
+ * 鏌ヨ鍏ㄩ儴鏁版嵁
+ * @return
+ */
+ public List<DepEntity> selectDepAll();
+}
diff --git a/src/main/java/com/lf/server/service/oraganization/DepService.java b/src/main/java/com/lf/server/service/oraganization/DepService.java
new file mode 100644
index 0000000..b5e9d11
--- /dev/null
+++ b/src/main/java/com/lf/server/service/oraganization/DepService.java
@@ -0,0 +1,48 @@
+package com.lf.server.service.oraganization;
+
+
+import com.lf.server.entity.organization.DepEntity;
+import com.lf.server.mapper.oraganization.DepMapper;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+/**
+ * 缁勭粐鏈烘瀯
+ * @author sws
+ * @date 2022-09-23
+ */
+
+@Service
+public class DepService implements DepMapper {
+ @Autowired
+ DepMapper depMapper;
+
+ @Override
+ public Boolean insertDep(DepEntity depEntity) {
+ return depMapper.insertDep(depEntity);
+ }
+
+ @Override
+ public Boolean delecteDep(int id) {
+ return depMapper.delecteDep(id);
+ }
+
+ @Override
+ public Boolean updateDep(DepEntity depEntity) {
+ return depMapper.updateDep(depEntity);
+ }
+
+
+ @Override
+ public DepEntity selectDep(DepEntity depEntity) {
+ return depMapper.selectDep(depEntity);
+ }
+
+ @Override
+ public List<DepEntity> selectDepAll() {
+ return depMapper.selectDepAll();
+ }
+
+
+}
\ No newline at end of file
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index bb3a062..344bc25 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -10,7 +10,7 @@
datasource:
username : postgres
password: postgres
- url : jdbc:postgresql://127.0.0.1:5432/langfang
+ url : jdbc:postgresql://192.168.20.39:5433/langfang
driver-class-name: org.postgresql.Driver
type: com.alibaba.druid.pool.DruidDataSource # 鑷畾涔夋暟鎹簮
@@ -44,4 +44,4 @@
mybatis:
type-aliases-package: com.terra.land.mapper
- mapper-locations: classpath:mapper/*.xml
+ mapper-locations: classpath:mapper/**/*.xml
diff --git a/src/main/resources/mapper/oraganization/DepMapper.xml b/src/main/resources/mapper/oraganization/DepMapper.xml
new file mode 100644
index 0000000..2c95c63
--- /dev/null
+++ b/src/main/resources/mapper/oraganization/DepMapper.xml
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.lf.server.mapper.oraganization.DepMapper">
+ <resultMap id="selectDepAllMap" type="com.lf.server.entity.organization.DepEntity">
+ <id property="id" column="id"></id>
+ <result property="orderNum" column="order_num"></result>
+ <result property="createUser" column="create_user"></result>
+ <result property="createTime" column="create_time"></result>
+ <result property="updateUser" column="update_user"></result>
+ <result property="updateTime" column="update_time"></result>
+ </resultMap>
+
+ <select id="selectDepAll" resultMap="selectDepAllMap" resultType="com.lf.server.entity.organization.DepEntity">
+ select * from lf.sys_dep
+ </select>
+</mapper>
\ No newline at end of file
--
Gitblit v1.9.3