Hibernate连接三种数据库的配置文件

<?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.driver_class" >

       com.mysql.jdbc.driver

     </property>

     <!-- 配置数据库连接url -->

     <property name= "connection.url" >

       jdbc:mysql: //localhost:3306/mysqldb

     </property>

     <!-- 数据库user -->

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

     <!-- 数据库user密码 -->

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

     <!-- 配置jdbc内置连接池 -->

     <property name= "connection.pool_size" > 1 </property>

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

     <property name= "dialect" >

       org.hibernate.dialect.mysqldialect

     </property>

     <!-- 输出运行时生成的sql语句 -->

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

     <!-- 配置对输出的sql语句进行格式化 -->

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

     <!-- 配置映射文件 -->

     <mapping resource= "com/model/user.hbm.xml" />

   </session-factory>

</hibernate-configuration>

<?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.driver_class" >

       oracle.jdbc.driver.oracledriver

     </property>

     <!-- 配置数据库的连接路径 -->

     <property name= "connection.url" >

       jdbc:oracle:thin: @127 .0. 0.1 : 1521 :dbsql

     </property>

     <!-- 配置数据库的连接用户名 -->

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

     <!-- 配置数据库的连接密码，密码为空时也可以省略该行配置代码 -->

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

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

     <property name= "dialect" >

       org.hibernate.dialect.oracledialect

     </property>

     <!-- 配置在控制台显示sql语句 -->

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

     <!-- 配置对输出的sql语句进行格式化 -->

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

     <!-- 配置在输出的sql语句前面添加提示信息 -->

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

     <!-- 配置持久化类映射文件 -->

     <mapping resource= "com/chen/entity/users.hbm.xml" />

   </session-factory>

</hibernate-configuration>

<?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>

    <!--配置数据库jdbc驱动-->

    <property name= "hibernate.connection.url" >jdbc:microsoft:sqlserver: //127.0.0.1:1433;databasename=db_manpower</property>

    <!--配置数据库连接url-->

    <property name= "hibernate.connection.driver_class" >com.microsoft.jdbc.sqlserver.sqlserverdriver</property>

    <!--配置数据库用户名-->

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

    <!--配置数据库密码-->

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

    <!--输出运行时生成的sql语句-->

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

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

    <property name= "hibernate.dialect" >org.hibernate.dialect.sqlserverdialect</property>

    <!--配置连接池个数-->

    <property name= "hibernate.jdbc.batch_size" > 16 </property>

    <!--列出映射文件-->

    <mapping resource= "com/chen/entity/users.hbm.xml" />

    </session-factory>

  </hibernate-configuration>