From 6d5c27ead8a5911cfd604278ae4932655e6dc9df Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Wed, 10 Apr 2024 11:30:25 +0800
Subject: [PATCH] 增加支持sqlite
---
src/main/java/com/dji/sample/territory/service/ITbDkjbxxService.java | 13 ++++
src/main/resources/static/sqlite/resource_db.db | 0
src/main/java/com/dji/sample/territory/dao/ITbDkjbxxMapper.java | 13 ++++
src/main/java/com/dji/sample/territory/service/impl/TbDkjbxxServiceImpl.java | 19 ++++++
src/main/java/com/dji/sample/territory/controller/TbDkjbxxController.java | 37 ++++++++++++
src/main/java/com/dji/sample/territory/model/entity/TbDkjbxxEntity.java | 29 +++++++++
src/main/resources/application-dev.yml | 19 +++++-
pom.xml | 11 +++
8 files changed, 138 insertions(+), 3 deletions(-)
diff --git a/pom.xml b/pom.xml
index 8de2509..9f34ed1 100644
--- a/pom.xml
+++ b/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>
diff --git a/src/main/java/com/dji/sample/territory/controller/TbDkjbxxController.java b/src/main/java/com/dji/sample/territory/controller/TbDkjbxxController.java
new file mode 100644
index 0000000..2ba53ae
--- /dev/null
+++ b/src/main/java/com/dji/sample/territory/controller/TbDkjbxxController.java
@@ -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);
+ }
+
+}
diff --git a/src/main/java/com/dji/sample/territory/dao/ITbDkjbxxMapper.java b/src/main/java/com/dji/sample/territory/dao/ITbDkjbxxMapper.java
new file mode 100644
index 0000000..6ed5c85
--- /dev/null
+++ b/src/main/java/com/dji/sample/territory/dao/ITbDkjbxxMapper.java
@@ -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> {
+}
diff --git a/src/main/java/com/dji/sample/territory/model/entity/TbDkjbxxEntity.java b/src/main/java/com/dji/sample/territory/model/entity/TbDkjbxxEntity.java
new file mode 100644
index 0000000..7cc2fe1
--- /dev/null
+++ b/src/main/java/com/dji/sample/territory/model/entity/TbDkjbxxEntity.java
@@ -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;
+
+}
diff --git a/src/main/java/com/dji/sample/territory/service/ITbDkjbxxService.java b/src/main/java/com/dji/sample/territory/service/ITbDkjbxxService.java
new file mode 100644
index 0000000..30b5e52
--- /dev/null
+++ b/src/main/java/com/dji/sample/territory/service/ITbDkjbxxService.java
@@ -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> {
+}
diff --git a/src/main/java/com/dji/sample/territory/service/impl/TbDkjbxxServiceImpl.java b/src/main/java/com/dji/sample/territory/service/impl/TbDkjbxxServiceImpl.java
new file mode 100644
index 0000000..cd5a273
--- /dev/null
+++ b/src/main/java/com/dji/sample/territory/service/impl/TbDkjbxxServiceImpl.java
@@ -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 {
+}
diff --git a/src/main/resources/application-dev.yml b/src/main/resources/application-dev.yml
index e0f869b..b86d9c3 100644
--- a/src/main/resources/application-dev.yml
+++ b/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
diff --git a/src/main/resources/static/sqlite/resource_db.db b/src/main/resources/static/sqlite/resource_db.db
new file mode 100644
index 0000000..af4ba36
--- /dev/null
+++ b/src/main/resources/static/sqlite/resource_db.db
Binary files differ
--
Gitblit v1.9.3