From 926dc4daf0ea8be960647ecaeec389e866037ef9 Mon Sep 17 00:00:00 2001
From: lige <bestlige@outlook.com>
Date: 星期一, 11 十二月 2023 18:39:09 +0800
Subject: [PATCH] sqlserver拿视图数据存储mysql表
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 36 ++++++++++++++++++++++++++++++------
1 files changed, 30 insertions(+), 6 deletions(-)
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 d19e750..6c255ef 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,10 +3,14 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.annotation.DataSource;
import com.ltkj.common.enums.DataSourceType;
-import com.ltkj.hosp.domain.SqlTest;
-import com.ltkj.hosp.domain.TjAdvice;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
+import com.ltkj.hosp.sqlDomain.LtkjTjPat;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
/**
* @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
@@ -14,8 +18,28 @@
* @Date: 2023/12/11 14:51
*/
@Mapper
-public interface TestMapper extends BaseMapper<SqlTest> {
- @DataSource(value = DataSourceType.SLAVE)
- @Select("select * from City where id=1")
- public SqlTest getList();
+@DataSource(value = DataSourceType.SLAVE)
+public interface TestMapper{
+
+ @Select("SELECT * FROM tjv_Ltkj_middle_detail")
+ public List<LtkjMiddleDetail> getMiddleDetail();
+
+ @Select("SELECT * FROM tjv_Ltkj_middle_head")
+ public List<LtkjMiddleHead> getMiddleHead();
+
+// @Select("SELECT * FROM tjv_LTKJVBJITEM")
+// public List<LtkjVbjitem> getVbjitem();
+
+ @Select("SELECT * FROM tjv_LTKJVTJPAT")
+ public List<LtkjTjPat> getTjPat();
+
+
+ @Select("SELECT * FROM tjv_LTKJVTJPAT where pat_id=#{id}")
+ public LtkjTjPat getTjPatById(String id);
+
+ @Select("SELECT * FROM tjv_Ltkj_middle_detail where fdetall_id=#{id}")
+ public LtkjMiddleDetail getMiddleDetailById(String id);
+
+ @Select("SELECT * FROM tjv_Ltkj_middle_head where fead_id=#{id}")
+ public LtkjMiddleHead getMiddleHeadById(String id);
}
--
Gitblit v1.8.0