Hibernate与Spring整合，配置文件applicationContext.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans>
 <!-- **************************************配置数据库*************************************** -->
 <!-- 配置数据库 ，oracle为name="driverClassName" value="oracle.jdbc.driver.OracleDriver" -->
 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  <property name="url" value="jdbc:mysql://localhost:3306/jia" />
  <property name="username" value="root" />
  <property name="password" value="root" />
  <property name="maxWait" value="3000"></property>
  <property name="validationQuery" value="select count(*) from dual"></property>
 </bean>

 <!-- **********************注入SessionFactory,完成Hibernate与Spring的整合********************** -->
 <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource">
   <ref bean="dataSource" />
  </property>
  <property name="mappingResources">
   <list>
    <value>mapper/Worker.hbm.xml</value>
    <value>mapper/Role.hbm.xml</value>
    <value>mapper/Rights.hbm.xml</value>
    <value>mapper/CustomLevel.hbm.xml</value>
    <value>mapper/CustomServiceType.hbm.xml</value>
    <value>mapper/Area.hbm.xml</value>
    <value>mapper/ProductInfo.hbm.xml</value>
    <value>mapper/Stock.hbm.xml</value>
    <value>mapper/MarketChance.hbm.xml</value>
    <value>mapper/DevelopPlan.hbm.xml</value>
    <value>mapper/CustomLost.hbm.xml</value>
    <value>mapper/ServiceManage.hbm.xml</value>
    <value>mapper/CustomInfo.hbm.xml</value>
    <value>mapper/PleasedCredit.hbm.xml</value>
    <value>mapper/LinkMan.hbm.xml</value>
    <value>mapper/ConstactNote.hbm.xml</value>
    <value>mapper/CustomOrder.hbm.xml</value>
   </list>
  </property>
     <!-- ********************配置方言******************** -->
  <property name="hibernateProperties">
   <props>
    <!-- 表示允许自动提交，一般不使用自动提交 -->
    <!--<prop key="hibernate.connection.autocommit">true</prop> -->
    <prop key="hibernate.show_sql">true</prop>
    <!-- 当创建SessionFactory时，是否根据映射文件自动建立数据库表 -->
    <prop key="hibernate.hbm2ddl.auto">update</prop>
    <!-- oracle的为org.hibernate.dialect.Oracle9Dialect -->
    <prop key="hibernate.dialect">
     org.hibernate.dialect.MySQL5InnoDBDialect
    </prop>
   </props>
  </property>
 </bean>

 <!-- *****************************************登录***************************************** -->
 <bean id="loginDao" class="crm.dao.impl.LoginDaoImpl">
  <property name="sessionFactory">
   <ref bean="sessionFactory" />
  </property>
 </bean>
 <bean id="loginService" class="crm.service.impl.LoginServiceImpl">
  <property name="loginDao">
   <ref bean="loginDao" />
  </property>
 </bean>
 <bean id="LoginAction" class="crm.action.LoginAction" scope="prototype">
  <property name="loginService">
   <ref bean="loginService" />
  </property>
 </bean>

 <!-- ****************************************分页模板**************************************** -->
 <bean id="queryByPageDao" class="crm.dao.impl.QueryByPageDaoImpl">
  <property name="sessionFactory">
   <ref bean="sessionFactory" />
  </property>
 </bean>
 <bean id="queryByPageService" class="crm.service.impl.QueryByPageServiceImpl">
  <property name="queryByPageDao">
   <ref bean="queryByPageDao" />
  </property>
 </bean>

 <!-- ****************************************营销管理 **************************************** -->
 <bean id="marketChanceDao" class="crm.dao.impl.MarketChanceDaoImpl">
  <property name="sessionFactory">
   <ref bean="sessionFactory" />
  </property>
 </bean>
 <bean id="marketChanceService" class="crm.service.impl.MarketChanceServiceImpl">
  <property name="marketChanceDao">
   <ref bean="marketChanceDao" />
  </property>
 </bean>
 <bean id="MarketChanceAction" class="crm.action.MarketChanceAction"
  scope="prototype">
  <property name="marketChanceService">
   <ref bean="marketChanceService" />
  </property>
  <property name="queryByPageService">
   <ref bean="queryByPageService" />
  </property>
 </bean>
</beans>