From d0fb64d4f70c6fbf782018c928555be517bf7066 Mon Sep 17 00:00:00 2001
From: lige <bestlige@outlook.com>
Date: 星期二, 12 十二月 2023 09:46:46 +0800
Subject: [PATCH] sqlserver拿视图数据存储mysql表 同时配置三个从库
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java | 18 ++
ltkj-common/src/main/java/com/ltkj/common/enums/DataSourceType.java | 8
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHysqdMapper.java | 18 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjExamJcbgd.java | 16 +
ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjExamJcsqd.java | 23 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java | 13 +
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java | 21 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHybgd.java | 26 ++
ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java | 117 +++++++++++-
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHysqdServiceImpl.java | 21 ++
ltkj-framework/src/main/java/com/ltkj/framework/config/DruidConfig.java | 26 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java | 17 +
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 45 ++++
ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHysqdService.java | 13 +
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcbgdServiceImpl.java | 21 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcbgdService.java | 13 +
ltkj-admin/src/main/resources/application-druid.yml | 18 +
ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHybgdService.java | 13 +
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHybgdServiceImpl.java | 21 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java | 18 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHysqd.java | 21 ++
21 files changed, 485 insertions(+), 22 deletions(-)
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
index fe9db4e..27ff245 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
@@ -4,12 +4,8 @@
import com.ltkj.common.core.domain.AjaxResult;
import com.ltkj.common.enums.DataSourceType;
import com.ltkj.framework.datasource.DynamicDataSourceContextHolder;
-import com.ltkj.hosp.service.LtkjMiddleDetailService;
-import com.ltkj.hosp.service.LtkjMiddleHeadService;
-import com.ltkj.hosp.service.TjvLtkjvtjpatService;
-import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
-import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
-import com.ltkj.hosp.sqlDomain.LtkjTjPat;
+import com.ltkj.hosp.service.*;
+import com.ltkj.hosp.sqlDomain.*;
import com.ltkj.hosp.mapper.TestMapper;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
@@ -34,20 +30,36 @@
@Resource
private LtkjMiddleHeadService headService;
+ @Resource
+ private LtkjExamJcbgdService ltkjExamJcbgdService;
+ @Resource
+ private LtkjExamJcsqdService ltkjExamJcsqdService;
+ @Resource
+ private LtkjHybgdService ltkjHybgdService;
+ @Resource
+ private LtkjHysqdService ltkjHysqdService;
@GetMapping("/getMiddleDetail")
- @ApiOperation(value = "鏌ョ湅鍒楄〃")
public AjaxResult getMiddleDetail() {
List<LtkjMiddleDetail> list = testMapper.getMiddleDetail();
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ for (LtkjMiddleDetail ltkjMiddleDetail : list) {
+ final boolean save = middleDetailService.save(ltkjMiddleDetail);
+ }
+ DynamicDataSourceContextHolder.clearDataSourceType();
return AjaxResult.success(list);
}
@GetMapping("/getMiddleHead")
- @ApiOperation(value = "鏌ョ湅鍒楄〃")
public AjaxResult getMiddleHead() {
List<LtkjMiddleHead> list = testMapper.getMiddleHead();
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ for (LtkjMiddleHead ltkjMiddleHead : list) {
+ final boolean save = headService.save(ltkjMiddleHead);
+ }
+ DynamicDataSourceContextHolder.clearDataSourceType();
return AjaxResult.success(list);
}
@@ -60,15 +72,62 @@
@GetMapping("/getTjPat")
- @ApiOperation(value = "鏌ョ湅鍒楄〃")
public AjaxResult getTjPat() {
List<LtkjTjPat> list = testMapper.getTjPat();
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ for (LtkjTjPat ltkjTjPat : list) {
+ final boolean save = tjvLtkjvtjpatService.save(ltkjTjPat);
+ }
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ return AjaxResult.success(list);
+ }
+
+ @GetMapping("/getExamJcbgd")
+ public AjaxResult getExamJcbgd() {
+ List<LtkjExamJcbgd> list = testMapper.getExamJcbgd();
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ for (LtkjExamJcbgd ltkjExamJcbgd : list) {
+ final boolean save = ltkjExamJcbgdService.save(ltkjExamJcbgd);
+ }
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ return AjaxResult.success(list);
+ }
+
+ @GetMapping("/getExamJcsqd")
+ public AjaxResult getExamJcsqd() {
+ List<LtkjExamJcsqd> list = testMapper.getExamJcsqd();
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ for (LtkjExamJcsqd ltkjExamJcsqd : list) {
+ final boolean save = ltkjExamJcsqdService.save(ltkjExamJcsqd);
+ }
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ return AjaxResult.success(list);
+ }
+
+ @GetMapping("/getHybgd")
+ public AjaxResult getHybgd() {
+ List<LtkjHybgd> list = testMapper.getHybgd();
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ for (LtkjHybgd ltkjHybgd : list) {
+ final boolean save = ltkjHybgdService.save(ltkjHybgd);
+ }
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ return AjaxResult.success(list);
+ }
+
+ @GetMapping("/getHysqd")
+ public AjaxResult getHysqd() {
+ List<LtkjHysqd> list = testMapper.getHysqd();
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ for (LtkjHysqd ltkjHysqd : list) {
+ final boolean save = ltkjHysqdService.save(ltkjHysqd);
+ }
+ DynamicDataSourceContextHolder.clearDataSourceType();
return AjaxResult.success(list);
}
@GetMapping("/getLtkjTjPatById")
- @ApiOperation(value = "鏍规嵁id鏌�,瀛樿繘mysql")
public AjaxResult getLtkjTjPatById(String id) {
LtkjTjPat one = testMapper.getTjPatById(id);
DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
@@ -79,7 +138,6 @@
@GetMapping("/getMiddleDetailById")
- @ApiOperation(value = "鏍规嵁id鏌�,瀛樿繘mysql")
public AjaxResult getMiddleDetailById(String id) {
LtkjMiddleDetail one = testMapper.getMiddleDetailById(id);
DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
@@ -90,7 +148,6 @@
@GetMapping("/getMiddleHeadById")
- @ApiOperation(value = "鏍规嵁id鏌�,瀛樿繘mysql")
public AjaxResult getMiddleHeadById(String id) {
LtkjMiddleHead one = testMapper.getMiddleHeadById(id);
DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
@@ -99,4 +156,40 @@
return AjaxResult.success(save);
}
+
+ @GetMapping("/getExamJcbgdById")
+ public AjaxResult getExamJcbgdById(String id) {
+ LtkjExamJcbgd one = testMapper.getExamJcbgdById(id);
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ final boolean save = ltkjExamJcbgdService.save(one);
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ return AjaxResult.success(save);
+ }
+
+ @GetMapping("/getExamJcsqdById")
+ public AjaxResult getExamJcsqdById(String id) {
+ LtkjExamJcsqd one = testMapper.getExamJcsqdById(id);
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ final boolean save = ltkjExamJcsqdService.save(one);
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ return AjaxResult.success(save);
+ }
+
+ @GetMapping("/getHybgdById")
+ public AjaxResult getHybgdById(String id) {
+ LtkjHybgd one = testMapper.getHybgdById(id);
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ final boolean save = ltkjHybgdService.save(one);
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ return AjaxResult.success(save);
+ }
+
+ @GetMapping("/getHysqdById")
+ public AjaxResult getHysqdById(String id) {
+ LtkjHysqd one = testMapper.getHysqdById(id);
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ final boolean save = ltkjHysqdService.save(one);
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ return AjaxResult.success(save);
+ }
}
diff --git a/ltkj-admin/src/main/resources/application-druid.yml b/ltkj-admin/src/main/resources/application-druid.yml
index 082579f..2ff3971 100644
--- a/ltkj-admin/src/main/resources/application-druid.yml
+++ b/ltkj-admin/src/main/resources/application-druid.yml
@@ -13,7 +13,23 @@
#password: Root_ltkj123
password: Root_ltkj123
# 浠庡簱鏁版嵁婧�
- slave:
+ slavepacs:
+ # 浠庢暟鎹簮寮�鍏�/榛樿鍏抽棴
+ enabled: true
+ driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
+ url: jdbc:sqlserver://192.168.0.111:1433;DatabaseName=Testlg
+ username: sa
+ password: admin123
+ # 浠庡簱鏁版嵁婧�
+ slavehis:
+ # 浠庢暟鎹簮寮�鍏�/榛樿鍏抽棴
+ enabled: true
+ driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
+ url: jdbc:sqlserver://192.168.0.111:1433;DatabaseName=Testlg
+ username: sa
+ password: admin123
+ # 浠庡簱鏁版嵁婧�
+ slavelis:
# 浠庢暟鎹簮寮�鍏�/榛樿鍏抽棴
enabled: true
driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
diff --git a/ltkj-common/src/main/java/com/ltkj/common/enums/DataSourceType.java b/ltkj-common/src/main/java/com/ltkj/common/enums/DataSourceType.java
index fad5fc9..693da70 100644
--- a/ltkj-common/src/main/java/com/ltkj/common/enums/DataSourceType.java
+++ b/ltkj-common/src/main/java/com/ltkj/common/enums/DataSourceType.java
@@ -14,5 +14,11 @@
/**
* 浠庡簱
*/
- SLAVE
+ SLAVE_PACS,
+
+
+ SLAVE_HIS,
+
+
+ SLAVE_LIS,
}
diff --git a/ltkj-framework/src/main/java/com/ltkj/framework/config/DruidConfig.java b/ltkj-framework/src/main/java/com/ltkj/framework/config/DruidConfig.java
index 9422c37..f967e4e 100644
--- a/ltkj-framework/src/main/java/com/ltkj/framework/config/DruidConfig.java
+++ b/ltkj-framework/src/main/java/com/ltkj/framework/config/DruidConfig.java
@@ -91,9 +91,25 @@
}
@Bean
- @ConfigurationProperties("spring.datasource.druid.slave")
- @ConditionalOnProperty(prefix = "spring.datasource.druid.slave", name = "enabled", havingValue = "true")
- public DataSource slaveDataSource(DruidProperties druidProperties) {
+ @ConfigurationProperties("spring.datasource.druid.slavehis")
+ @ConditionalOnProperty(prefix = "spring.datasource.druid.slavehis", name = "enabled", havingValue = "true")
+ public DataSource slaveHisDataSource(DruidProperties druidProperties) {
+ DruidDataSource dataSource = DruidDataSourceBuilder.create().build();
+ return druidProperties.dataSource(dataSource);
+ }
+
+ @Bean
+ @ConfigurationProperties("spring.datasource.druid.slavelis")
+ @ConditionalOnProperty(prefix = "spring.datasource.druid.slavelis", name = "enabled", havingValue = "true")
+ public DataSource slaveDataLisSource(DruidProperties druidProperties) {
+ DruidDataSource dataSource = DruidDataSourceBuilder.create().build();
+ return druidProperties.dataSource(dataSource);
+ }
+
+ @Bean
+ @ConfigurationProperties("spring.datasource.druid.slavepacs")
+ @ConditionalOnProperty(prefix = "spring.datasource.druid.slavepacs", name = "enabled", havingValue = "true")
+ public DataSource slaveDataPacsSource(DruidProperties druidProperties) {
DruidDataSource dataSource = DruidDataSourceBuilder.create().build();
return druidProperties.dataSource(dataSource);
}
@@ -103,7 +119,9 @@
public DynamicDataSource dataSource(DataSource masterDataSource) {
Map<Object, Object> targetDataSources = new HashMap<>();
targetDataSources.put(DataSourceType.MASTER.name(), masterDataSource);
- setDataSource(targetDataSources, DataSourceType.SLAVE.name(), "slaveDataSource");
+ setDataSource(targetDataSources, DataSourceType.SLAVE_HIS.name(), "slaveHisDataSource");
+ setDataSource(targetDataSources, DataSourceType.SLAVE_LIS.name(), "slaveDataLisSource");
+ setDataSource(targetDataSources, DataSourceType.SLAVE_PACS.name(), "slaveDataPacsSource");
return new DynamicDataSource(masterDataSource, targetDataSources);
}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java
new file mode 100644
index 0000000..2a4700f
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java
@@ -0,0 +1,17 @@
+package com.ltkj.hosp.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.common.annotation.DataSource;
+import com.ltkj.common.enums.DataSourceType;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:56
+ */
+@Mapper
+@DataSource(value = DataSourceType.MASTER)
+public interface LtkjExamJcbgdMapper extends BaseMapper<LtkjExamJcbgd> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java
new file mode 100644
index 0000000..7dbaf58
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java
@@ -0,0 +1,18 @@
+package com.ltkj.hosp.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.common.annotation.DataSource;
+import com.ltkj.common.enums.DataSourceType;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:56
+ */
+@Mapper
+@DataSource(value = DataSourceType.MASTER)
+public interface LtkjExamJcsqdMapper extends BaseMapper<LtkjExamJcsqd> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java
new file mode 100644
index 0000000..1b04fe1
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java
@@ -0,0 +1,18 @@
+package com.ltkj.hosp.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.common.annotation.DataSource;
+import com.ltkj.common.enums.DataSourceType;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
+import com.ltkj.hosp.sqlDomain.LtkjHybgd;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:56
+ */
+@Mapper
+@DataSource(value = DataSourceType.MASTER)
+public interface LtkjHybgdMapper extends BaseMapper<LtkjHybgd> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHysqdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHysqdMapper.java
new file mode 100644
index 0000000..18de882
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHysqdMapper.java
@@ -0,0 +1,18 @@
+package com.ltkj.hosp.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.common.annotation.DataSource;
+import com.ltkj.common.enums.DataSourceType;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
+import com.ltkj.hosp.sqlDomain.LtkjHysqd;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:56
+ */
+@Mapper
+@DataSource(value = DataSourceType.MASTER)
+public interface LtkjHysqdMapper extends BaseMapper<LtkjHysqd> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
index 6c255ef..28ff848 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
@@ -3,9 +3,7 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.annotation.DataSource;
import com.ltkj.common.enums.DataSourceType;
-import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
-import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
-import com.ltkj.hosp.sqlDomain.LtkjTjPat;
+import com.ltkj.hosp.sqlDomain.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@@ -18,28 +16,67 @@
* @Date: 2023/12/11 14:51
*/
@Mapper
-@DataSource(value = DataSourceType.SLAVE)
public interface TestMapper{
@Select("SELECT * FROM tjv_Ltkj_middle_detail")
+ @DataSource(value = DataSourceType.SLAVE_HIS)
public List<LtkjMiddleDetail> getMiddleDetail();
+ @DataSource(value = DataSourceType.SLAVE_LIS)
@Select("SELECT * FROM tjv_Ltkj_middle_head")
public List<LtkjMiddleHead> getMiddleHead();
// @Select("SELECT * FROM tjv_LTKJVBJITEM")
// public List<LtkjVbjitem> getVbjitem();
+ @DataSource(value = DataSourceType.SLAVE_PACS)
@Select("SELECT * FROM tjv_LTKJVTJPAT")
public List<LtkjTjPat> getTjPat();
+ @DataSource(value = DataSourceType.SLAVE_HIS)
+ @Select("SELECT * FROM tjv_exam_jcbgd")
+ public List<LtkjExamJcbgd> getExamJcbgd();
+ @DataSource(value = DataSourceType.SLAVE_HIS)
+ @Select("SELECT * FROM tjv_exam_jcsqd")
+ public List<LtkjExamJcsqd> getExamJcsqd();
+
+
+ @DataSource(value = DataSourceType.SLAVE_HIS)
+ @Select("SELECT * FROM tjv_Ltkj_hybgd")
+ public List<LtkjHybgd> getHybgd();
+
+ @DataSource(value = DataSourceType.SLAVE_HIS)
+ @Select("SELECT * FROM tjv_Ltkj_hysqd")
+ public List<LtkjHysqd> getHysqd();
+
+
+ @DataSource(value = DataSourceType.SLAVE_HIS)
@Select("SELECT * FROM tjv_LTKJVTJPAT where pat_id=#{id}")
public LtkjTjPat getTjPatById(String id);
+ @DataSource(value = DataSourceType.SLAVE_HIS)
@Select("SELECT * FROM tjv_Ltkj_middle_detail where fdetall_id=#{id}")
public LtkjMiddleDetail getMiddleDetailById(String id);
+ @DataSource(value = DataSourceType.SLAVE_HIS)
@Select("SELECT * FROM tjv_Ltkj_middle_head where fead_id=#{id}")
public LtkjMiddleHead getMiddleHeadById(String id);
+
+ @DataSource(value = DataSourceType.SLAVE_HIS)
+ @Select("SELECT * FROM tjv_exam_jcbgd where tmh=#{id}")
+ public LtkjExamJcbgd getExamJcbgdById(String id);
+
+ @DataSource(value = DataSourceType.SLAVE_HIS)
+ @Select("SELECT * FROM tjv_exam_jcsqd where tjh=#{id}")
+ public LtkjExamJcsqd getExamJcsqdById(String id);
+
+
+ @DataSource(value = DataSourceType.SLAVE_HIS)
+ @Select("SELECT * FROM tjv_Ltkj_hybgd where tmh=#{id}")
+ public LtkjHybgd getHybgdById(String id);
+
+ @DataSource(value = DataSourceType.SLAVE_HIS)
+ @Select("SELECT * FROM tjv_Ltkj_hysqd where tmh=#{id}")
+ public LtkjHysqd getHysqdById(String id);
}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcbgdService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcbgdService.java
new file mode 100644
index 0000000..fb8410f
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcbgdService.java
@@ -0,0 +1,13 @@
+package com.ltkj.hosp.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:57
+ */
+public interface LtkjExamJcbgdService extends IService<LtkjExamJcbgd> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java
new file mode 100644
index 0000000..f7afd73
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java
@@ -0,0 +1,13 @@
+package com.ltkj.hosp.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:57
+ */
+public interface LtkjExamJcsqdService extends IService<LtkjExamJcsqd> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHybgdService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHybgdService.java
new file mode 100644
index 0000000..29cd569
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHybgdService.java
@@ -0,0 +1,13 @@
+package com.ltkj.hosp.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
+import com.ltkj.hosp.sqlDomain.LtkjHybgd;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:57
+ */
+public interface LtkjHybgdService extends IService<LtkjHybgd> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHysqdService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHysqdService.java
new file mode 100644
index 0000000..ccc37ac
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHysqdService.java
@@ -0,0 +1,13 @@
+package com.ltkj.hosp.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ltkj.hosp.sqlDomain.LtkjHybgd;
+import com.ltkj.hosp.sqlDomain.LtkjHysqd;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:57
+ */
+public interface LtkjHysqdService extends IService<LtkjHysqd> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcbgdServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcbgdServiceImpl.java
new file mode 100644
index 0000000..e1eecad
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcbgdServiceImpl.java
@@ -0,0 +1,21 @@
+package com.ltkj.hosp.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ltkj.hosp.mapper.LtkjExamJcbgdMapper;
+import com.ltkj.hosp.mapper.LtkjMiddleDetailMapper;
+import com.ltkj.hosp.service.LtkjExamJcbgdService;
+import com.ltkj.hosp.service.LtkjMiddleDetailService;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
+import org.springframework.stereotype.Service;
+
+/**
+ * 鐥呯+鎰忚Service涓氬姟灞傚鐞�
+ *
+ * @author ltkj_璧典匠璞�&鏉庢牸
+ * @date 2023-08-30
+ */
+@Service
+public class LtkjExamJcbgdServiceImpl extends ServiceImpl<LtkjExamJcbgdMapper, LtkjExamJcbgd> implements LtkjExamJcbgdService {
+
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
new file mode 100644
index 0000000..e3ab2cc
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
@@ -0,0 +1,21 @@
+package com.ltkj.hosp.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ltkj.hosp.mapper.LtkjExamJcbgdMapper;
+import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
+import com.ltkj.hosp.service.LtkjExamJcbgdService;
+import com.ltkj.hosp.service.LtkjExamJcsqdService;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
+import org.springframework.stereotype.Service;
+
+/**
+ * 鐥呯+鎰忚Service涓氬姟灞傚鐞�
+ *
+ * @author ltkj_璧典匠璞�&鏉庢牸
+ * @date 2023-08-30
+ */
+@Service
+public class LtkjExamJcsqdServiceImpl extends ServiceImpl<LtkjExamJcsqdMapper, LtkjExamJcsqd> implements LtkjExamJcsqdService {
+
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHybgdServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHybgdServiceImpl.java
new file mode 100644
index 0000000..039c427
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHybgdServiceImpl.java
@@ -0,0 +1,21 @@
+package com.ltkj.hosp.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
+import com.ltkj.hosp.mapper.LtkjHybgdMapper;
+import com.ltkj.hosp.service.LtkjExamJcsqdService;
+import com.ltkj.hosp.service.LtkjHybgdService;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
+import com.ltkj.hosp.sqlDomain.LtkjHybgd;
+import org.springframework.stereotype.Service;
+
+/**
+ * 鐥呯+鎰忚Service涓氬姟灞傚鐞�
+ *
+ * @author ltkj_璧典匠璞�&鏉庢牸
+ * @date 2023-08-30
+ */
+@Service
+public class LtkjHybgdServiceImpl extends ServiceImpl<LtkjHybgdMapper, LtkjHybgd> implements LtkjHybgdService {
+
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHysqdServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHysqdServiceImpl.java
new file mode 100644
index 0000000..6ba7799
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHysqdServiceImpl.java
@@ -0,0 +1,21 @@
+package com.ltkj.hosp.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
+import com.ltkj.hosp.mapper.LtkjHysqdMapper;
+import com.ltkj.hosp.service.LtkjExamJcsqdService;
+import com.ltkj.hosp.service.LtkjHysqdService;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
+import com.ltkj.hosp.sqlDomain.LtkjHysqd;
+import org.springframework.stereotype.Service;
+
+/**
+ * 鐥呯+鎰忚Service涓氬姟灞傚鐞�
+ *
+ * @author ltkj_璧典匠璞�&鏉庢牸
+ * @date 2023-08-30
+ */
+@Service
+public class LtkjHysqdServiceImpl extends ServiceImpl<LtkjHysqdMapper, LtkjHysqd> implements LtkjHysqdService {
+
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjExamJcbgd.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjExamJcbgd.java
new file mode 100644
index 0000000..5dac301
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjExamJcbgd.java
@@ -0,0 +1,16 @@
+package com.ltkj.hosp.sqlDomain;
+
+import lombok.Data;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 16:37
+ */
+@Data
+public class LtkjExamJcbgd {
+ private String tmh;
+ private String bgImg;
+ private String bgUrl;
+ private String bgNr;
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjExamJcsqd.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjExamJcsqd.java
new file mode 100644
index 0000000..bc1995e
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjExamJcsqd.java
@@ -0,0 +1,23 @@
+package com.ltkj.hosp.sqlDomain;
+
+import lombok.Data;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 16:37
+ */
+@Data
+public class LtkjExamJcsqd {
+ private String tjh;
+ private String tmh;
+ private String jclx;
+ private String jczlx;
+ private String bgys;
+ private String bgysid;
+ private String sqsj;
+ private String jcxmmc;
+ private String jcxmid;
+ private String bw;
+ private String jgzt;
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHybgd.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHybgd.java
new file mode 100644
index 0000000..bdc2e3e
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHybgd.java
@@ -0,0 +1,26 @@
+package com.ltkj.hosp.sqlDomain;
+
+import lombok.Data;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 16:37
+ */
+@Data
+public class LtkjHybgd {
+ private String tmh;
+ private String jcxmid;
+ private String jcxm;
+ private String tdh;
+ private String jyjg;
+ private String jgdw;
+ private String fwzdz;
+ private String fwzgz;
+ private String fwz;
+ private String jysj;
+ private String jyys;
+ private String shsj;
+ private String shys;
+ private String tpurl;
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHysqd.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHysqd.java
new file mode 100644
index 0000000..3b244f2
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHysqd.java
@@ -0,0 +1,21 @@
+package com.ltkj.hosp.sqlDomain;
+
+import lombok.Data;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 16:37
+ */
+@Data
+public class LtkjHysqd {
+ private String tjh;
+ private String tmh;
+ private String bbbh;
+ private String bbmc;
+ private String xmid;
+ private String xmmc;
+ private String sqsj;
+ private String sqys;
+ private String jgsj;
+}
--
Gitblit v1.8.0