事务回滚不了的问题

.Y。 2020-02-21 03:14:25

代码：
book.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xmlns:context="http://www.springframework.org/schema/context"

	xmlns:aop="http://www.springframework.org/schema/aop"

	xmlns:tx="http://www.springframework.org/schema/tx"

	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd

		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd

		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">



	<context:component-scan base-package="com.junruo.book"></context:component-scan>

	

	<!-- 引入属性文件 -->

	<!-- <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

		<property name="location" value="db.properties"></property>

	</bean> -->

	

	<!-- 引入属性文件 -->

	<context:property-placeholder location="db.properties"/>



	<!-- 创建数据源 -->

	<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">

		<property name="driverClassName" value="${jdbc.driver}"></property>

		<property name="url" value="${jdbc.url}"></property>

		<property name="username" value="${jdbc.username}"></property>

		<property name="password" value="${jdbc.password}"></property>

	</bean>



	<!-- 通过数据源配置JdbcTemplate -->

	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">

		<property name="dataSource" ref="dataSource"></property>

	</bean>

	

	<!-- 配置事务管理器 -->

	<bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

		<property name="dataSource" ref="dataSource"></property>

	</bean>



	<!-- 开启注解驱动，即对事务相关的注解进行扫描，解析含义并执行功能 -->

	<tx:annotation-driven transaction-manager="dataSourceTransactionManager"/>

	

</beans>

BookDaoImpl.java持久层

package com.junruo.book.dao.impl;



import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.stereotype.Repository;



import com.junruo.book.dao.BookDao;

import com.junruo.book.exception.MyException;



@Repository

public class BookDaoImpl implements BookDao {

 	

	@Autowired

	private JdbcTemplate jdbcTemplate;



	@Override

	public Integer selectPrice(String bid) {

		Integer price = jdbcTemplate.queryForObject("select price from book where bid = ?",new Object[] {bid}, Integer.class);

		return price;

	}



	@Override

	public void updateSt(String bid) {

		//获取该书籍的库存

		Integer st = jdbcTemplate.queryForObject("select st from stock where sid = ?",new Object[] {bid},Integer.class);

		if (st <= 0) {

			throw new RuntimeException();

		}else {

			jdbcTemplate.update("update stock set st = st -1 where sid = ?", bid);

		}

	}



	@Override

	public void updataBalance(String uid,Integer price) {

		Integer balance = jdbcTemplate.queryForObject("select balance from money where uid = ?", new Object[] {uid}, Integer.class);

		if (balance < price) {

			throw new RuntimeException();

		}else {

			jdbcTemplate.update("update money set balance = balance - ? where uid = ?", price,uid);

		}

	}

	

	

	

}

BookServiceImpl.java 业务处理层



package com.junruo.book.service.impl;



import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Propagation;

import org.springframework.transaction.annotation.Transactional;



import com.junruo.book.dao.BookDao;

import com.junruo.book.exception.MyException;

import com.junruo.book.service.BookService;



@Service

public class BookServiceImpl implements BookService {

	

	@Autowired

	private BookDao dao;



	@Transactional

	public void buyBook(String bid, String uid) {

		Integer price = dao.selectPrice(bid);

		dao.updateSt(bid);

		dao.updataBalance(uid, price);

		

	}

}

BookController.java控制层



package com.junruo.book.controller;



import java.util.ArrayList;

import java.util.List;



import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.transaction.annotation.Transactional;



import com.junruo.book.service.BookService;

import com.junruo.book.service.Cashier;



@Controller

public class BookController {



	@Autowired

	private BookService service;

	

	@Autowired

	private Cashier cashier;

	

	//购买单本书

	public void buyBook() {

		service.buyBook("1", "1001");

	}

}

Test.java测试类



package com.junruo.book;



import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;



import com.junruo.book.controller.BookController;



public class Test {



	public static void main(String[] args) {

		ApplicationContext ac = new ClassPathXmlApplicationContext("book.xml");

		BookController controller = ac.getBean("bookController",BookController.class);

		controller.buyBook();

		

		//controller.checkout();

	}

}