多数据源

whyclxw

2024-05-23 d97d9ec608862afc97143ed65331e50e0739a45f

多数据源

 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数据库连接池 安全版V4.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>

 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 {


 src/main/java/com/whyc/controller/EasyDarwinController.java

New file
@@ -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();
    }
}

 src/main/java/com/whyc/mapper/EasyDarwinMapper.java

New file
@@ -0,0 +1,6 @@
package com.whyc.mapper;

import com.whyc.pojo.EasyDarwin;

public interface EasyDarwinMapper extends CustomMapper<EasyDarwin>{
}

 src/main/java/com/whyc/pojo/EasyDarwin.java

New file
@@ -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;
}

 src/main/java/com/whyc/service/EasyDarwinService.java

New file
@@ -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,"获取摄像头转码信息");
    }



}

 src/main/resources/config/application-dev.yml

@@ -18,12 +18,21 @@
#数据库
spring:
  datasource:
    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