前期准备
public class AccountDaoImpl implements AccountDao {
private JdbcTemplate jdbcTemplate;
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
@Override
public void inmoney(int in, double money) {
String sql = "update account set money = money + ? where uid = ?";
int update = jdbcTemplate.update(sql, money, in);
}
@Override
public void outmoney(int out, double money) {
String sql = "update account set money = money - ? where uid = ?";
jdbcTemplate.update(sql,money,out);
}
}
方式一:编程式事务管理
ApplicationConfig.xml
<!--配置dao对象 注入属性jdbcTemplate-->
<bean id="accountDao" class="com.wenjing.dao.impl.AccountDaoImpl">
<property name="jdbcTemplate" ref="jdbcTemplate"/>
</bean>
<!--配置service注入dao和事务管理模板-->
<bean id="accountService" class="com.wenjing.service.Impl.AccountServiceImpl">
<property name="accountDao" ref="accountDao"/>
<property name="transactionTemplate" ref="transactionTemplate"/>
</bean>
<!--数据源创建连接对象-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mbs"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</bean>
<!--创建jdbcTemplate注入属性数据源-->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>
<!--配置平台事物管理器-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!--事物管理模板-->
<bean id="transactionTemplate" class="org.springframework.transaction.support.TransactionTemplate">
<!--注入平台事务管理器-->
<property name="transactionManager" ref="transactionManager"/>
</bean>

public class AccountServiceImpl implements AccountService {
private AccountDaoImpl accountDao;
private TransactionTemplate transactionTemplate;
public void setAccountDao(AccountDaoImpl accountDao) {
this.accountDao = accountDao;
}
public void setTransactionTemplate(TransactionTemplate transactionTemplate) {
this.transactionTemplate = transactionTemplate;
}
@Override
public void transMoney(int in, int out, double money) {
transactionTemplate.execute(new TransactionCallbackWithoutResult() {
@Override
protected void doInTransactionWithoutResult(TransactionStatus transactionStatus) {
accountDao.outmoney(out,money);
int i = 1/0;
accountDao.inmoney(in,money);
}
});
}
}
方式二:声明式事务管理(XML配置文件)
<!--
事务的实现就是使用 aop 来实现的,因为事务就是出现异常时回滚,
所以可以用 aop 在方法执行出现异常时进行 rollback 操作
-->
ApplicationConfig.xml
<!--配置dao对象 注入属性jdbcTemplate-->
<bean id="accountDao" class="com.wenjing.dao.impl.AccountDaoImpl">
<property name="jdbcTemplate" ref="jdbcTemplate"/>
</bean>
<!--配置service注入dao和事务管理模板-->
<bean id="accountService" class="com.wenjing.service.Impl.AccountServiceImpl">
<property name="accountDao" ref="accountDao"/>
</bean>
<!--数据源创建连接对象-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mbs"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</bean>
<!--创建jdbcTemplate注入属性数据源-->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>
<!--事务的配置-->
<!--配置平台事务管理器-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!--配置事务增强-->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="transMoney" propagation="REQUIRED"/>
</tx:attributes>
</tx:advice>
<aop:config>
<!--通过Aop使用advice-ref对切点进行增强,相当于通知类型-->
<aop:pointcut id="transM" expression="execution(* com.wenjing.service..*(.. ))"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="transM"/>
</aop:config>
public class AccountServiceImpl implements AccountService {
private AccountDaoImpl accountDao;
public void setAccountDao(AccountDaoImpl accountDao) {
this.accountDao = accountDao;
}
@Override
public void transMoney(int in, int out, double money) {
accountDao.outmoney(out,money);
accountDao.inmoney(in,money);
}
}
方式三:声明式事务管理(注解)
@Transactional
public class AccountServiceImpl implements AccountService {
private AccountDaoImpl accountDao;
public void setAccountDao(AccountDaoImpl accountDao) {
this.accountDao = accountDao;
}
@Override
public void transMoney(int in, int out, double money) {
accountDao.outmoney(out,money);
int i=1/0;
accountDao.inmoney(in,money);
}
}
ApplicationConfig.xml
<!--配置dao对象 注入属性jdbcTemplate-->
<bean id="accountDao" class="com.wenjing.dao.impl.AccountDaoImpl">
<property name="jdbcTemplate" ref="jdbcTemplate"/>
</bean>
<!--配置service注入dao和事务管理模板-->
<bean id="accountService" class="com.wenjing.service.Impl.AccountServiceImpl">
<property name="accountDao" ref="accountDao"/>
</bean>
<!--数据源创建连接对象-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mbs"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</bean>
<!--创建jdbcTemplate注入属性数据源-->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>
<!--事务的配置-->
<!--配置平台事务管理器-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!--开启事务注解-->
<tx:annotation-driven transaction-manager="transactionManager"/>