JDK 6 does not support Statement and ResultSet. What can I use instead of these?

Question

I want to use

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

.
.
.


 try (Statement stmt = connection.createStatement()) {

               try (ResultSet rset = stmt.executeQuery(url)) {
                    while (rset.next()) { 
                    System.out.println (rset.getString(1)); 
                        }
                }
           }

in jdk 6. But it says that this is not supported. What can I do?

Is this real code snippet? It won't compile. Can you please post the import statements also? — Bharat Sinha, Aug 11 '12 at 16:02
I don't think it's the Statement or ResultSet, it's the try/catch blocks. try { } catch ( e) { } — ksnortum, Aug 11 '12 at 16:04
ooo :( yes it s because of try catch . when i deleted it works. answer and I tick it — CompEng, Aug 11 '12 at 16:08

score 5 · Accepted Answer · edited May 23 '17 at 11:48

That's try-with-resource which is a new feature in Java SE 7. In Java SE 6 (recently had a life extension into next year, but I wouldn't write new code for it):

Statement stmt = connection.createStatement() {
try {
    ResultSet rset = stmt.executeQuery(url)
    try {
        while (rset.next()) { 
            System.out.println (rset.getString(1)); 
        }
    } finally {
        rset.close();
    }
} finally {
    stmt.close();
}

You can use the Execute Around idiom to factor out to repetitive bits.

Anthony Accioly · Answer 2 · 2012-08-11T18:13:40.577

Try-with-resources is a feature introduced with Java 7. You need to manage your resources by hand.

Statement stmt = null;
ResultSet rset = null;
try {
   stmt = connection.createStatement();
   rset =  stmt.executeQuery(url);
   while (rset.next()) { 
      System.out.println(rset.getString(1)); 
   }
} catch (Exception e) {
   // In your real code catch expecific exceptions and do something about it.
} finally {
   if (rset != null) {
       try { 
          rset.close(); 
       } catch (Exception e) {} // Same thing 
   }
   if (stmt != null) {
       try {
          stmt.close();
       } catch (Exception e) {} // Same thing 
   }
}

Alternatively use a library such as Apache dbutils or better yet Spring Framework JDBC to avoid the boilerplate code.

JDK 6 does not support Statement and ResultSet. What can I use instead of these?

2 Answers2