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-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java | 117 ++++++++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 105 insertions(+), 12 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);
+ }
}
--
Gitblit v1.8.0