hibernate连接数据库配置详解

KLQ 2020-07-24 14:28:43 java常见问答 3796

之前给大家简单的介绍了一下什么是hibernate,那么下面要接着给大家介绍的就是hibernate连接数据库配置的内容,一起来详细的进行一下了解吧。

1、连接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.url">jdbc:oracle:thin:@127.0.0.1:1521:test</property>
        <property name="connection.username">sa</property>
        <property name="connection.password">sa123</property>
        <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver
        </property>
        <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
        <property name="show_sql">true</property>
    </session-factory>
</hibernate-configuration>

2、连接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.url"> 
            jdbc:mysql://localhost:3306/test 
        </property>
        <property name="connection.username">sa</property>
        <property name="connection.password">sa123</property>
        <property name="connection.driver_class">com.mysql.jdbc.Driver </property>
        <property name="dialect"> org.hibernate.dialect.MySQLDialect </property>
        <property name="show_sql">true</property>
    </session-factory>
</hibernate-configuration>

3、连接sqlServer

文件配置:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 5.0//EN"
    "http://www.hibernate.org/dtd/hibernate-configuration-5.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="connection.url">jdbc:sqlserver://127.0.0.1:1433;databaseName=test</property>
        <property name="connection.username">sa</property>
        <property name="connection.password">sa123</property>
        <property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
        <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
        <property name="show_sql">true</property>
        <mapping resource="com/hhl/entity/user.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

对于hibernate你还有什么想要了解的吗?请继续关注奇Q工具网吧,更多和hibernate相关知识以及java项目中常见问题可以为你分享解答。

推荐阅读:

怎么操作hibernate?Hibernate入门教程

mybatis和hibernate的区别是什么?有什么区别?

hibernate框架的使用,hibernate使用教程详解