java中批处理

 

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

 

 

public class Oraclebatch {

private static Connection conn = null;

static {

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection(

"jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

 

public static void main(String[] agrs) {

String sql = "insert into userinfo values(?,?)";

PreparedStatement pstmt = null;

 

try {

pstmt = conn.prepareStatement(sql);

pstmt.setInt(1, 5);

pstmt.setString(2, "aa");

pstmt.addBatch();

 

pstmt.setInt(1, 6);

pstmt.setString(2, "bb");

pstmt.addBatch();

 

pstmt.executeBatch();//执行批处理语句

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

 

}

}