第一种在Spring applicationContext.xml中连接：
Java代码
1 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
2 <property name="driverClassName">
3 <value>oracle.jdbc.driver.OracleDriver</value>
4 </property>
5 <property name="url">
6 <value>jdbc:oracle:thin:@localhost:1521:ylj</value>
7 </property>
8 <property name="username">
9 <value>cpiclh</value>
10 </property>
11 <property name="password">
12 <value>cpiclh</value>
13 </property>
14 </bean>
15
16 <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
17 <property name="dataSource">
18 <ref local="dataSource" />
19 </property>
20 <property name="mappingResources">
21 <list>
22 <value>com/Hibernate/Pojo/FactUsers.hbm.xml</value>
23 </list>
24 </property>
25 <property name="hibernateProperties">
26 <props>
27 <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
28 <prop key="hibernate.show_sql">true</prop>
29 </props>
30 </property>
31 </bean>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName"> <value>oracle.jdbc.driver.OracleDriver</value> </property> <property name="url"> <value>jdbc:oracle:thin:@localhost:1521:ylj</value> </property> <property name="username"> <value>cpiclh</value> </property> <property name="password"> <value>cpiclh</value> </property> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource"> <ref local="dataSource" /> </property> <property name="mappingResources"> <list> <value>com/Hibernate/Pojo/FactUsers.hbm.xml</value> </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean>

第二种在Hibernate hibernate.cfg.xml中连接：
Java代码
32 <session-factory>
33 <property name="connection.username">root</property>
34 <property name="connection.url">
35 jdbc:oracle:thin:@192.168.0.1:1521:ylj
36 </property>
37 <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
38
39 <property name="connection.password">root</property>
40 <property name="connection.driver_class">
41 oracle.jdbc.driver.OracleDriver
42 </property>
43 <mapping resource="com/hibernate/pojo/FactUsers.hbm.xml" />
44 </session-factory>
<session-factory> <property name="connection.username">root</property> <property name="connection.url"> jdbc:oracle:thin:@192.168.0.1:1521:ylj </property> <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property> <property name="connection.password">root</property> <property name="connection.driver_class"> oracle.jdbc.driver.OracleDriver </property> <mapping resource="com/hibernate/pojo/FactUsers.hbm.xml" /> </session-factory>

第三种在Tomcat中的 apache-tomcat-5.5.17\conf\Catalina目录下放一个
和目录同名的XML，内容如下
Java代码
45 <Context path="" docBase="ROOT">
46 <Resource name="jdbc/db" auth="Container" type="javax.sql.DataSource" removeAbandoned="true" removeAbandonedTimeout="60"
47 username="root" password="root" driverClassName="oracle.jdbc.driver.OracleDriver"
48 url="jdbc:oracle:thin:@192.168.0.1:1521:ylj"/>
49 </Context>