mybatis spring 整合

<mapper namespace="com.sm.dao.UserMapper"> </mapper>

namespace 与 UserMapper 一致

 

 <!-- 1. 数据源 : DriverManagerDataSource -->
    <bean id="dataSource" 
        class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
        
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/mybatis" />
        <property name="username" value="root" />
        <property name="password" value="tiger" />
        
    </bean>



    <!-- 2. mybatis的SqlSession的工厂: SqlSessionFactoryBean dataSource / typeAliasesPackage -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="typeAliasesPackage" value="com.sm.dao" />
    </bean>



     <!--  
     3. mybatis自动扫描加载Sql映射文件 : MapperScannerConfigurer sqlSessionFactory 
    -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.sm.dao" />
        <property name="sqlSessionFactory" ref="sqlSessionFactory" />
    </bean>



    <!-- 4. 事务管理 : DataSourceTransactionManager -->
    <bean id="transactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>
    
    <!-- 配置事务 
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="get*" read-only="true"/>
            <tx:method name="isValidate" read-only="true"/>
            <tx:method name="*"/>
        </tx:attributes>
    </tx:advice>
    
    
    <aop:config>
        <aop:pointcut expression="execution(* com.my.ssh.service.*.*(..))" id="pointCut"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointCut"/>
    </aop:config>
    -->

    <!-- 5. 使用声明式事务 -->
    <tx:annotation-driven transaction-manager="transactionManager" />

</beans>