17_Spring_事务环境搭建

通过张三给李四转账案例演示事务的控制

1 数据库中准备表格

applicationContext.xml

jdbc.properties

见上节课

2 项目中准备实体类

1. package com.msb.pojo;
2. import lombok.AllArgsConstructor;
3. import lombok.Data;
4. import lombok.NoArgsConstructor;
5. import java.io.Serializable;
6. /**
7. • @Author: Ma HaiYang
8. • @Description: MircoMessage:Mark_7001
9. */
10. @AllArgsConstructor
11. @NoArgsConstructor
12. @Data
13. public class Account implements Serializable {

14. private Integer id;
    

15. private String name;
    

16. private Integer money;
    

17. }

3 准备DAO层,创建一个根据id修改money的方法

1. package com.msb.dao;

2. /**

3. • @Author: Ma HaiYang
4. • @Description: MircoMessage:Mark_7001

5. */

6. public interface AccountDao {

7.  int transMoney(int id,int money);
   

8. }

9. package com.msb.dao.impl;

10. import com.msb.dao.AccountDao;

11. import org.springframework.beans.factory.annotation.Autowired;

12. import org.springframework.jdbc.core.JdbcTemplate;

13. import org.springframework.stereotype.Repository;

14. /**

15. • @Author: Ma HaiYang
16. • @Description: MircoMessage:Mark_7001

17. */

18. @Repository

19. public class AccountDaoImpl implements AccountDao {

20. @Autowired
    

21. private JdbcTemplate jdbcTemplate;
    

22. @Override
    

23. public int transMoney(int id, int money) {
    

24.     String sql ="update account set money =money +? where id =?";
    

25.     return jdbcTemplate.update(sql,money,id);
    

26. }
    

27. }

4 准备Service,创建一个转账的业务方法

1. package com.msb.service;

2. /**

3. • @Author: Ma HaiYang
4. • @Description: MircoMessage:Mark_7001

5. */

6. public interface AccountService {

7.  int transMoney(int from ,int to,int money);
   

8. }

9. package com.msb.service.impl;

10. import com.msb.dao.AccountDao;

11. import com.msb.service.AccountService;

12. import org.springframework.beans.factory.annotation.Autowired;

13. import org.springframework.stereotype.Service;

14. /**

15. • @Author: Ma HaiYang
16. • @Description: MircoMessage:Mark_7001

17. */

18. @Service

19. public class AccountServiceImpl implements AccountService {

20. @Autowired
    

21. private AccountDao accountDao;
    

22. @Override
    

23. public int transMoney(int from, int to, int money) {
    

24.     int rows=0;
    

25.     rows+=accountDao.transMoney(from, 0 - money);       
    

26.     rows+=accountDao.transMoney(to, money);        
    

27.     return rows;
    

28. }
    

29. }

5 测试代码,测试转账

1. package com.msb.test;
2. import com.msb.service.AccountService;
3. import org.junit.Test;
4. import org.springframework.context.ApplicationContext;
5. import org.springframework.context.support.ClassPathXmlApplicationContext;
6. /**
7. • @Author: Ma HaiYang
8. • @Description: MircoMessage:Mark_7001
9. */
10. public class TestTx {

11. @Test()
    

12. public void testTransaction(){
    

13.     ApplicationContext context =new
    

    ClassPathXmlApplicationContext("applicationContext.xml");

14.     AccountService accountService =
    

    context.getBean(AccountService.class);

15.     int rows = accountService.transMoney(1, 2, 100);
    

16.     System.out.println(rows);
    

17. }
    

19. }