Closing ResultSet and Statement?

[Mick Sullivan]

Hi
Does anyone know how to close a ResultSet?
Heres my code:
public String getName() throws Exception {
                Statement statement = connection.createStatement();
                int myInt = 1;
                ResultSet rs = statement.executeQuery("SELECT Name"+
                " FROM nameAddress" +
                " WHERE ID = ("+
                myInt + ")");
                rs.next();
                String myString = rs.getString("Name");
                 //change the resultSet to a string
                 //so it can be used by the jsp page
                return myString;
      }
Any help at all would be much appreciated
Thanks in advance,
Mick



_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.