添加事务注解
1、使用 propagation 指定事务的传播行为, 即当前的事务方法被另外一个事务方法调用时。如何使用事务, 默认取值为 REQUIRED, 即使用调用方法的事务REQUIRES_NEW: 事务自己的事务, 调用的事务方法的事务被挂起。
2、使用 isolation 指定事务的隔离级别, 最常用的取值为 READ_COMMITTED。
3、默认情况下 Spring 的声明式事务对所有的运行时异常进行回滚. 也可以通过对应的属性进行设置. 通常情况下去默认值即可。
4、使用 readOnly 指定事务是否为只读. 表示这个事务只读取数据但不更新数据,这样可以帮助数据库引擎优化事务. 若真的是一个只读取数据库值的方法, 应设置 readOnly=true
5、使用 timeout 指定强制回滚之前事务可以占用的时间。
个人疑问有一些,结尾来说,用教程例子来说吧。
我的代码如下:
BookShopDao接口
package com.demo.spring.bean;public interface BookShopDao { //根据书的编号返回书的单价 public int findBookPriceByIsbn(String isbn); //根据书的编号返回输的库存 public void updateBookStock(String isbn); //更新用户账户余额 public void updateUserAccount(String username, int price);}
实现类
package com.demo.spring.bean;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.stereotype.Repository;@Repository("bookShopDao")public class BookShopDaoImpl implements BookShopDao { @Autowired private JdbcTemplate jdbcTemplate; @Override public int findBookPriceByIsbn(String isbn) { // TODO Auto-generated method stub String sql = "SELECT price FROM book WHERE isbn=?"; Integer price = jdbcTemplate.queryForObject(sql, Integer.class, isbn); return price; } @Override public void updateBookStock(String isbn) { // TODO Auto-generated method stub String sql = "SELECT stock FROM book_stock WHERE isbn= ? "; Integer stock = jdbcTemplate.queryForObject(sql, Integer.class, isbn); if (stock == 0) { throw new BookStockException("库存不足!!"); } String sql1 = "UPDATE book_stock SET stock=stock-1 WHERE isbn=?"; jdbcTemplate.update(sql1, isbn); } @Override public void updateUserAccount(String username, int price) { // TODO Auto-generated method stub String sql1 = "SELECT balance FROM account WHERE username= ? "; Integer account = jdbcTemplate.queryForObject(sql1, Integer.class, username); if (account < price) { throw new AccountException("余额不足!!"); } String sql = "UPDATE account SET balance=balance-? WHERE username=?"; jdbcTemplate.update(sql, price, username); }}
BookShopService接口
package com.demo.spring.bean;public interface BookShopService {//购书public void purchase(String username, String isbn);}
实现类
package com.demo.spring.bean;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;@Service("bookShopService")public class BookShopServiceImpl implements BookShopService { @Autowired private BookShopDao bookShopDao;// @Transactional(propagation=Propagation.REQUIRES_NEW,isolation=Isolation.READ_COMMITTED,readOnly=true,timeout=5,noRollbackFor=AccountException.class) @Transactional @Override public void purchase(String username, String isbn) { try { Thread.sleep(5000); } catch (InterruptedException e) { // TODO Auto-generated catch block e.printStackTrace(); } // TODO Auto-generated method stub int price = bookShopDao.findBookPriceByIsbn(isbn); bookShopDao.updateBookStock(isbn); bookShopDao.updateUserAccount(username, price); }}
Cashier批量购书接口
package com.demo.spring.bean;import java.util.List;public interface Cashier { //批量购书 public void checkout(String username, List isbns);}
实现类
package com.demo.spring.bean;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;@Service("cashier")public class CashierImpl implements Cashier { @Autowired private BookShopService bookShopService;// @Transactional @Override public void checkout(String username, List isbns) { // TODO Auto-generated method stub for (String isbn : isbns) { bookShopService.purchase(username, isbn); } }}
账户余额不足异常(自定义异常)
package com.demo.spring.bean;public class AccountException extends RuntimeException { /** * */ private static final long serialVersionUID = 1L; public AccountException() { super(); // TODO Auto-generated constructor stub } public AccountException(String message, Throwable cause, boolean enableSuppression, boolean writableStackTrace) { super(message, cause, enableSuppression, writableStackTrace); // TODO Auto-generated constructor stub } public AccountException(String message, Throwable cause) { super(message, cause); // TODO Auto-generated constructor stub } public AccountException(String message) { super(message); // TODO Auto-generated constructor stub } public AccountException(Throwable cause) { super(cause); // TODO Auto-generated constructor stub }}
库存不足异常(自定义异常)
package com.demo.spring.bean;public class BookStockException extends RuntimeException { private static final long serialVersionUID = 1L; public BookStockException() { super(); // TODO Auto-generated constructor stub } public BookStockException(String message, Throwable cause, boolean enableSuppression, boolean writableStackTrace) { super(message, cause, enableSuppression, writableStackTrace); // TODO Auto-generated constructor stub } public BookStockException(String message, Throwable cause) { super(message, cause); // TODO Auto-generated constructor stub } public BookStockException(String message) { super(message); // TODO Auto-generated constructor stub } public BookStockException(Throwable cause) { super(cause); // TODO Auto-generated constructor stub }}
测试类
package com.demo.spring.bean;import java.util.Arrays;import org.junit.Test;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;public class MainTest { private ApplicationContext ctx; @Autowired private Cashier cashier; { ctx=new ClassPathXmlApplicationContext("bean.xml"); cashier=(Cashier) ctx.getBean("cashier"); } @Test public void test(){// System.out.println(bookShopDao.findBookPriceByIsbn("1001")); cashier.checkout("rongrong