From d1851ded02d6f253ed2ca1459c4e514102c975d5 Mon Sep 17 00:00:00 2001
From: 吴健 <14790700720@163.com>
Date: 星期六, 16 十一月 2024 10:09:49 +0800
Subject: [PATCH] add sql
---
billion-generator/src/main/java/com/billion/generator/controller/GenController.java | 4 ++++
billion-admin/src/main/resources/application-druid.yml | 12 ++++++------
billion-main/src/main/java/com/billion/main/bs/workshop/service/impl/BsWorkshopServiceImpl.java | 3 +++
3 files changed, 13 insertions(+), 6 deletions(-)
diff --git a/billion-admin/src/main/resources/application-druid.yml b/billion-admin/src/main/resources/application-druid.yml
index bce35d0..18bb86d 100644
--- a/billion-admin/src/main/resources/application-druid.yml
+++ b/billion-admin/src/main/resources/application-druid.yml
@@ -6,16 +6,16 @@
druid:
# 涓诲簱鏁版嵁婧�
master:
- url: jdbc:mysql://127.0.0.1:3306/billion-db?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
+ url: jdbc:mysql://192.168.0.189:3306/billion-db-base?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
username: root
- password: root
+ password: 123456
# 浠庡簱鏁版嵁婧�
slave:
# 浠庢暟鎹簮寮�鍏�/榛樿鍏抽棴
- enabled: false
- url:
- username:
- password:
+ enabled: true
+ url: jdbc:mysql://192.168.0.189:3306/billion-db-self?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
+ username: root
+ password: 123456
# 鍒濆杩炴帴鏁�
initialSize: 5
# 鏈�灏忚繛鎺ユ睜鏁伴噺
diff --git a/billion-generator/src/main/java/com/billion/generator/controller/GenController.java b/billion-generator/src/main/java/com/billion/generator/controller/GenController.java
index 164a57b..cbf2afc 100644
--- a/billion-generator/src/main/java/com/billion/generator/controller/GenController.java
+++ b/billion-generator/src/main/java/com/billion/generator/controller/GenController.java
@@ -6,6 +6,9 @@
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletResponse;
+
+import com.billion.common.annotation.DataSource;
+import com.billion.common.enums.DataSourceType;
import org.apache.commons.io.IOUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
@@ -84,6 +87,7 @@
*/
@PreAuthorize("@ss.hasPermi('tool:gen:list')")
@GetMapping("/db/list")
+ @DataSource(value = DataSourceType.SLAVE)
public TableDataInfo dataList(GenTable genTable)
{
startPage();
diff --git a/billion-main/src/main/java/com/billion/main/bs/workshop/service/impl/BsWorkshopServiceImpl.java b/billion-main/src/main/java/com/billion/main/bs/workshop/service/impl/BsWorkshopServiceImpl.java
index 8e4c028..1c2b28c 100644
--- a/billion-main/src/main/java/com/billion/main/bs/workshop/service/impl/BsWorkshopServiceImpl.java
+++ b/billion-main/src/main/java/com/billion/main/bs/workshop/service/impl/BsWorkshopServiceImpl.java
@@ -3,6 +3,8 @@
import java.util.List;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.billion.common.annotation.DataSource;
+import com.billion.common.enums.DataSourceType;
import com.billion.common.utils.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -17,6 +19,7 @@
* @date 2024-11-12
*/
@Service
+@DataSource(value = DataSourceType.SLAVE)
public class BsWorkshopServiceImpl extends ServiceImpl<BsWorkshopMapper, BsWorkshop> implements IBsWorkshopService
{
@Autowired
--
Gitblit v1.9.3