spring中怎么让事物提交_spring事物中的传播及隔离

4027c3e1a8929c793f4bc171694d9198.png

添加事务注解

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
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值