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

java語言MySQL批處理