Spring Mybatis 事务死锁解决全过程

使用的事务管理是

 

org.springframework.jdbc.datasource.DataSourceTransactionManager

 一、刚开始事务是这样实现的

 

 

TransactionStatus ts = transactionManager.getTransaction(null);
		try {

			// 得到用户信息
			User user = userMapper.selectByPrimaryKey(userId);
			
			user.setHealthBeans(user.getHealthBeans() == null ? 0 : user.getHealthBeans());

			Article article = articleMapper.selectByPrimaryKey(articleId);
			
			User createrUser = userMapper.selectByPrimaryKey(article.getCreater());
			HealthBeansRecord record = new HealthBeansRecord();
			
			healthBeansRecordMapper.insertSelective(record);
			

			
			record.setNumber((byte) +exceptionalCount);
			
			healthBeansRecordMapper.insertSelective(record);

			userMapper.modifyHealthBeans(userId, -exceptionalCount);

			userMapper.modifyHe