From d97d9ec608862afc97143ed65331e50e0739a45f Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期四, 23 五月 2024 09:15:08 +0800
Subject: [PATCH] 多数据源
---
src/main/java/com/whyc/pojo/EasyDarwin.java | 24 ++++++++
src/main/java/com/whyc/mapper/EasyDarwinMapper.java | 6 ++
src/main/resources/config/application-dev.yml | 21 +++++--
src/main/java/com/whyc/controller/EasyDarwinController.java | 28 +++++++++
src/main/java/com/whyc/controller/DMTestController.java | 5 +
src/main/java/com/whyc/service/EasyDarwinService.java | 27 +++++++++
pom.xml | 11 +++
7 files changed, 114 insertions(+), 8 deletions(-)
diff --git a/pom.xml b/pom.xml
index 7363ff5..29d1231 100644
--- a/pom.xml
+++ b/pom.xml
@@ -33,12 +33,23 @@
<artifactId>spring-boot-configuration-processor</artifactId>
<optional>true</optional>
</dependency>
+
+ <dependency>
+ <groupId>com.baomidou</groupId>
+ <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
+ <version>4.3.0</version>
+ </dependency>
+ <dependency>
+ <groupId>org.xerial</groupId>
+ <artifactId>sqlite-jdbc</artifactId>
+ </dependency>
<!--highgo鏁版嵁搴撹繛鎺ユ睜 瀹夊叏鐗圴4.5鐗堟湰鍙婁紒涓氱増V6鍏煎-->
<dependency>
<groupId>com.highgo</groupId>
<artifactId>HgdbJdbc</artifactId>
<version>6.2.3</version>
</dependency>
+
<dependency>
<groupId>com.google.code.gson</groupId>
<artifactId>gson</artifactId>
diff --git a/src/main/java/com/whyc/controller/DMTestController.java b/src/main/java/com/whyc/controller/DMTestController.java
index 11687da..d0e9de3 100644
--- a/src/main/java/com/whyc/controller/DMTestController.java
+++ b/src/main/java/com/whyc/controller/DMTestController.java
@@ -2,13 +2,14 @@
import com.whyc.dto.Response;
import com.whyc.service.DMTestService;
+import io.swagger.annotations.Api;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
-
-@RequestMapping("test")
+@Api(tags = "娴嬭瘯缈伴珮鏁版嵁搴�")
+@RequestMapping("DMTest")
@RestController
public class DMTestController {
diff --git a/src/main/java/com/whyc/controller/EasyDarwinController.java b/src/main/java/com/whyc/controller/EasyDarwinController.java
new file mode 100644
index 0000000..9191135
--- /dev/null
+++ b/src/main/java/com/whyc/controller/EasyDarwinController.java
@@ -0,0 +1,28 @@
+package com.whyc.controller;
+
+import com.whyc.dto.Response;
+import com.whyc.service.DMTestService;
+import com.whyc.service.EasyDarwinService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+import javax.annotation.Resource;
+
+@Api(tags = "鎽勫儚澶磋浆鐮佷俊鎭�")
+@RestController
+@RequestMapping("EasyDarwin")
+public class EasyDarwinController {
+
+ @Resource
+ private EasyDarwinService service;
+
+
+ @GetMapping("getFlowInfo")
+ @ApiOperation("鑾峰彇鎽勫儚澶磋浆鐮佷俊鎭�")
+ public Response getFlowInfo(){
+ return service.getFlowInfo();
+ }
+}
diff --git a/src/main/java/com/whyc/mapper/EasyDarwinMapper.java b/src/main/java/com/whyc/mapper/EasyDarwinMapper.java
new file mode 100644
index 0000000..9b9e0fe
--- /dev/null
+++ b/src/main/java/com/whyc/mapper/EasyDarwinMapper.java
@@ -0,0 +1,6 @@
+package com.whyc.mapper;
+
+import com.whyc.pojo.EasyDarwin;
+
+public interface EasyDarwinMapper extends CustomMapper<EasyDarwin>{
+}
diff --git a/src/main/java/com/whyc/pojo/EasyDarwin.java b/src/main/java/com/whyc/pojo/EasyDarwin.java
new file mode 100644
index 0000000..311b1e0
--- /dev/null
+++ b/src/main/java/com/whyc/pojo/EasyDarwin.java
@@ -0,0 +1,24 @@
+package com.whyc.pojo;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.Data;
+
+import java.util.Date;
+
+@TableName(schema = "main",value = "t_pull_to_push")
+@Data
+public class EasyDarwin {
+ @TableField("id")
+ private String id;
+ @TableField("create_at")
+ private Date createAt;
+ @TableField("update_at")
+ private Date updateAt;
+ @TableField("push_name")
+ private String pushName;
+ @TableField("origin")
+ private String origin;
+ @TableField("push_url")
+ private String pushUrl;
+}
diff --git a/src/main/java/com/whyc/service/EasyDarwinService.java b/src/main/java/com/whyc/service/EasyDarwinService.java
new file mode 100644
index 0000000..5efddb5
--- /dev/null
+++ b/src/main/java/com/whyc/service/EasyDarwinService.java
@@ -0,0 +1,27 @@
+package com.whyc.service;
+
+import com.baomidou.dynamic.datasource.annotation.DS;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.whyc.dto.Response;
+import com.whyc.mapper.EasyDarwinMapper;
+import com.whyc.pojo.EasyDarwin;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+@Service
+@DS("db2")
+public class EasyDarwinService {
+ @Autowired(required = false)
+ private EasyDarwinMapper mapper;
+
+ //鑾峰彇鎽勫儚澶磋浆鐮佷俊鎭�
+ public Response getFlowInfo() {
+ QueryWrapper wrapper=new QueryWrapper();
+ wrapper.last("limit 1");
+ EasyDarwin ed=mapper.selectOne(wrapper);
+ return new Response().setII(1,ed!=null,ed,"鑾峰彇鎽勫儚澶磋浆鐮佷俊鎭�");
+ }
+
+
+
+}
diff --git a/src/main/resources/config/application-dev.yml b/src/main/resources/config/application-dev.yml
index c616905..48ca08c 100644
--- a/src/main/resources/config/application-dev.yml
+++ b/src/main/resources/config/application-dev.yml
@@ -18,12 +18,21 @@
#鏁版嵁搴�
spring:
datasource:
- type: com.alibaba.druid.pool.DruidDataSource
- driver-class-name: com.highgo.jdbc.Driver
-# url: jdbc:dm://localhost:5236/SYSDBA?rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
- url: jdbc:highgo://192.168.10.183:5866/highgo?rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
- username: sysdba
- password: Lmx&8688139
+ dynamic:
+ primary: master # 榛樿浣跨敤mater搴�
+ strict: false # 涓嶄娇鐢ㄤ弗鏍兼ā寮�
+ datasource:
+ master:
+ type: com.alibaba.druid.pool.DruidDataSource
+ driver-class-name: com.highgo.jdbc.Driver
+ # url: jdbc:dm://localhost:5236/SYSDBA?rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
+ url: jdbc:highgo://192.168.10.183:5866/highgo?rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
+ username: sysdba
+ password: Lmx&8688139
+ db2:
+ type: com.alibaba.druid.pool.DruidDataSource
+ driver-class-name: org.sqlite.JDBC
+ url: jdbc:sqlite:E:\2杞欢涓嬭浇鍖匼easydarwin\EasyDarwin-windows-8.2.2-24031216\data\db\EasyDarwin.db?date_string_format=yyyy-MM-dd HH:mm:ss
maxIdel: 60
initialPoolSize: 2
minPoolSize: 5
--
Gitblit v1.9.1