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>
<!-- 方言 -->
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<!-- oracle驱动 -->
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<!-- JDBC URL -->
<property name="connection.url">jdbc:oracle:thin:@192.168.10.224:1521:MCSJT</property>
<!-- 数据库用户名-->
<property name="connection.username">MCS_JT</property>
<!-- 数据库密码-->
<property name="connection.password">MCS_JT</property>
<!-- 设置是否显示SQL语句-->
<property name="show_sql">true</property>
<!-- 设置是否格式化SQL语句 -->
<property name="format_sql">true</property>
<!-- 设置使用线程-->
<property name="current_session_context_class">thread</property>
<!-- <mapping resource="hibernate/vo/user.xml"/> -->
</session-factory>
</hibernate-configuration>
Pom.xml 引用的jar包
<!-- 添加Hibernate依赖 -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>3.6.10.Final</version>
</dependency>
<!-- 添加Log4J依赖 -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.16</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-nop</artifactId>
<version>1.6.4</version>
</dependency>
<!-- 添加javassist -->
<dependency>
<groupId>javassist</groupId>
<artifactId>javassist</artifactId>
<version>3.12.0.GA</version>
</dependency>
简单的测试demo
// 使用Hibernate的API来完成将Customer信息保存到mysql数据库中的操作
Configuration config = new Configuration().configure(); // Hibernate框架加载hibernate.cfg.xml文件
SessionFactory sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.openSession(); // 相当于得到一个Connection
// 开启事务
Transaction transaction = session.beginTransaction();
// 操作
// session.save(c);
Query query = session.createSQLQuery("select * from TR_CL_HPLX_JC");
List list = query.list();
System.out.println(list);
for (Object object : list) {
System.out.println(object);
}
// 事务提交
// session.getTransaction().commit();
transaction.commit();
session.close();
sessionFactory.close();
测试结果: