基于 XML

application.xml

  1. <beans xmlns="http://www.springframework.org/schema/beans"
  2. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3. xmlns:aop="http://www.springframework.org/schema/aop"
  4. xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
  5. xsi:schemaLocation="http://www.springframework.org/schema/beans
  6. https://www.springframework.org/schema/beans/spring-beans.xsd
  7. http://www.springframework.org/schema/aop
  8. https://www.springframework.org/schema/aop/spring-aop.xsd
  9. http://www.springframework.org/schema/tx
  10. http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/context
  11. https://www.springframework.org/schema/context/spring-context.xsd">
  12. <context:component-scan base-package="cn.lichenghao.tx"></context:component-scan>
  13. <bean class="org.springframework.jdbc.datasource.DriverManagerDataSource" id="dataSource">
  14. <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  15. <property name="url"
  16. value="jdbc:mysql://192.168.1.240:3306/abc?useUnicode=true&amp;characterEncoding=utf-8"/>
  17. <property name="username" value="root"/>
  18. <property name="password" value="Root@123456"/>
  19. </bean>
  20. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  21. <property name="dataSource" ref="dataSource"/>
  22. <property name="configLocation" value="classpath:tx/mybatis-config.xml"/>
  23. <property name="mapperLocations" value="classpath:tx/mappers/*.xml"/>
  24. </bean>
  25. <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  26. <property name="basePackage" value="cn.lichenghao.tx.dao"/>
  27. </bean>
  28. <bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="transactionManager">
  29. <property name="dataSource" ref="dataSource"/>
  30. </bean>
  31. <tx:advice id="interceptor" transaction-manager="transactionManager">
  32. <tx:attributes>
  33. <tx:method name="*add*" propagation="REQUIRED"/>
  34. <tx:method name="*delete*" propagation="REQUIRED"/>
  35. <tx:method name="*update*" propagation="REQUIRED"/>
  36. <tx:method name="*query*" read-only="true"/>
  37. </tx:attributes>
  38. </tx:advice>
  39. <aop:config>
  40. <aop:pointcut id="myPointcut" expression="execution(* cn.lichenghao.tx.dao.*.*(..))"/>
  41. <aop:pointcut id="myPointcut2" expression="execution(* cn.lichenghao.tx.service.*.*(..))"/>
  42. <aop:advisor advice-ref="interceptor" pointcut-ref="myPointcut"/>
  43. <aop:advisor advice-ref="interceptor" pointcut-ref="myPointcut2"/>
  44. </aop:config>
  45. </beans>

mybatis-config.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3. PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4. "https://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6. <settings>
  7. <setting name="logImpl" value="STDOUT_LOGGING"/>
  8. </settings>
  9. <typeAliases>
  10. <package name="cn.lichenghao.tx.entity"/>
  11. </typeAliases>
  12. </configuration>

准备 dao、servcie、mapper 文件

  1. @Component
  2. public interface UserDao {
  3. List<UserInfo> listUser();
  4. int addUser(UserInfo userInfo);
  5. }
  6. public interface UserService {
  7. List<UserInfo> listUser();
  8. int addUser(UserInfo userInfo);
  9. }
  10. @Service
  11. public class UserServiceImpl implements UserService {
  12. @Resource
  13. private UserDao userDao;
  14. @Override
  15. public List<UserInfo> listUser() {
  16. return userDao.listUser();
  17. }
  18. @Override
  19. public int addUser(UserInfo userInfo) {
  20. int added = userDao.addUser(userInfo);
  21. if (added > 0) {
  22. throw new RuntimeException("测试回滚!");
  23. }
  24. return added;
  25. }
  26. }

mapper

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3. PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4. "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <mapper namespace="cn.lichenghao.tx.dao.UserDao">
  6. <select id="listUser" resultType="cn.lichenghao.tx.entity.UserInfo">
  7. SELECT * FROM user;
  8. </select>
  9. <insert id="addUser" parameterType="cn.lichenghao.tx.entity.UserInfo">
  10. insert into user(`id`,`name`,`desc`) values (#{id},#{name},#{desc})
  11. </insert>
  12. </mapper>

单元测试

  1. @Test
  2. public void addUser() {
  3. ClassPathXmlApplicationContext context
  4. = new ClassPathXmlApplicationContext("tx/application.xml");
  5. UserService userService = context.getBean(UserService.class);
  6. UserInfo user = new UserInfo(3, "3333", "3333");
  7. System.out.println(userService.addUser(user));
  8. }

基于注解

调整 application.xml
开启注解事务支持

  1. <beans xmlns="http://www.springframework.org/schema/beans"
  2. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3. xmlns:aop="http://www.springframework.org/schema/aop"
  4. xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
  5. xsi:schemaLocation="http://www.springframework.org/schema/beans
  6. https://www.springframework.org/schema/beans/spring-beans.xsd
  7. http://www.springframework.org/schema/aop
  8. https://www.springframework.org/schema/aop/spring-aop.xsd
  9. http://www.springframework.org/schema/tx
  10. http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/context
  11. https://www.springframework.org/schema/context/spring-context.xsd">
  12. <context:component-scan base-package="cn.lichenghao.tx"></context:component-scan>
  13. <tx:annotation-driven/>
  14. <bean class="org.springframework.jdbc.datasource.DriverManagerDataSource" id="dataSource">
  15. <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  16. <property name="url"
  17. value="jdbc:mysql://192.168.1.240:3306/abc?useUnicode=true&amp;characterEncoding=utf-8"/>
  18. <property name="username" value="root"/>
  19. <property name="password" value="Root@123456"/>
  20. </bean>
  21. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  22. <property name="dataSource" ref="dataSource"/>
  23. <property name="configLocation" value="classpath:tx/mybatis-config.xml"/>
  24. <property name="mapperLocations" value="classpath:tx/mappers/*.xml"/>
  25. </bean>
  26. <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  27. <property name="basePackage" value="cn.lichenghao.tx.dao"/>
  28. </bean>
  29. <bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="transactionManager">
  30. <property name="dataSource" ref="dataSource"/>
  31. </bean>
  32. </beans>

接口使用注解即可

  1. @Transactional(propagation = Propagation.REQUIRED)
  2. @Override
  3. public int addUser(UserInfo userInfo) {
  4. int added = userDao.addUser(userInfo);
  5. if (added > 0) {
  6. throw new RuntimeException("测试回滚!");
  7. }
  8. return added;
  9. }