Spring DAO with Jdbc and Hibernate

最新推荐文章于 2025-09-25 10:24:58 发布

原创最新推荐文章于 2025-09-25 10:24:58 发布 · 114 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#DAO #JDBC #Spring #Hibernate #Bean

SSH 专栏收录该内容

12 篇文章

订阅专栏

本文介绍了一种使用Spring框架进行快速DAO层开发的配置方法，包括数据源、JDBC模板、Hibernate模板及SessionFactory的配置，并提供了两种数据源实现方式。

<beans  xmlns="http://www.springframework.org/schema/beans" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns:aop="http://www.springframework.org/schema/aop" 
xmlns:tx="http://www.springframework.org/schema/tx" 
xmlns:context="http://www.springframework.org/schema/context" 
xmlns:jee="http://www.springframework.org/schema/jee"
xsi:schemaLocation=" 
	http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans-2.5.xsd  
	http://www.springframework.org/schema/context 
    http://www.springframework.org/schema/context/spring-context-2.5.xsd 
    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd  
    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
    http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd"> 
    
   <description>Quick DAO Start for Spring</description>
   
     <bean id="TestDAO" class="com.dao.TestDAO">
       <!--  <property name="jdbcTemplate" ref="jdbcTemplate"></property>-->
       <property name="hibernateTemplate" ref="hibernateTemplate"></property>
     </bean> 
     <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
       <property name="dataSource" ref="dataSource"></property>
     </bean>
 
     <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
       <property name="sessionFactory" ref="sessionFactory"></property>
     </bean>
     <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
       <property name="dataSource" ref="dataSource"></property>
       <property name="mappingResources">
         <list>
           <value>com/dao/Area.hbm.xml</value>
         </list>
       </property>
       <property name="hibernateProperties">
         <props>
           <prop key="hibernate.dialect">${hibernate.dialect}</prop>
         </props>
       </property>
     </bean>
     <!-- dataSource by DriverManagerDataSource-->
     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
       <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
       <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"></property>
       <property name="username" value="jil"></property>
       <property name="password" value="jil"></property>
     </bean> 
      <!-- dataSource by BasicDataSource -->
     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
	    <property name="driverClassName">
		  <value>oracle.jdbc.driver.OracleDriver</value>
	    </property>
	    <property name="url">
	      <value>jdbc:oracle:thin:@localhost:1521:orcl</value>
	    </property>
	    <property name="username">
	      <value>jil</value>
	    </property>
	    <property name="password">
	      <value>jil</value>
	    </property>
	    <property name="maxActive">
	      <value>10</value>
	    </property>
	    <property name="maxIdle">
	      <value>2</value>
	    </property>
	    <property name="maxWait">
	      <value>120000</value>
	    </property>
	    <property name="defaultAutoCommit">
	      <value>true</value>
	    </property>
    </bean>
   </beans>

The code is typed by the book Spring in Action II