Hibernate 针对oracle数据库配置及MS SQL的数据库配置

Oracle:

<!-- 配置数据源 -->

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value=oracle.jdbc.driver.OracleDriver"></property>
<property name="jdbcUrl" value="jdbc:oracle:thin:@数据库服务器地址:端口:数据库名}"></property>
<property name="user" value="数据库用户"></property>

<property name="password" value="用户密码"></property>

</bean>

<!-- 配置sessionFactory -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"/><!-- 配置对应的数据源 -->
<property name="configLocation"> <!-- 加载Hibernate的配置文件 -->
<value>classpath:hibernate.cfg.xml</value>
</property>
</bean>

hibernate.cfg.xm:

<!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="show_sql">true</property>
<property name="hibernate.dialect">
org.hibernate.dialect.Oracle9Dialect
</property>
<property name="hbm2ddl.auto">update</property>
<mapping resource="org/doudouyota/vo/Goods.hbm.xml" />
</session-factory>
</hibernate-configuration>

  MS SQL数据库：

<hibernate-configuration>


<session-factory>
<property name="dialect">
org.hibernate.dialect.SQLServerDialect
</property>
<property name="connection.url">jdbc:sqlserver://localhost:1433;DatabaseName=bookstore</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property name="connection.driver_class">
com.microsoft.sqlserver.jdbc.SQLServerDriver
</property>
<property name="myeclipse.connection.profile">sqlserver</property>




<property name="show_sql">true</property>
<property name="format_sql">true</property>
<!-- POJO类的映射文件的配置 -->
<property name="hbm2ddl.auto">update</property>
<mapping resource="com/bookstore/model/Book.hbm.xml" />
<mapping resource="com/bookstore/model/Catalog.hbm.xml" />
<mapping resource="com/bookstore/model/Orderitem.hbm.xml" />
<mapping resource="com/bookstore/model/Orders.hbm.xml" />
<mapping resource="com/bookstore/model/User1.hbm.xml" />


</session-factory>


</hibernate-configuration>

用Hibernate生成表有两种方式：一种是在Hibernate配置文件hibernate.cfg.xml配置数据源时增加<property name="hbm2ddl.auto">update</property>

第二种是写映射类：

package com.bookstore.tool;


import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;


public class TestMapping {


/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub



Configuration configuration=new Configuration().configure();
if(configuration!=null){
System.out.println("TestMapping");
}
SchemaExport export=new SchemaExport(configuration);
export.create(true, false);
System.out.println("Hello TestMapping");

}


}