Spring事务管理—注解的方式

问题：转账中突发状况仍可转账双方数据有减无增/无减有增

目的：转账途中产生问题则会转账不成功

 

步骤

1.创建数据库

2.entity

public class Bank implements Serializable {


    private Integer id;
    private String name;
    private Float money;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Float getMoney() {
        return money;
    }

    public void setMoney(Float money) {
        this.money = money;
    }

    @Override
    public String toString() {
        return "Bank{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", money=" + money +
                '}';
    }
}

3.Dao

public interface BankDao {
    /**
     * 根据Id查找
     * @param bankId
     * @return
     */
    Bank findBankById(Integer bankId);

    /**
     * 根据名字查找
     * @param bankName
     * @return
     */
    Bank findBankByName(String bankName);

    /**
     * 更新信息
     * @param bank
     */
    void updateBank(Bank bank);

}

@Repository("bankDao")
public class BankDaoImpl implements BankDao {

    //内部自带的 jdbcTemplate
    @Autowired
    private JdbcTemplate jdbcTemplate;


    public Bank findBankById(Integer bankId) {
        List<Bank> banks=jdbcTemplate.query("select * from bank where id = ?",new BeanPropertyRowMapper<Bank>(Bank.class),bankId);
        return banks.isEmpty()?null:banks.get(0);
    }

    public Bank findBankByName(String bankName) {
        List<Bank> banks=jdbcTemplate.query("select * from bank where name=?", new BeanPropertyRowMapper<Bank>(Bank.class),bankName);
        if(banks.isEmpty())return null;
        if(banks.size()>1) throw  new RuntimeException("结果集不唯一");
        return banks.get(0);
    }

    public void updateBank(Bank bank) {
        jdbcTemplate.update("update bank set name=?,money=? where id=?",bank.getName(),bank.getMoney(),bank.getId());
    }
}

4.Service

public interface BankService {

    /**
     * 根据id查询
     * @param bankId
     * @return
     */
    Bank findBankById(Integer bankId);

    /**
     * 转账
     * @param sourceName 转出名称
     * @param targetName 转入名称
     * @param money 金额
     */
    void transfer(String sourceName,String targetName,Float money);
}

@Service("bankService")
@Transactional(propagation= Propagation.SUPPORTS,readOnly=true)
public class BankServiceImpl implements BankService {

    @Autowired
    private BankDao bankDao;

    public Bank findBankById(Integer bankId) {
        return bankDao.findBankById(bankId);
    }

    @Transactional(propagation= Propagation.REQUIRED,readOnly=false)
    public void transfer(String sourceName, String targetName, Float money) {
        //查询转出
        Bank source=bankDao.findBankByName(sourceName);
        //查询转入
        Bank target=bankDao.findBankByName(targetName);
        //转出金额减少
        source.setMoney(source.getMoney()-money);
        //转入金额增加
        target.setMoney(target.getMoney()+money);
        //更新转出
        bankDao.updateBank(source);
        int i=1/0;
        //更新转入
        bankDao.updateBank(target);
    }
}

5.配置信息

<!--配置spring创建容器要扫描的包-->
    <context:component-scan base-package="com.zy"></context:component-scan>

    <!--配置jdbcTemplate-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!--配置数据源-->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql://localhost:3306/bank?&amp;useSSL=false&amp;serverTimezone=UTC&amp;allowPublicKeyRetrieval=true"></property>
        <property name="username" value="root"></property>
        <property name="password" value="123456"></property>
    </bean>


    <!--注解的声明式事务控制-->
    <!--配置事务管理器-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <!--开启spring对注解事务的支持-->
    <tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>