springboot 事务手动回滚_SpringBoot事务简单操作及手动回滚

一、引入依赖

org.springframework.boot

spring-boot-starter

org.springframework.boot

spring-boot-starter-data-jdbc

mysql

mysql-connector-java

5.1.48

org.springframework.boot

spring-boot-starter-test

二、application.properties

spring.datasource.url=jdbc:mysql://192.168.178.5:12345/mydb?characterEncoding=UTF-8

spring.datasource.username=root

spring.datasource.password=123456

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.type=com.zaxxer.hikari.HikariDataSource

三、dao和service代码

1. dao

student接口

public interface StudentDao {

void saveStudent();

}

student实现类

@Repository

public class StudentDaoImpl implements StudentDao{

@Autowired

private JdbcTemplate jdbcTemplate;

public void saveStudent(){

String sql = "insert into student(name, s_class) values(?,?"; //这里会出现一个错误,少了右括号

List sqlParamList = new ArrayList();

sqlParamList.add("stn-"+Math.random());

sqlParamList.add(20);

jdbcTemplate.update(sql, sqlPar