JavaWeb_JDBC事务

junit单元测测试

1.依赖

<!--        单元测试-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>

1.1成功

@Test
    public void test(){
        System.out.println("Hello");
    }

2.sql搭建

CREATE TABLE accout(
	id INT PRIMARY KEY AUTO_INCREMENT,
	`name` VARCHAR(40),
	money FLOAT
);
INSERT INTO accout(`name`,money) VALUE('A',1000);
INSERT INTO accout(`name`,money) VALUE('B',1000);
INSERT INTO accout(`name`,money) VALUE('C',1000);

3.事务

package com.king.test;

import org.junit.Test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class TestJdcb3 {

    @Test
    public void test(){
        //配置信息
        //useUnicode=true&characterEncoding=utf8解决中文乱码
        String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf8";
        String username = "root";
        String password = "123456";


        Connection connection = null;

        //1.加载驱动
        try {
            Class.forName("com.mysql.jdbc.Driver");
            //2.连接数据库,代表数据库
            connection = DriverManager.getConnection(url, username, password);
            //3.通知数据库开启事务,false开启
            connection.setAutoCommit(false);

            String sql = "update jdbc.accout set money = money-100 where name = 'A'";
            connection.prepareStatement(sql).executeUpdate();

            //制造错误
            //int i = 1/0;

            String sql2 = "update jdbc.accout set money = money+100 where name = 'B'";
            connection.prepareStatement(sql2).executeUpdate();

            connection.commit();//以上两条SQL都执行成功，就提交事务
            System.out.println("success");
        } catch (Exception e) {
            try {
                //如果出现异常，就通知数据库回滚事务
                connection.rollback();
            } catch (SQLException e1) {
                e1.printStackTrace();
            }
            e.printStackTrace();
        }finally {
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}