<!--事務管理器-->
  <bean id="springTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource" />
  </bean>
  <!--數(shù)據(jù)源-->
  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver" />
    <property name="url" value="jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8" />
    <property name="username" value="root" />
    <property name="password" value="123456" />
  </bean>
  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <!-- 指定sqlMapConfig總配置文件，訂制的environment在spring容器中不在生效-->
    <!--指定實體類映射文件，可以指定同時指定某一包以及子包下面的所有配置文件，mapperLocations和configLocation有一個即可，當需要為實體類指定別名時，可指定configLocation屬性，再在mybatis總配置文件中采用mapper引入實體類映射文件 -->
    <!--<property name="configLocation" value="classpath:fwportal/beans/dbconfig/mybatis.xml" />-->
    <property name="mapperLocations" value="classpath:mapper/*.xml" />
  </bean>
  <!--將DAO接口注冊為BEAN-->
  <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="basePackage" value="TRANSACTION.DAO" />
  </bean>

@Test
  public void testDelete() throws Exception {
	ApplicationContext context = new ClassPathXmlApplicationContext("mysqltransaction.xml");
	DataSourceTransactionManager springTransactionManager = (DataSourceTransactionManager) context.getBean("springTransactionManager");
	DefaultTransactionDefinition def = new DefaultTransactionDefinition();
	def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
	//開啟事務
	TransactionStatus status = springTransactionManager.getTransaction(def);
	final StudentDAO dao = (StudentDAO)context.getBean("studentDAO");
	try {
		dao.delete(2L);
	}
	catch (Exception ex) {
		springTransactionManager.rollback(status);
		//事務回滾
		throw ex;
	}
	springTransactionManager.commit(status);
	//事務提交
}