hibernate学习（一）hibernate.cfg.xml文件连接mySql、Oracle、SqlServer配置

moneyZhong

1560人浏览 · 2013-01-15 20:19:16

moneyZhong · 2013-01-15 20:19:16 发布

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">root</property>
	<property name="connection.password">253503125</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:@192.168.7.248:1521:orcl</property>
	<property name="connection.username">liferay</property>
	<property name="connection.password">liferay</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 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
	<hibernate-configuration>
<session-factory>
	<property name="connection.url">jdbc:sqlserver://192.168.7.199:1433;databaseName=xycms</property>
	<property name="connection.username">sa</property>
	<property name="connection.password">123456</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>
</session-factory>
</hibernate-configuration>