spring boot3 + mybatis-plus3 + GaussDB集成过程

简述

1. Spring Boot
   简化了Spring应用的开发流程，提高了开发效率，是Java开发者在快速应用开发领域的一个有力工
2. Mybatis-Plus
   MyBatis-Plus 是一个 MyBatis 的增强工具，在 MyBatis 的基础上只做增强不做改变，为简化开发、提高效率而生。官网地址：https://baomidou.com/introduce
3. GaussDB
   GaussDB是基于华为20余年战略投入、软硬全栈协同所创新研发的分布式关系型数据库，具备高可用、高性能、高安全、高弹性、高智能、易部署、易迁移等关键能力，是企业核心业务数字化转型升级的坚实数据底座。

驱动下载

• GaussDB驱动下载：https://support.huaweicloud.com/centralized-devg-v8-gaussdb/gaussdb-42-1836.html
  解压驱动得到

wmwei@DESKTOP-7490 MINGW64 /d/huawei/software/GaussDB_driver/Centralized/Euler2.5_X86_64
$ tar -xzf GaussDB-Kernel_505.2.0_Euler_64bit_Jdbc.tar.gz
wmwei@DESKTOP-7490 MINGW64 /d/huawei/software/GaussDB_driver/Centralized/Euler2.5_X86_64
$ ls *.jar
gaussdbjdbc-JRE7.jar  gscejdbc.jar   gsjdbc4.jar
gaussdbjdbc.jar       gsjdbc200.jar  opengaussjdbc.jar

本文使用gaussdbjdbc.jar驱动包

pom.xml配置

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>3.4.0</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.example</groupId>
	<artifactId>demo</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>demo</name>
	<description>Demo project for Spring Boot</description>
	<properties>
		<java.version>17</java.version>
	</properties>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-spring-boot3-starter</artifactId>
			<version>3.5.9</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>com.huawei.gaussdb</groupId>
			<artifactId>gaussdbjdbc</artifactId>
			<version>5.0.0-htrunk4.csi.gaussdb_kernel.opengaussjdbc.r2</version>
			<scope>system</scope>
			<systemPath>${pom.basedir}/src/main/resources/lib/gaussdbjdbc.jar</systemPath>
		</dependency>
	</dependencies>

	<build>

		<plugins>
       <plugin>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-maven-plugin</artifactId>
			<configuration>
				<!-- 构建时包含本地jar -->
				<includeSystemScope>true</includeSystemScope>
			</configuration>
		  </plugin>
		</plugins>
	</build>

</project>

application.yaml配置

server:
  port: 8080

spring:
  application:
    name: demo
  datasource:
    url: jdbc:gaussdb://localhost:8000/test
    username: postgres
    password: postgres
    driver-class-name: com.huawei.gaussdb.jdbc.Driver
    hikari:
      schema: public
mybatis-plus:
  global-config:
    db-config:
      id-type: auto
  type-aliases-package: com.example.demo.domain

扩展

• 本文DEMO地址：https://gitcode.com/weiwenman/springboot3-mybatis-plus3-gaussdb-demo/overview
• 本文博客地址：https://bbs.huaweicloud.com/blogs/441511