hibernate于各大数据库的连接

  一、Hibernate与mysql的连接

<!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="hibernate.connection.driver_class">

           com.mysql.jdbc.Driver

       </property>

       <!-- 配置数据的连接字符串 -->

       <property name="hibernate.connection.url">

           jdbc:mysql://localhost:3306/crma?useUnicode=true&CharsetEncode=utf8

       </property>

       <!-- 用户名 -->

       <property name="hibernate.connection.username">root</property>

       <!-- 密码 -->

       <property name="hibernate.connection.password">fendou</property>

       <!-- 配置数据库的方言 -->

       <property name="hibernate.dialect">

           org.hibernate.dialect.MySQLDialect

       </property>

       <!-- 表存在不创建，不存在就创建 

           当中的属性有 update、delete

           <property name="hibernate.hbm2ddl.auto">update</property>

       -->

       <property name="hibernate.query.substitutions">

           true 1,false 0

       </property>

       <!-- 显示SQL -->

       <property name="show_sql">true</property>

</session-factory>

</hibernate-configuration>

二、sqlServer2000连接hibernate 

<?xml version="1.0" encoding="utf-8" ?>

<!DOCTYPE hibernate-configuration

PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"

"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<hibernate-configuration>

    <session-factory name="java:/hibernate/HibernateFactory">

       <property name="show_sql">true</property>

       <property name="connection.driver_class">

           com.jnetdirect.jsql.JSQLDriver

       </property>

       <property name="connection.url">

           jdbc:JSQLConnect://localhost:1433;database=shopping;

       </property>

       <property name="connection.username">sa</property>

       <property name="connection.password"></property>

       <property name="dialect">

           net.sf.hibernate.dialect.SQLServerDialect

       </property>

       <mapping resource="Customer.hbm.xml" />

    </session-factory>

</hibernate-configuration>

三、hibernate连接oracle

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE hibernate-configuration

          PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"

          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

  <session-factory>

    <!--指定连接数据库用的驱动-->

    <property name="connection.driver_class">

    oracle.jdbc.driver.OracleDriver

    </property>

    <!--指定连接数据库的路径-->

    <property name="connection.url">

    jdbc:oracle:thin:@localhost:1521:db_database02

    </property>

    <!--指定连接数据库的用户名-->

    <property name="connection.username">SYSTEM</property>

    <property name="connection.password">SYSTEM</property><!--指定连接数据库的密码-->

    <!--指定数据库使用的SQL方言-->

    <property name="dialect">

    org.hibernate.dialect.Oracle9Dialect

    </property>

<!--当show_sql属性为true时表示在程序运行时在控制台输出SQL语句，默认为false，建议在调试程序时设为true，发布程序之前再改为false,因为输出SQL语句会影响程序的运行速度-->

    <property name="show_sql">true</property>

    <mapping resource="UserForm.hbm.xml"/><!--指定持久化类映射文件-->

  </session-factory>

</hibernate-configuration>