<dependencies>
<!-- 基于Maven依賴傳遞性，導(dǎo)入spring-context依賴即可導(dǎo)入當(dāng)前所需所有jar包 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.3.1</version>
</dependency>
<!-- Spring 持久化層支持jar包 -->
<!-- Spring 在執(zhí)行持久化層操作、與持久化層技術(shù)進(jìn)行整合過程中，需要使用orm、jdbc、tx三個(gè)
jar包 -->
<!-- 導(dǎo)入 orm 包就可以通過 Maven 的依賴傳遞性把其他兩個(gè)也導(dǎo)入 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>5.3.1</version>
</dependency>
<!-- Spring 測試相關(guān) -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.3.1</version>
</dependency>
<!-- junit測試 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- MySQL驅(qū)動(dòng) -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.16</version>
</dependency>
<!-- 數(shù)據(jù)源 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.31</version>
</dependency>
</dependencies>

<!--導(dǎo)入外部屬性文件-->
<context:property-placeholderlocation="classpath:jdbc.properties"/>
<!--配置數(shù)據(jù)源-->
<beanid="druidDataSource"class="com.alibaba.druid.pool.DruidDataSource"> 
 <propertyname="url"value="${atguigu.url}"/>
  <propertyname="driverClassName"value="${atguigu.driver}"/>
  <propertyname="username"value="${atguigu.username}"/>
  <propertyname="password"value="${atguigu.password}"/>
</bean>
<!--配置JdbcTemplate-->
<beanid="jdbcTemplate"class="org.springframework.jdbc.core.JdbcTemplate">  <!--裝配數(shù)據(jù)源-->
  <propertyname="dataSource"ref="druidDataSource"/>
</bean>

<!--掃描組件-->
<context:component-scanbase-package="com.atguigu.spring.tx.annotation">
</context:component-scan>
<!--導(dǎo)入外部屬性文件-->
<context:property-placeholderlocation="classpath:jdbc.properties"/>
<!--配置數(shù)據(jù)源-->
<beanid="druidDataSource"class="com.alibaba.druid.pool.DruidDataSource">  
<propertyname="url"value="${jdbc.url}"/>
  <propertyname="driverClassName"value="${jdbc.driver}"/>
  <propertyname="username"value="${jdbc.username}"/>
  <propertyname="password"value="${jdbc.password}"/>
</bean>
<!--配置JdbcTemplate-->
<beanid="jdbcTemplate"class="org.springframework.jdbc.core.JdbcTemplate">
  <!--裝配數(shù)據(jù)源-->
  <propertyname="dataSource"ref="druidDataSource"/>
</bean>

REATETABLE`t_book`(
book_id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'主鍵',
`book_name`varchar(20)DEFAULTNULLCOMMENT'圖書名稱',
`price`int(11)DEFAULTNULLCOMMENT'價(jià)格',
`stock`int(10)unsignedDEFAULTNULLCOMMENT'庫存（無符號(hào)）',
PRIMARYKEY(`book_id`)
)ENGINE=InnoDBAUTO_INCREMENT=3DEFAULTCHARSET=utf8;
insert into`t_book`(`book_id`,`book_name`,`price`,`stock`)values(1,'斗破蒼穹',80,100),(2,'斗羅大陸',50,100);
CREATETABLE`t_user`(
`user_id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'主鍵',
`username`varchar(20)DEFAULTNULLCOMMENT'用戶名',
`balance`int(10)unsignedDEFAULTNULLCOMMENT'余額（無符號(hào)）',
PRIMARYKEY(`user_id`)
)ENGINE=InnoDBAUTO_INCREMENT=2DEFAULTCHARSET=utf8;
insert into`t_user`(`user_id`,`username`,`balance`)values(1,'admin',50);

@Controller
public class BookController {
    @Autowired
    private BookService bookService;
    public void buyBook(Integer bookId, Integer userId){
    bookService.buyBook(bookId, userId);
    }
}

public interface BookService {    
void buyBook(Integer bookId, Integer userId);
}

<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!--
開啟事務(wù)的注解驅(qū)動(dòng)
通過注解@Transactional所標(biāo)識(shí)的方法或標(biāo)識(shí)的類中所有的方法，都會(huì)被事務(wù)管理器管理事務(wù)
-->
<!-- transaction-manager屬性的默認(rèn)值是transactionManager，如果事務(wù)管理器bean的id正好就
是這個(gè)默認(rèn)值，則可以省略這個(gè)屬性 -->
<tx:annotation-driven transaction-manager="transactionManager" />

@Transactional(isolation = Isolation.DEFAULT)//使用數(shù)據(jù)庫默認(rèn)的隔離級(jí)別
@Transactional(isolation = Isolation.READ_UNCOMMITTED)//讀未提交
@Transactional(isolation = Isolation.READ_COMMITTED)//讀已提交
@Transactional(isolation = Isolation.REPEATABLE_READ)//可重復(fù)讀
@Transactional(isolation = Isolation.SERIALIZABLE)//串行化