项目结构: 表结构:
基于xml的声明式事务配置
IAccountDao.java:
package tx.dao;
import java.math.BigDecimal;
public interface IAccountDao {
void add(String name, BigDecimal money);
void sub(String name, BigDecimal money);
}
AccountDaoImpl.java:
package tx.service.impl;
import tx.dao.IAccountDao;
import tx.service.IAccountService;
import java.math.BigDecimal;
public class AccountServiceImpl implements IAccountService {
private IAccountDao accountDao;
public void setAccountDao(IAccountDao accountDao) {
this.accountDao = accountDao;
}
@Override
public void tran(String from, String to, BigDecimal money) {
accountDao.sub(from, money);
accountDao.add(to, money);
}
}
IAccountService.java:
package tx.service;
import java.math.BigDecimal;
public interface IAccountService {
void tran(String from, String to, BigDecimal money);
}
AccountDaoImpl.java:
package tx.dao.impl;
import org.springframework.jdbc.core.JdbcTemplate;
import tx.dao.IAccountDao;
import java.math.BigDecimal;
public class AccountDaoImpl implements IAccountDao {
private JdbcTemplate jdbcTemplate;
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
@Override
public void add(String name, BigDecimal money) {
jdbcTemplate.update("update account set balance = balance + ? where name = ? ", money.toString(), name);
}
@Override
public void sub(String name, BigDecimal money) {
jdbcTemplate.update("update account set balance = balance - ? where name = ? ", money.toString(), name);
}
}
<?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:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
">
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
<property name="url" value="jdbc:mysql://localhost:3306/test?useSSL=false"/>
<property name="username" value="root"/>
<property name="password" value="19834044876"/>
<property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>
<bean id="accountDao" class="tx.dao.impl.AccountDaoImpl">
<property name="jdbcTemplate" ref="jdbcTemplate"/>
</bean>
<bean id="accountService" class="tx.service.impl.AccountServiceImpl">
<property name="accountDao" ref="accountDao"/>
</bean>
<tx:advice id="txAdvice">
<tx:attributes>
<tx:method name="tran"/>
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="pointCut" expression="execution(* tx.service.IAccountService.*(..))"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="pointCut"/>
</aop:config>
</beans>
ApplicationContext context = new ClassPathXmlApplicationContext("tx.xml");
IAccountService accountService = context.getBean("accountService", IAccountService.class);
accountService.tran("小明", "小红", new BigDecimal(500));
完全注解(零xml)方式配置
IAccountDao.java:
package tx.dao;
import java.math.BigDecimal;
public interface IAccountDao {
void add(String name, BigDecimal money);
void sub(String name, BigDecimal money);
}
AccountDaoImpl.java:
package tx.dao.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import tx.dao.IAccountDao;
import java.math.BigDecimal;
@Repository
public class AccountDaoImpl implements IAccountDao {
@Autowired
private JdbcTemplate jdbcTemplate;
@Override
public void add(String name, BigDecimal money) {
jdbcTemplate.update("update account set balance = balance + ? where name = ? ", money.toString(), name);
}
@Override
public void sub(String name, BigDecimal money) {
jdbcTemplate.update("update account set balance = balance - ? where name = ? ", money.toString(), name);
}
}
IAccountService.java:
package tx.service;
import java.math.BigDecimal;
public interface IAccountService {
void tran(String from, String to, BigDecimal money);
}
AccountServiceImpl.java:
package tx.service.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import tx.dao.IAccountDao;
import tx.service.IAccountService;
import java.math.BigDecimal;
@Service
@Transactional
public class AccountServiceImpl implements IAccountService {
@Autowired
private IAccountDao accountDao;
@Override
public void tran(String from, String to, BigDecimal money) {
accountDao.sub(from, money);
accountDao.add(to, money);
}
}
TXConfig.java
package tx.config;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import tx.service.IAccountService;
import tx.service.impl.AccountServiceImpl;
import javax.sql.DataSource;
@Configuration
@ComponentScan(basePackages = "tx")
@EnableTransactionManagement
public class TXConfig {
@Bean
public DataSource getDataSource() {
DruidDataSource dataSource = new DruidDataSource();
dataSource.setUrl("jdbc:mysql://localhost:3306/test?useSSL=false");
dataSource.setUsername("root");
dataSource.setPassword("19834044876");
dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
return dataSource;
}
@Bean
public DataSourceTransactionManager getTransactionManager() {
return new DataSourceTransactionManager(getDataSource());
}
@Bean
public JdbcTemplate getJdbcTemplate() {
return new JdbcTemplate(getDataSource());
}
@Bean(name = "accountService")
public IAccountService getAccountService() {
return new AccountServiceImpl();
}
}
ApplicationContext context = new AnnotationConfigApplicationContext(TXConfig.class);
IAccountService accountService = context.getBean("accountService", IAccountService.class);
accountService.tran("小明", "小红", new BigDecimal(500));
事务参数
no-rollback-for
指定碰到哪些异常不需要回滚
rollback-for
指定碰到哪些异常需要回滚
read-only
设置事务为只读事务
timeout
以秒为单位,设置事务超出指定时常后自动回滚
默认为-1,即不管事务运行多久都不回滚
isolation
事务的隔离级别
默认为DEFAULT ,即使用当前数据库的隔离级别
propagation
事务的传播行为
默认为REQUIRED
|