Spring中的事务控制

Spring中的事务控制：

1. 导包

	    
	<dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>
	<!--支持Spring的坐标-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>5.2.1.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>5.2.1.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>5.2.1.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>5.2.1.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>5.2.1.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>commons-logging</groupId>
      <artifactId>commons-logging</artifactId>
      <version>1.2</version>
    </dependency>
    <!--数据库连接池坐标-->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.2</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.22</version>
    </dependency>
    <!--数据库和事务的坐标-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>5.2.1.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-orm</artifactId>
      <version>5.2.1.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.2.1.RELEASE</version>
    </dependency>

    <!--配置切面的坐标-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>5.2.1.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>1.9.5</version>
    </dependency>
    <dependency>
      <groupId>aopalliance</groupId>
      <artifactId>aopalliance</artifactId>
      <version>1.0</version>
    </dependency>
    <!--cglib动态代理坐标-->
    <dependency>
      <groupId>org.sonatype.sisu.inject</groupId>
      <artifactId>cglib</artifactId>
      <version>2.2.1-v20090111</version>
    </dependency>

2.写配置：

    <!--加载配置文件-->
    <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>

    <!--配置数据库连接池-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"></property>
        <property name="jdbcUrl" value="${jdbc.url}"></property>
        <property name="user" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>

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

    <!--开启组件扫描-->
    <context:component-scan base-package="com"></context:component-scan>

2.2 在Spring核心配置文件中配置事务控制

	<!--事务控制-->
    <!--1:配置事务管理器(切面)让其进行事务控制;一定要导入面向切面编程的几个包-->
    <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <!--控制住数据源-->
        <constructor-arg name="dataSource" ref="dataSource"></constructor-arg>
    </bean>
    <!--2:开启基于注解的事务控制模式;依赖于tx名称空间-->
    <tx:annotation-driven transaction-manager="dataSourceTransactionManager"></tx:annotation-driven>
    <!--3:给事务方法加注解-->

3.测试：

3.1编写Dao

@Repository
public class BookDao {

    @Autowired
    JdbcTemplate jdbcTemplate;

    //减余额
    public void updateBalance(String username,int price){
        String sql="update ds account SET balance=balance-? WHERE username=?";
        int update = jdbcTemplate.update(sql, price,username);
    }

    //查询书的价格
    public int getPrice(String isbn){
        String sql="select price from book where isbn=?";
        Integer query = jdbcTemplate.queryForObject(sql, Integer.class, isbn);
        return query;
    }

    //修改图书的库存
    public void updateStock(String isbn){
        String sql="update  book_stock set stock=stock-1 where isbn=?";
        jdbcTemplate.update(sql,isbn);
    }
}

3.2编写Service层(@Transactional开启事务控制的注解)

@Service
public class BookService {

    @Autowired
    private BookDao bookDao;

    //结账操作
    //开启事务控制的注解
    @Transactional
    public void checkOut(String username,String isbn){
        //1.减库存
        bookDao.updateStock(isbn);
        //1.2.求出书的单价
        int price = bookDao.getPrice(isbn);
        //2.减余额
        bookDao.updateBalance(username,price);
    }
}