Spring声明式事务:环境搭建、配置文件的编写以及测试修改两张表(Idea)

环境搭建

数据源:c3p0
数据库:Mysql8
数据表:任意两张表即可,sql是修改操作的

创建Maven项目

在这里插入图片描述

导入相关依赖
 <!--导入Spring的核心jar包-->
      <!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-context</artifactId>
          <version>5.2.7.RELEASE</version>
      </dependency>

      <!--c3p0管理数据库连接池-->
      <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
      <dependency>
          <groupId>com.mchange</groupId>
          <artifactId>c3p0</artifactId>
          <version>0.9.5.2</version>
      </dependency>

      <!--数据库-->
      <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
      <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.13</version>
      </dependency>

        <!--spring的jdbc-->
      <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-jdbc</artifactId>
          <version>5.2.7.RELEASE</version>
      </dependency>
      <!--spring的orm包-->
      <!-- https://mvnrepository.com/artifact/org.springframework/spring-orm -->
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-orm</artifactId>
          <version>5.2.7.RELEASE</version>
      </dependency>


      <!--spring的事务相关-->
      <!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-tx</artifactId>
          <version>5.2.7.RELEASE</version>
      </dependency>

      <!--与junit整合-->
      <!-- https://mvnrepository.com/artifact/org.springframework/spring-test -->
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-test</artifactId>
          <version>5.2.7.RELEASE</version>
          <scope>test</scope>
      </dependency>

      <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>
编写dao层

两个dao方法操作两张表

package com.xzy.dao;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

@Repository
public class ScoreDao {
    @Autowired
    JdbcTemplate jdbcTemplate;

    public void updateScore(){
        String sql = "UPDATE score SET scoreid=1,scorenum=88 WHERE scoreid=1";
        jdbcTemplate.update(sql);
    }
}
import org.springframework.stereotype.Repository;

@Repository
public class StuDao {

    @Autowired
    JdbcTemplate jdbcTemplate;

    public void updateStu(){
        String sql = "UPDATE stu SET stuname ='hello',stuage=15 WHERE stuid=1";
        jdbcTemplate.update(sql);
    }
}
编写配置文件

jdbcConfig配置文件

user=root
password=*******
jdbcUrl=jdbc:mysql://localhost:3306/XXX?characterEncoding=UTF8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
driverClass=com.mysql.cj.jdbc.Driver

spring 的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"
       xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">

    <context:component-scan base-package="com.xzy"></context:component-scan>
    <!--引入外部的配置文件-->
    <context:property-placeholder location="classpath:jdbcConfig.properties"/>
    <bean id="pooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="user" value="${user}"/>
        <property name="password" value="${password}"/>
        <property name="jdbcUrl" value="${jdbcUrl}"/>
        <property name="driverClass" value="${driverClass}"/>
    </bean>
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="pooledDataSource"/>
    </bean>

    <!--配置事务-->
    <!--1:配置事务管理器让其管理事务-->
    <bean id="sourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <!--控制数据源-->
        <property name="dataSource" ref="pooledDataSource"></property>
    </bean>
    <!--2:开启基于注解的事务模式-->
    <tx:annotation-driven transaction-manager="sourceTransactionManager"/>
    <!--3:给事务方法添加注解-->

</beans>
编写Service层

一个service方法

package com.xzy.service;

import com.xzy.dao.ScoreDao;
import com.xzy.dao.StuDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service
public class Transactions {
    @Autowired
    StuDao stuDao;
    @Autowired
    ScoreDao scoreDao;
    //注解 @Transactional 标注这个方法是一个事务方法
    
    /**@Transactional 的属性
     * isolation            事务的隔离级别
     * propagation          事务的传播行为
     *
     * rollbackFor          哪些异常事务可以不回滚
     * rollbackForClassName 
     *
     * noRollbackFor        哪些异常事务需要回滚
     * noRollbackForClassName
     * 
     * readOnly-boolean     设置只读
     * timeOut              超出指定时长停止事务并回滚
     */
    @Transactional
    public void updateTwoTable(){
        stuDao.updateStu();
        scoreDao.updateScore();
    }
}

此时,service中标注了注解的方法已经加上了事务,要么都成功,要么都失败。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值