<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>
        <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName"><value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value></property>
        <property name="url"><value>jdbc:sqlserver://localhost:1433;DatabaseName=shilikaifa</value></property>
        <property name="username"><value>sa</value></property>
        <property name="password"><value>test</value></property>   
        </bean>
    <!--配置事务管理器--> 
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> 

   <property name="sessionFactory"><ref local="sessionFactory"/></property> 

</bean> 
<bean id="transactionProxyFactory" abstract="true" lazy-init="true" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"> 

    <property name="transactionManager"> 

         <ref local="transactionManager"/> 

    </property> 

    <property name="transactionAttributes"> 

         <props> 

          <prop key="save*">PROPAGATION_REQUIRED</prop> 

           <prop key="insert*">PROPAGATION_REQUIRED</prop> 

           <prop key="del*">PROPAGATION_REQUIRED</prop> 

           <prop key="add*">PROPAGATION_REQUIRED</prop> 

           <prop key="update*">PROPAGATION_REQUIRED</prop> 

           <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop> 

           <prop key="search*">PROPAGATION_REQUIRED,readOnly</prop> 

           <prop key="remove*">PROPAGATION_REQUIRED,readOnly</prop> 

           <prop key="query*">PROPAGATION_REQUIRED,readOnly</prop> 

           <prop key="list*">PROPAGATION_REQUIRED,readOnly</prop> 

           <prop key="count*">PROPAGATION_REQUIRED,readOnly</prop> 

           <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop> 

    </props> 

   </property> 

    </bean> 
    <bean id="hibernateInterceptor"
        class="org.springframework.orm.hibernate3.HibernateInterceptor">
        <property name="sessionFactory">
            <ref bean="sessionFactory" />
        </property>
    </bean>
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">
                    org.hibernate.dialect.SQLServerDialect  
                </prop>
                <!-- 表示允许自动提交 -->
                <prop key="hibernate.