springboot集成oceanbase

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:Jaroceanbase-client-1.1.7.jar

3.引入依赖

 

        
            org.springframework.boot
            spring-boot-starter-web
            
        

        
            com.alipay.oceanbase
            oceanbase-client
            1.1.7
        

        
            com.google.guava
            guava
            
            18.0
        

        
            org.projectlombok
            lombok
        

        
            org.springframework.boot
            spring-boot-starter-test
            test
        
        
            com.google.code.gson
            gson
            2.8.2
        

        
            org.springframework.boot
            spring-boot-starter-data-jpa
        

    

配置文件:

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 {

}

controller:

@RestController
public class JDBCTest {

    @Autowired
    private TestOceanbaseDao testOceanbaseDao;

    @RequestMapping("/test")
    public List ListOceanbase(){
        return testOceanbaseDao.findAll();
    }
}

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

数据正常: