springboot集成oceanbase

m0_49503341

已于 2022-06-24 15:19:46 修改

阅读量1.1w

点赞数 1

文章标签： springboot

于 2022-03-23 15:43:16 首次发布

本文链接：https://blog.youkuaiyun.com/m0_49503341/article/details/123687313

版权

本文档介绍了如何将Oceanbase数据库客户端1.1.7.jar集成到Spring Boot项目中，包括下载jar包、添加至本地Maven仓库、配置数据源，并通过JPA实现数据操作。示例展示了实体类、DAO层和Controller层的代码，实现了数据的正常读取。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.下载oceanbase-client-1.1.7.jar

这个是jar包下载地址

https://oceanbase-aliyun-docs.oss-cn-hangzhou.aliyuncs.com/downloads/obclient/oceanbase-client-1.1.7.jar?spm=a2c4g.11186623.2.4.2f6b535fe9lVxX&file=oceanbase-client-1.1.7.jar

2.把jar包放入本地仓库(maven要装环境变量)

mvn install:install-file -DgroupId=com.alipay.oceanbase -DartifactId=oceanbase-client -Dversion=1.1.7
-Dpackaging=jar -Dfile=E:\Jar\oceanbase-client-1.1.7.jar

3.引入依赖

 <dependencies>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <!--<exclusions>
                <exclusion>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-starter-tomcat</artifactId>
                </exclusion>
            </exclusions>-->
        </dependency>

        <dependency>
            <groupId>com.alipay.oceanbase</groupId>
            <artifactId>oceanbase-client</artifactId>
            <version>1.1.7</version>
        </dependency>

        <dependency>
            <groupId>com.google.guava</groupId>
            <artifactId>guava</artifactId>
            <!--推荐版本18，经过测试14~18都可以-->
            <version>18.0</version>
        </dependency>

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

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>com.google.code.gson</groupId>
            <artifactId>gson</artifactId>
            <version>2.8.2</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

    </dependencies>

配置文件:

server:
  port: 3333
spring:
  datasource:
    driver-class-name: com.alipay.oceanbase.jdbc.Driver
    url: jdbc:oceanbase://***:2883/test
    username: ***
    password: ***
  jpa:
    hibernate:
      ddl-auto: update # 新增数据库链接必须的参数
    # 控制台显示SQL
    show-sql: true
    properties:
      hibernate.format_sql: true

实体:

import lombok.Data;

import javax.persistence.*;

@Entity
@Table(name = "test_oceanbase")
@Data
public class TestOceanbase {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    private String old;


}

dao层:

import com.wise.oceanbase.entity.TestOceanbase;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface TestOceanbaseDao extends JpaRepository<TestOceanbase, Long> {

}

controller:

@RestController
public class JDBCTest {

    @Autowired
    private TestOceanbaseDao testOceanbaseDao;

    @RequestMapping("/test")
    public List<TestOceanbase> ListOceanBase(){
        return testOceanbaseDao.findAll();
    }
}

因为只是测试所以直接引用的dao层

数据正常: