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各類工具包在官網下載即可

原文地址https://blog.csdn.net/urey12138/article/details/81239114

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/news/451088.shtml
繁體地址，請注明出處：http://hk.pswp.cn/news/451088.shtml
英文地址，請注明出處：http://en.pswp.cn/news/451088.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！