通过hibernate配置连接oracle数据库

之前使用的是MySQL数据库，现在准备迁移到Oracle。

记录一下项目所使用的数据库配置

hibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>


    <session-factory>
     	<!-- 数据库方言 -->
    	<property name="dialect">
    		org.hibernate.dialect.Oracle9Dialect
    	</property>
    	<!-- 数据库驱动 -->
    	<property name="connection.driver_class">
    		oracle.jdbc.driver.OracleDriver
    	</property>
    	<!-- 数据库连接路径 -->
    	<property name="connection.url">
    		jdbc:oracle:thin:@localhost:1521:bookticket
    	</property>
    	<!-- 连接数据库用户名密码 -->
    	<property name="connection.username">orcl</property>
    	<property name="connection.password">orcl</property>
    	<!-- 其他配置 -->
    	<property name="show_sql">true</property>
    	<property name="hbm2ddl.auto">update</property>
    	<!-- 持久化类映射文件 -->
    	<mapping resource="com/bkt/bean/Admin.hbm.xml" />
    	<mapping resource="com/bkt/bean/Flight.hbm.xml" />
    	<mapping resource="com/bkt/bean/Orderlist.hbm.xml" />
    	<mapping resource="com/bkt/bean/User.hbm.xml" />
    	<mapping resource="com/bkt/bean/Shoppingcar.hbm.xml" />
    	 	
    </session-factory>


</hibernate-configuration>