<bean id="propertyHoder" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>/WEB-INF/classes/jdbc.properties</value>
</list>
</property>
</bean>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="username">
<value>${username}</value>
</property>
<property name="password">
<value>${password}</value>
</property>
<property name="url">
<value>${url}</value>
</property>
<property name="driverClassName">
<value>${driverClassName}</value>
</property>
</bean>
<bean id="sf" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/User.hbm.xml</value>
</list>
</property>
</bean>
<bean id="template" class="org.springframework.orm.hibernate3.HibernateTemplate">
<property name="sessionFactory">
<ref local="sf"/>
</property>
</bean>
<bean id="userDAO" class="com.tarena.UserDaoImpl">
<property name="template">
<ref local="template"/>
</property>
</bean>
<!-- transaction -->
<bean id="userBiz" class="com.tarena.UserBizImpl">
<property name="userDAO">
<ref local="userDAO"/>
</property>
</bean>