JDBC4.1 supports try-with-resource statement.
- Try-with-resource Automatically close connection, statement and resultset regardless of sqlexception
public static void fetchData(Connection conn) throws SQLException {
final String qry = "select rank from student" ;
try(PreparedStatement stmt = conn.prepareStatement(qry)) {
ResultSet rs = stmt.executeQuery() ;
while(rs.next()){
System.out.println(rs.getInt(1)) ;
}
}
}
- Try-with-resource Automatically close connection, statement and resultset regardless of sqlexception
public static void fetchData(Connection conn) throws SQLException {
final String qry = "select rank from student" ;
try(PreparedStatement stmt = conn.prepareStatement(qry)) {
ResultSet rs = stmt.executeQuery() ;
while(rs.next()){
System.out.println(rs.getInt(1)) ;
}
}
}
No comments:
Post a Comment