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