玩转OceanBase |SpringJPA 连接示例

SpringJPA 连接 OceanBase 实战指南

最新推荐文章于 2025-07-01 15:43:29 发布

原创

最新推荐文章于 2025-07-01 15:43:29 发布 · 906 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oceanbase #spring #java

本文详细介绍了如何使用 SpringJPA 连接 OceanBase 数据库，并通过实例演示了自动建表、增删改查等操作。文中还提及了与 Oracle 性能的简单对比，表明 OceanBase 在 SpringJPA 支持上表现出色。

本文介绍 SpringJPA 连接示例，并测试几个常用功能，与 Oracle 进行简单的性能对比。

配置依赖

<dependency>
   <groupId>com.alipay.oceanbase</groupId>
   <artifactId>oceanbase-client</artifactId>
   <version>3.2.3</version>
</dependency>
<dependency>
   <groupId>org.springframework.data</groupId>
   <artifactId>spring-data-jpa</artifactId>
    <version>1.10.1.RELEASE</version>
</dependency>


<!--spring其他依赖，此处省略。。。。。。。。。-->

配置文件

applicationContext.xml 文件

内容如下：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx" xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:jpa="http://www.springframework.org/schema/data/jpa"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
         http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
         http://www.springframework.org/schema/context
         http://www.springframework.org/schema/context/spring-context-4.2.xsd
         http://www.springframework.org/schema/tx
         http://www.springframework.org/schema/tx/spring-tx-4.2.xsd
         http://www.springframework.org/schema/aop
         http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
         http://www.springframework.org/schema/mvc
         http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd
         http://www.springframework.org/schema/data/jpa
         http://www.springframework.org/schema/data/jpa/spring-jpa.xsd"
        >

    <!-- 开启IOC注解扫描 -->
    <context:component-scan base-package="com.bjyada.demo" />
    <!-- 开启MVC注解扫描 -->
    <mvc:annotation-driven />

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
          destroy-method="close">
        <!-- 连接信息 -->
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/&

最低0.47元/天解锁文章

新学期VIP享超值加赠