java mysql批处理_java语言MySQL批处理

import java.sql.*;

public class GetConnection{

public static void main(String[] args){

Access2Database adb=new Access2Database();

Connection conn=adb.getConn();

//transaction dealing

PreparedStatement 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 block

e1.printStackTrace();

}

e.printStackTrace();

}finally{

try {

conn.setAutoCommit(true);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

//release the resource of the program

try{

pstam.close();

conn.close();

}catch(SQLException e){

e.printStackTrace();

}

}

}