addBatch()와 executeBatch() 의 사용

1. Statement  객체

Statment stmt = con.getStatement();
stmt.addBatch(sql statment);
stmt.addBatch(sql statment);
stmt.addBatch(sql statment);
stmt.addBatch(sql statment);
..
int[] insCounts = stmt.executeBatch();


2. PrearedStatement  객체

preparedStatement pstmt  = con.prepareStatement("DELETE FROM member_t WHERE no = ?");
for (int i = 0; i < 10; i++){
    pstmt.setInt(1, n);
    pstmt.addBatch();
}
int[] delCounts = pstmt.executeBatch();


3. CallableStatement  객체

CallableStatement cstmt = con.prepareCall("{call updatePrices(?,?)}");
cstmt.setString(1, "Colombian");
cstmt.setFloat(2, 8.49f);
cstmt.addBatch();

cstmt.setString(1, "Colombian_Decaf");
cstmt.setFloat(2, 9.49f);
cstmt.addBatch();

int[] updateCounts = cstmt.executeBatch();

참조: http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/callablestatement.html
출처: http://blog.naver.com/jeany4u?Redirect=Log&logNo=30005287885