本文介绍 Hibernate 连接示例,并测试几个常用功能。
配置依赖
<dependency>
<groupId>com.alipay.oceanbase</groupId>
<artifactId>oceanbase-client</artifactId>
<version>3.2.3</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>5.0.7.Final</version>
</dependency>
hibernate.cfg.xml 文件
内容如下:
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!--oceanbase连接信息-->
<property name="connection.driver_class">com.alipay.oceanbase.jdbc.Driver</property>
<property name="connection.url">jdbc:oceanbase://10.100.xxx.xxx:18815/test</property>
<property name="connection.username">admin</property>
<property name="connection.password">admin</property>
<!-- 可选配置 -->
<!--是否支持方言,以下MySQLMode和OracleMode视数据库模式情况配置-->
<!--MySQLMode-->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!--OracleMode-->
<property name="dialect">org.hibernate.dialect.Oracle12cDialect</property>
<!--执行CURD时是否打印sql 语句 -->
<property name="show_sql">true</property>
<!--自动建表(修改表)-->
<!--<property name="hbm2ddl.auto">update</property>-->
<!--<property name="hbm2ddl.auto">create</property>-->
<!-- 资源注册 (实体类映射文件)-->
<mapping resource="./UserModel.hbm.xml"/>
</session-factory>
</hibernate-configuration>
测试准备
实体类
public class User imple