SpringJPA connection example

<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>


<! --Other Spring dependencies, which are omitted here. . . . . . . . . -->

<?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"
        >

    <!-- Enable IOC annotation scan -->
    <context:component-scan base-package="com.bjyada.demo" />
    <!-- Enable MVC annotation scan -->
    <mvc:annotation-driven />

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
          destroy-method="close">
        <!-- Connection information -->
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>

        <!-- Connection Pooling Info -->
        <property name="maxActive" value="${dbcp.maxActive}"/>
        <property name="maxIdle" value="${dbcp.maxIdle}"/>
        <property name="defaultAutoCommit" value="true"/>
        <!-- Evict a session that has been idle for one hour -->
        <property name="timeBetweenEvictionRunsMillis" value="3600000"/>
        <property name="minEvictableIdleTimeMillis" value="3600000"/>
    </bean>

    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="systemPropertiesModeName" value="SYSTEM_PROPERTIES_MODE_OVERRIDE"/>
        <property name="ignoreResourceNotFound" value="true"/>
        <property name="locations">
            <list>
                <!-- External -->
                <!--<value>file:${user.dir}/dbcp.properties</value>-->
                <!-- Internal -->
                <value>classpath*:dbcp.properties</value>
            </list>
        </property>
    </bean>

    <!-- Configure JPA Entity Manager -->
    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="jpaVendorAdapter" ref="hibernateJpaVendorAdapter"/>
        <property name="packagesToScan" value="com.bjyada.demo.entity"/>
        <property name="persistenceUnitName" value="primary"/>
        <property name="jpaProperties">
            <props>
                <prop key="hibernate.ejb.naming_strategy">org.hibernate.cfg.ImprovedNamingStrategy</prop>
                <!-- Change update to none to prevent Hibernate from creating tables and
                automatically creating | updating | verifying the database table structure each time when Hibernate is loaded.
                validate: Verify the database table structure each time when Hibernate is loaded.
                create: Re-create the database table structure each time when Hibernate is loaded.
                create-drop: Create the database table structure each time when Hibernate is loaded and drop the database table structure each time when Hibernate exits.
                update: Update the database table structure each time when Hibernate is loaded.-->
                <prop key="hibernate.hbm2ddl.auto">update</prop>
                <prop key="hibernate.show_sql">false</prop>
                <prop key="hibernate.format_sql">false</prop>
                <prop key="hibernate.temp.use_jdbc_metadata_defaults">false</prop>
            </props>
        </property>
    </bean>

    <bean id="hibernateJpaVendorAdapter" class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
        <property name="database" value="${database.dialect}"/>
    </bean>

    <!-- Configure the transaction manager -->
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory" />
    </bean>

    <!-- Enable annotation transactions -->
    <tx:annotation-driven transaction-manager="transactionManager" />

    <!-- Configure the Spring Data JPA scan directory -->
    <jpa:repositories base-package="com.bjyada.demo" />
    <bean class="com.bjyada.demo.ExceptionHandler"></bean>
</beans>

#OceanBase Database
jdbc.driver=com.alipay.oceanbase.jdbc.Driver
jdbc.url=jdbc:oceanbase://10.100.xxx.xxx:18815/test
jdbc.username=admin
jdbc.password=******
database.dialect=MYSQL
dbcp.maxIdle=5
dbcp.maxActive=40
useUnicode=true&characterEncoding=utf-8

  <dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-data-jpa</artifactId>
      <version>****</version>
  </dependency>
  <dependency>
   <groupId>com.alipay.oceanbase</groupId>
   <artifactId>oceanbase-client</artifactId>
   <version>3.2.3</version>
  </dependency>
  <!-- The rest is omitted. -->

spring.datasource.url=jdbc:oceanbase://10.100.xxx.xxx:18815/test
spring.datasource.username=admin@mysql
spring.datasource.password=******
spring.datasource.driver-class-name=com.alipay.oceanbase.jdbc.Driver

spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true

public class User implements Serializable {
    private Integer id;
    private String username;
    //Comment out some fields first to verify that the table is automatically modified according to the new properties of the entity class after the table is created based on the framework.
    //private Date birthday;
    //private String sex;
    //private String address;
    //... . . . . . The constructor and the get and set methods are omitted here. . . . . . . .
}

public interface UserDao extends JpaRepository<User,Serializable>{
    User findById(Integer id);
}

@Test
    public void testInsert(){
        User user = new User();
        user.setId(1);
        user.setUsername("Test data");
        userDao.save(user);
    }

@Test
    public void testAlert(){
        User user = new User();
        user.setId(1);
        user.setUsername("Test data");
        user.setAddress("Beijing");
        user.setSex("Male");
        user.setBirthday(new Date());
        userDao.save(user);
    }

@Test
    public void testInsert(){
        List<User> list = new ArrayList<User>();
        list.add(new User(3,"asd", new Date(), "Male", "Zhangzhou"));
        list.add(new User(4,"qwe", new Date(), "Female", "Hangzhou"));
        list.add(new User(5,"zxc", new Date(), "Male", "Shanghai"));
        list.add(new User(6,"xcv", new Date(), "Female", "Hangzhou"));
        list.add(new User(7,"sdf", new Date(), "Male", "Hangzhou"));
        list.add(new User(8,"wer", new Date(), "Female", "Hangzhou"));
        list.add(new User(9,"ert", new Date(), "Male", "Zhangzhou"));
        list.add(new User(10,"rty", new Date(), "Female", "Shanghai"));
        list.add(new User(11,"tyu", new Date(), "Male", "Hangzhou"));

        list.forEach(s -> userDao.save(s));
    }

@Test
    public void testFindOne(){
        Table_Test one = table_testDao.findOne("aaa");
        System.out.println(one);
    }

@Test
    public void testDelete(){
        table_testDao.delete("9998");
    }

    @Test
    public void test6(){
        Table_Test a = new Table_Test();
        a.setChar_test("9997");
        table_testDao.delete(a);
    }

@Test
    public void testChange(){
        Table_Test one = table_testDao.findOne("9996");
        System.out.println("Before modification: "+one);
        one.setVarchar2_test("Modified");
        one.setNchar_test("Modified");
        table_testDao.save(one);
        one = table_testDao.findOne("9996");
        System.out.println("After modification: "+one);
    }

@Test
    public void testFindAll(){
        List<User> all = userDao.findAll();
        all.forEach(System.out::println);
    }