Java MySQL batch processing and javamysql Batch Processing

Java MySQL batch processing and javamysql Batch Processing

In essence, it is to use the addBatch () method of Statement and PreStatement.

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="insert into student(name,major,score) values(?,?,?);";pstam=conn.prepareStatement(sql);pstam.setString(1, "f");pstam.setString(2,"History");pstam.setInt(3, 67);pstam.addBatch();pstam.setString(1, "h");pstam.setString(2, "Biology");pstam.setInt(3, 85);pstam.addBatch();pstam.executeBatch();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();}}}