Java代码增加回滚6_Java如何使用保存点和回滚操作？

在Java编程中，如何使用保存点和回滚操作？假定数据库名称是：testdb，其中有两张表:employee和dept，employee表中有4条记录,dept表中有2条记录。

创建数据库表的语句 -

use testdb;

-- 员工表

drop table if exists employees;

create table if not exists employees (

id int not null primary key,

age int not null,

name varchar(64),

dept_id int(10)

);

INSERT INTO employees VALUES (100, 28, 'MaxSu', 1);

INSERT INTO employees VALUES (101, 25, 'WeiWang', 2);

INSERT INTO employees VALUES (102, 30, 'KidaSu', 2);

INSERT INTO employees VALUES (103, 28, 'KobeBryant', 1);

----

-- 部门表

drop table if exists dept;

create table if not exists dept (

id int not null primary key,

name varchar (64)

);

INSERT INTO dept VALUES (1, '技术部');

INSERT INTO dept VALUES (2, '市场部');

以下示例使用Rollback()方法将Rollback连接到先前保存的保存点(SavePoint)。

package com.yiibai;

import java.sql.*;

public class UseOfSavepointRollback {

public static void main(String[] args) throws Exception {

String JDBC_DRIVER = "com.mysql.jdbc.Driver";

String DB_URL = "jdbc:mysql://localhost/testdb?useSSL=false";

String User = "root";

String Passwd = "123456";

try {

Class.forName(JDBC_DRIVER);

} catch (ClassNotFoundException e) {

System.out.println("Class not found " + e);

}

Connection con = DriverManager.getConnection(DB_URL, User, Passwd);

Statement stmt = con.createStatement();

String query1 = "INSERT INTO employees(id,age,name,dept_id) VALUES (109, 25, 'TestSavePoint', 2);";

String query2 = "select * from employees";

con.setAutoCommit(false);

Savepoint spt1 = con.setSavepoint("myspt1");

stmt.execute(query1);

ResultSet rs = stmt.executeQuery(query2);

int no_of_rows = 0;

while (rs.next()) {

no_of_rows++;

}

System.out.println("rows before rollback statement = " + no_of_rows);

con.rollback(spt1);

con.commit();

no_of_rows = 0;

rs = stmt.executeQuery(query2);

while (rs.next()) {

no_of_rows++;

}

System.out.println("rows after rollback statement = " + no_of_rows);

}

}

上述代码示例将产生以下结果。

rows before rollback statement = 5

rows after rollback statement = 4

注：如果JDBC驱动程序安装不正确，将获得ClassNotfound异常。

Class not found java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

JDBC Class found

SQL exception occuredjava.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/testdb

¥ 我要打赏

纠错/补充

收藏

加QQ群啦，易百教程官方技术学习群

注意：建议每个人选自己的技术方向加群，同一个QQ最多限加 3 个群。