hibernate学习（一）hibernate.cfg.xml文件连接mySql、Oracle、SqlServer配置
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>
