17_Spring_事务环境搭建

怼烎@ 2023-09-30 20:00 13阅读 0赞

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

1 数据库中准备表格

![b76705d378bba37b322dcb436ac0cc27.png][]

applicationContext.xml

jdbc.properties

见上节课

2 项目中准备实体类

package com.msb.pojo;
    import lombok.AllArgsConstructor;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    import java.io.Serializable;
    /**
     * @Author: Ma HaiYang
     * @Description: MircoMessage:Mark_7001
     */
    @AllArgsConstructor
    @NoArgsConstructor
    @Data
    public class Account implements Serializable {
        private Integer id;
        private String name;
        private Integer money;
    }

![fa21ebc04d190f04157caf8de242b73e.gif][]

![3e1e2769d4568e2df338aa3158704646.gif][]

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

package com.msb.dao;
    /**
     * @Author: Ma HaiYang
     * @Description: MircoMessage:Mark_7001
     */
    public interface AccountDao {
        int transMoney(int id,int money);
    }

![f8052db5778f7717b9eed3257d6839ca.gif][]

![9005e0140c3274991787aab4f4cf04fc.gif][]

package com.msb.dao.impl;
    import com.msb.dao.AccountDao;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.stereotype.Repository;
    /**
     * @Author: Ma HaiYang
     * @Description: MircoMessage:Mark_7001
     */
    @Repository
    public class AccountDaoImpl implements AccountDao {
        @Autowired
        private JdbcTemplate jdbcTemplate;
        @Override
        public int transMoney(int id, int money) {
            String sql ="update account set money =money +? where id =?";
            return jdbcTemplate.update(sql,money,id);
        }
    }

![d212a448a60adcd3f1db79c032e3dbbf.gif][]

![aab48758a9860f2e03c04ee004bdd957.gif][]

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

package com.msb.service;
    /**
     * @Author: Ma HaiYang
     * @Description: MircoMessage:Mark_7001
     */
    public interface AccountService {
        int transMoney(int from ,int to,int money);
    }

![82fef10cf04a5e61e3adea0d8d892c50.gif][]

![27ef6303edbc2ba0c7e7cb89b1eec5aa.gif][]

package com.msb.service.impl;
    import com.msb.dao.AccountDao;
    import com.msb.service.AccountService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    /**
     * @Author: Ma HaiYang
     * @Description: MircoMessage:Mark_7001
     */
    @Service
    public class AccountServiceImpl implements AccountService {
        @Autowired
        private AccountDao accountDao;
        @Override
        public int transMoney(int from, int to, int money) {
            int rows=0;
            rows+=accountDao.transMoney(from, 0 - money);       
            rows+=accountDao.transMoney(to, money);        
            return rows;
        }
    }

![83ab4a9d2a36971f91d6c1de72dbde7b.gif][]

![b8191561d68034f5ba5d39dd2fa5e781.gif][]

5 测试代码,测试转账

package com.msb.test;
    import com.msb.service.AccountService;
    import org.junit.Test;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    /**
     * @Author: Ma HaiYang
     * @Description: MircoMessage:Mark_7001
     */
    public class TestTx {
        @Test()
        public void testTransaction(){
            ApplicationContext context =new ClassPathXmlApplicationContext("applicationContext.xml");
            AccountService accountService = context.getBean(AccountService.class);
            int rows = accountService.transMoney(1, 2, 100);
            System.out.println(rows);
        }
        
    }

![da09d9df6d8bfdc3e4d3b3d34fa679d1.gif][]

![1c3c4c855d1db2c316d3c3a00abc1b6d.gif][]

[b76705d378bba37b322dcb436ac0cc27.png]: https://img-blog.csdnimg.cn/img_convert/b76705d378bba37b322dcb436ac0cc27.png
[fa21ebc04d190f04157caf8de242b73e.gif]: https://img-blog.csdnimg.cn/img_convert/fa21ebc04d190f04157caf8de242b73e.gif
[3e1e2769d4568e2df338aa3158704646.gif]: https://img-blog.csdnimg.cn/img_convert/3e1e2769d4568e2df338aa3158704646.gif
[f8052db5778f7717b9eed3257d6839ca.gif]: https://img-blog.csdnimg.cn/img_convert/f8052db5778f7717b9eed3257d6839ca.gif
[9005e0140c3274991787aab4f4cf04fc.gif]: https://img-blog.csdnimg.cn/img_convert/9005e0140c3274991787aab4f4cf04fc.gif
[d212a448a60adcd3f1db79c032e3dbbf.gif]: https://img-blog.csdnimg.cn/img_convert/d212a448a60adcd3f1db79c032e3dbbf.gif
[aab48758a9860f2e03c04ee004bdd957.gif]: https://img-blog.csdnimg.cn/img_convert/aab48758a9860f2e03c04ee004bdd957.gif
[82fef10cf04a5e61e3adea0d8d892c50.gif]: https://img-blog.csdnimg.cn/img_convert/82fef10cf04a5e61e3adea0d8d892c50.gif
[27ef6303edbc2ba0c7e7cb89b1eec5aa.gif]: https://img-blog.csdnimg.cn/img_convert/27ef6303edbc2ba0c7e7cb89b1eec5aa.gif
[83ab4a9d2a36971f91d6c1de72dbde7b.gif]: https://img-blog.csdnimg.cn/img_convert/83ab4a9d2a36971f91d6c1de72dbde7b.gif
[b8191561d68034f5ba5d39dd2fa5e781.gif]: https://img-blog.csdnimg.cn/img_convert/b8191561d68034f5ba5d39dd2fa5e781.gif
[da09d9df6d8bfdc3e4d3b3d34fa679d1.gif]: https://img-blog.csdnimg.cn/img_convert/da09d9df6d8bfdc3e4d3b3d34fa679d1.gif
[1c3c4c855d1db2c316d3c3a00abc1b6d.gif]: https://img-blog.csdnimg.cn/img_convert/1c3c4c855d1db2c316d3c3a00abc1b6d.gif