hibernate连接数据库配置

1.连接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> 

2.连接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> 

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>

4.hibernate各类工具包在官网下载即可