java 批量处置

java 批量处理
public boolean iswhile(List<String> sql){
    boolean isTrue = false;
    Connection conn = null;
//    Statement stmt = null;
    PreparedStatement pstmt=null;
    try{
    conn = this.getConnection();
    conn.setAutoCommit(false);
    for(int i = 0;i<sql.size();i++){
    System.out.println("SQL " + sql.get(i));
    pstmt = conn.prepareStatement(sql.get(i));
    pstmt.addBatch();
    }
    pstmt.executeBatch();
    conn.commit();
    isTrue = true;
    }catch(Exception ex){
    try {
conn.rollback();
} catch (SQLException e) {
e.printStackTrace();
}
    }
   
    return isTrue;
    }