java語言MySQL批處理

java語言MySQL批處理

本質來講就是使用Statement和PreStatement的addBatch()方法

代碼

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();
		}
	}
}