增加支持sqlite

xieb

2024-04-10 6d5c27ead8a5911cfd604278ae4932655e6dc9df

增加支持sqlite

 pom.xml

@@ -46,11 +46,22 @@
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <dependency>
            <groupId>org.xerial</groupId>
            <artifactId>sqlite-jdbc</artifactId>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>

 src/main/java/com/dji/sample/territory/controller/TbDkjbxxController.java

New file
@@ -0,0 +1,37 @@
package com.dji.sample.territory.controller;

import com.dji.sample.common.model.PaginationData;
import com.dji.sample.common.model.ResponseResult;
import com.dji.sample.log.model.entity.DroneFlightLogEntity;
import com.dji.sample.territory.model.entity.TbDkjbxxEntity;
import com.dji.sample.territory.service.ITbDkjbxxService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @PROJECT_NAME: drone
 * @DESCRIPTION:
 * @USER: aix
 * @DATE: 2024/4/10 11:20
 */
@RestController
@Slf4j
@RequestMapping("/territory/tbdkjbxx")
public class TbDkjbxxController {

    @Autowired
    private ITbDkjbxxService tbDkjbxxService;

    @GetMapping("/list")
    public ResponseResult list() {
        List<TbDkjbxxEntity> list = tbDkjbxxService.list();
        return ResponseResult.success(list);
    }

}

 src/main/java/com/dji/sample/territory/dao/ITbDkjbxxMapper.java

New file
@@ -0,0 +1,13 @@
package com.dji.sample.territory.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dji.sample.territory.model.entity.TbDkjbxxEntity;

/**
 * @PROJECT_NAME: drone
 * @DESCRIPTION:
 * @USER: aix
 * @DATE: 2024/4/10 11:18
 */
public interface ITbDkjbxxMapper extends BaseMapper<TbDkjbxxEntity> {
}

 src/main/java/com/dji/sample/territory/model/entity/TbDkjbxxEntity.java

New file
@@ -0,0 +1,29 @@
package com.dji.sample.territory.model.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @PROJECT_NAME: drone
 * @DESCRIPTION:
 * @USER: aix
 * @DATE: 2024/4/10 11:14
 */
@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
@TableName(value = "DKJBXX")
public class TbDkjbxxEntity {

    @TableId(type = IdType.NONE)
    private String bsm;

    private String dklx;

}

 src/main/java/com/dji/sample/territory/service/ITbDkjbxxService.java

New file
@@ -0,0 +1,13 @@
package com.dji.sample.territory.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.dji.sample.territory.model.entity.TbDkjbxxEntity;

/**
 * @PROJECT_NAME: drone
 * @DESCRIPTION:
 * @USER: aix
 * @DATE: 2024/4/10 11:19
 */
public interface ITbDkjbxxService extends IService<TbDkjbxxEntity> {
}

 src/main/java/com/dji/sample/territory/service/impl/TbDkjbxxServiceImpl.java

New file
@@ -0,0 +1,19 @@
package com.dji.sample.territory.service.impl;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.dji.sample.territory.dao.ITbDkjbxxMapper;
import com.dji.sample.territory.model.entity.TbDkjbxxEntity;
import com.dji.sample.territory.service.ITbDkjbxxService;
import org.springframework.stereotype.Service;

/**
 * @PROJECT_NAME: drone
 * @DESCRIPTION:
 * @USER: aix
 * @DATE: 2024/4/10 11:19
 */
@Service
@DS("sqlite")
public class TbDkjbxxServiceImpl extends ServiceImpl<ITbDkjbxxMapper, TbDkjbxxEntity> implements ITbDkjbxxService {
}

 src/main/resources/application-dev.yml

@@ -1,9 +1,22 @@
#spring
spring:
  datasource:
    url: jdbc:mysql://182.108.40.114:3308/drone_zt_test?useSSL=false&allowPublicKeyRetrieval=true
    username: root
    password: yshb@123
    #使用阿里的Druid
    type: com.alibaba.druid.pool.DruidDataSource
    dynamic:
      primary: master #设置默认的数据源或者数据源组,默认值即为master
      strict: false #严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源
      datasource:
        master:
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://182.108.40.114:3308/drone_zt_test?useSSL=false&allowPublicKeyRetrieval=true
          username: root
          password: yshb@123
        sqlite:
          driver-class-name: org.sqlite.JDBC
          url: jdbc:sqlite::resource:static/sqlite/resource_db.db
          username:
          password:
#    url: jdbc:mysql://192.168.2.104:3306/drone_test?useSSL=false&allowPublicKeyRetrieval=true
#    username: root
#    password: 123456

 src/main/resources/static/sqlite/resource_db.db

Binary files differ