一、编程式事务管理
1、新建动态web项目“11-6”,并导入相应的jar包
2、applicationContext.xml,需要提供mysql密码
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<!-- 配置数据源 -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/how2java
</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>123456</value>
</property>
</bean>
<!-- 定义TransactionTemplate模板 -->
<bean id="transactionTemplate" class="org.springframework.transaction.support.TransactionTemplate">
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>
<property name="propagationBehaviorName">
<value>PROPAGATION_REQUIRED</value>
</property>
</bean>
<!-- 定义事务管理器 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref bean="dataSource" />
</property>
</bean>
<!-- 为TransactionExample注入数据源 、事务管理器、TransactionTemplate模板-->
<bean id="transactionExample"
class="com.mr.transaction.TransactionExample">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="transactionTemplate">
<ref bean="transactionTemplate"/>
</property>
</bean>
</beans>
在Spring的配置文件中声明事物管理器和TransactionTemplate,关键代码如下:
<!-- 定义TransactionTemplate模板 -->
<bean id="transactionTemplate" class="org.springframework.transaction.support.TransactionTemplate">
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>
<property name="propagationBehaviorName">
<value>PROPAGATION_REQUIRED</value>
</property>
</bean>
<!-- 定义事务管理器 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref bean="dataSource" />
</property>
</bean>
2、创建类TransactionExample,定义添加数据的方法,在方法中执行两次添加数据库操作并用事务保护操作,代码如下
package com.mr.transaction;
import java.sql.Connection;
import java.sql.Statement;
import javax.sql.DataSource;
import org.springframework.jdbc.datasource.DataSourceUtils;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.TransactionCallback;
import org.springframework.transaction.support.TransactionTemplate;
public class TransactionExample {
DataSource dataSource;//注入数据源
PlatformTransactionManager transactionManager;//注入事务管理器
TransactionTemplate transactionTemplate;//注入TransactionTemplate模板
public DataSource getDataSource() {
return dataSource;
}
public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
}
public PlatformTransactionManager getTransactionManager() {
return transactionManager;
}
public void setTransactionManager(PlatformTransactionManager transactionManager) {
this.transactionManager = transactionManager;
}
public TransactionTemplate getTransactionTemplate() {
return transactionTemplate;
}
public void setTransactionTemplate(TransactionTemplate transactionTemplate) {
this.transactionTemplate = transactionTemplate;
}
public void transactionOperation() {
transactionTemplate.execute(new TransactionCallback() {
public Object doInTransaction(TransactionStatus status) {
Connection conn = DataSourceUtils.getConnection(dataSource);//获得数据库连接
try {
Statement stmt = conn.createStatement();
//执行两次添加方法
stmt.execute("insert into tb_user(name,age,sex) values('小强','26','男')");
int a=0;//制造异常测试事务是否配置成功
a=9/a;
stmt.execute("insert into tb_user(name,age,sex) values('小红','22','女')");
System.out.println("操作执行成功!");
} catch (Exception e) {
transactionManager.rollback(status);//事务回滚
System.out.println("操作执行失败,事务回滚!");
System.out.println("原因:"+e.getMessage());
}
return null;
}
});
}
}
3、创建Manager类
package com.mr.main;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.mr.transaction.TransactionExample;
public class Manager {
public static void main(String[] args) {
ApplicationContext factory = new ClassPathXmlApplicationContext("applicationContext.xml"); //装载配置文件
TransactionExample transactionExample = (TransactionExample) factory.getBean("transactionExample");//获取UserDAO
transactionExample.transactionOperation();//执行添加方法
}
4、问题:
第一运行时报错,提示说不存在有一个名为test的数据库有一个tb_user的数据表,于是我回想起来我的tb_user表是建立在how2java数据库里的
于是我更换了一下数据表的路径
后面再运行就没得问题了
二、声明式事物管理
1、新建动态web项目,并导入jar包
2、applicationContext.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"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<!-- 配置数据源 -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/how2java</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>123456</value>
</property>
</bean>
<!-- 定义事务管理器 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref bean="dataSource" />
</property>
</bean>
<!-- 定义TransactionProxy -->
<bean id="transactionProxy"
class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref local="transactionManager" />
</property>
<property name="target">
<bean id="addDAO" class="com.mr.dao.AddDAO">
<property name="dataSource">
<ref local="dataSource" />
</property>
</bean>
</property>
<property name="proxyTargetClass" value="true" />
<property name="transactionAttributes">
<props>
<prop key="add*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>
</beans>
3、操作数据库的AddDAO类,指定了事务属性
package com.mr.dao;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import com.mr.user.User;
public class AddDAO extends JdbcDaoSupport {
//添加用户的方法
public void addUser(User user){
//执行添加方法的sql语句
String sql="insert into tb_user (name,age,sex) values('" +
user.getName() + "','" + user.getAge()+ "','" + user.getSex()+ "')";
//执行两次添加方法
getJdbcTemplate().execute(sql);
int a=0;//制造异常测试事务是否配置成功
a=9/a;
getJdbcTemplate().execute(sql);
}
}
4、创建类Manager
package com.mr.main;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.mr.dao.AddDAO;
import com.mr.user.User;
public class Manager {
public static void main(String[] args) {
ApplicationContext factory = new ClassPathXmlApplicationContext("applicationContext.xml"); //装载配置文件
AddDAO addDAO = (AddDAO)factory.getBean("transactionProxy");//获取AddDAO
User user = new User();//实例化User实体对象
user.setName("明日");//设置姓名
user.setAge(30);//设置年龄
user.setSex("男");//设置性别
addDAO.addUser(user);//执行数据库添加方法
}
}
5、运行得到