hibernate.cfg.xml文件连接mySql、Oracle、SqlServer配置

最新推荐文章于 2017-10-25 14:51:07 发布

饭小盒

最新推荐文章于 2017-10-25 14:51:07 发布

阅读量588

点赞数

分类专栏： hibernate.cfg.xml 文章标签： hibernate.cfg.xml

本文链接：https://blog.csdn.net/u011220908/article/details/48153619

版权

hibernate.cfg.xml 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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/mydata
</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">orcl</property>
<property name="connection.password">orcl</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://localhost:1433;databaseName=mydata</property>
<property name="connection.username">sa</property>
<property name="connection.password">123</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>