try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
stmt.executeUpdate(sql);
conn.close();
}catch(SQLException ex){
System.out.println("sql.executeUpdate:"+ex.getMessage());
}
}finally{
if(stmt!=null)
stmt=null;
if(con!=null)
con=null;
}
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
stmt.executeUpdate(sql);
conn.close();
}catch(SQLException ex){
System.out.println("sql.executeUpdate:"+ex.getMessage());
}
}finally{
if(stmt!=null)
stmt=null;
if(con!=null)
con=null;
}
finally{
if(stmt!=null)
stmt=null;
if(con!=null)
con.close();
}