事务
要么都成功,要么都失败
ACID原则:保证数据的安全
开启事务
事务提交 commit()
事务回滚 rollback()
关闭事务
转账
A:1000
B:1000
A(900) --100--> B(1100)
Junit单元测试
-
依赖:
<!--单元测试--> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency>
-
简单使用:
@Test注解只有在方法上有效,只要加了这个注解的方法,就可以直接运行(以前是通过main方法调用)
@Test public void test() { System.out.println("Hello"); }
运行成功是绿色的
运行失败是红色的
搭建一个环境:
1)sql
CREATE TABLE ACCOUNT (
id INT PRIMARY KEY AUTO_INCREMENT,
`name` VARCHAR(40),
money FLOAT
);
INSERT INTO `account`(`name`,money) VALUES ('A',1000);
INSERT INTO `account`(`name`,money) VALUES ('B',1000);
INSERT INTO `account`(`name`,money) VALUES ('C',1000);
start transaction ;#开启事务
update account set money = money-100 where name='A';
update account set money = money+100 where name='B';
rollback ;
commit ;
2)核心代码
TestJdbc3.java
package com.gongyi.test;
import org.junit.Test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class TestJdbc3 {
@Test
public void test() {
System.out.println("Hello");
System.out.println(1 / 0);
}
@Test
public void testTransaction() {
//配置信息
//useUnicode=true&characterEncoding=utf-8 解决中文乱码
String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
String username = "root";
String password = "123456";
Connection connection = null;
try {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.连接数据库,代表数据库
connection = DriverManager.getConnection(url, username, password);
//3.通知数据库开启事务,false-开启
connection.setAutoCommit(false);
String sql = "update account set money = money-100 where name='A'";
connection.prepareStatement(sql).executeUpdate();
//制造错误
//int i = 1/0;
String sql2 = "update account set money = money+100 where name='B';\n";
connection.prepareStatement(sql2).executeUpdate();
connection.commit();//以上两条sql都执行成功了,就提交事务
System.out.println("success");
} catch (Exception e) {
try {
//如果出现异常,就通知数据库回滚事务
connection.rollback();
System.out.println("rollback");
} catch (SQLException ex) {
ex.printStackTrace();
}
} finally {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
彩蛋
1.junit单元测试
2.mysql注释