Java MySQL database transaction processing, javamysql

Java MySQL database transaction processing, javamysql

Transaction Processing Process

1. Disable the automatic submission Function

2. process transactions

3. Restore the automatic submission Function

Code instance

Data Table before executing the program

<pre name="code" class="java">import java.sql.*;public class GetConnection{public static void main(String[] args){Access2Database adb=new Access2Database();Connection conn=adb.getConn();//transaction dealingPreparedStatement pstam=null;try{conn.setAutoCommit(false);String sql="delete from student where name='a' and major=?";pstam=conn.prepareStatement(sql);pstam.setString(1, "Chinese");pstam.executeUpdate();conn.rollback();conn.commit();}catch(SQLException e){try {conn.rollback();} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}e.printStackTrace();}finally{try {conn.setAutoCommit(true);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}//release the resource of the programtry{pstam.close();conn.close();}catch(SQLException e){e.printStackTrace();}}}

Later

As you can see, the transaction is rolled back successfully.

========================================================== ====================================

In addition, the application can also save the intermediate state of transaction processing and restore to this intermediate state of storage.

Status before data table

View code

import java.sql.*;public class GetConnection{public static void main(String[] args){Access2Database adb=new Access2Database();Connection conn=adb.getConn();//transaction dealingPreparedStatement pstam=null;try{conn.setAutoCommit(false);String sql="delete from student where name='a' and major=?";pstam=conn.prepareStatement(sql);pstam.setString(1, "Chinese");pstam.executeUpdate();//conn.commit();Savepoint sp=conn.setSavepoint();sql="insert into student(name,major,score) values('g','Math','99');";pstam=conn.prepareStatement(sql);pstam.executeUpdate();conn.rollback(sp);conn.commit();}catch(SQLException e){try {conn.rollback();} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}e.printStackTrace();}finally{try {conn.setAutoCommit(true);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}//release the resource of the programtry{pstam.close();conn.close();}catch(SQLException e){e.printStackTrace();}}}