Hibernate 连接MySQL和Oracle 配置文件编写

最新推荐文章于 2021-02-01 04:35:54 发布

liuhangsheng

最新推荐文章于 2021-02-01 04:35:54 发布

阅读量682

点赞数 1

分类专栏： Java popular framework

本文链接：https://blog.youkuaiyun.com/liuhangsheng/article/details/80473809

版权

Java popular framework 专栏收录该内容

8 篇文章

订阅专栏

(hibernate.cfg.xml)连接MySQL:

<?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="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost/hibernate</property>
        <property name="connection.username">root</property>
        <property name="connection.password">root</property>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>

         <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>

        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>

        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>

        <!-- Drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">update</property>
           <!--xml格式-->
        <mapping resource="com/cs/hibernate/Student.hbm.xml"/>
            <!--annotation-->

<mapping class="com.cs.hibernate.Teacher"/>
</session-factory>
</hibernate-configuration>

(hibernate.cfg.xml)连接Oracle:

<?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="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="connection.url">jdbc:oracle:thin:@localhost:1521:SXT</property>
        <property name="connection.username">scott</property>
        <property name="connection.password">llll</property>
      	<property name="dialect">org.hibernate.dialect.OracleDialect</property>
         <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>

        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>

        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>

        <!-- Drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">update</property>
           <!--xml格式-->
        <mapping resource="com/cs/hibernate/Student.hbm.xml"/>
            <!--annotation-->	 
<mapping class="com.cs.hibernate.Teacher"/>
</session-factory>
</hibernate-configuration>