Can i use the same statement and resultset objects for executing multiple query?

[RadhaJayalakshmi]

hi,
i just want to know whether, i can use the same statement and resultset objects for execuing multiple query? The scenario is like this

try{
// Get the connection object
//Declare resultset
//declare statement

String queryA="select * from xyz";
String queryB = "select * from abc";

//Executing first query
stmt = conn.createStatement();
rs = stmt.executeQuery(queryA);

*******************
// DO I NEED TO CLOSE THE STATEMENT AND RESULTSET EXPLICITLY BEFORE RE-USING IT?
rs.close();
stmt.close();
*******************

//Executing the second query
***************************
//SINCE I HAVE CLOSED THE STATEMENT, I AM CREATING IT AGAIN
stmt=conn.createStatement();
**************************
stmt = conn.createStatement();
rs = stmt.executeQuery(queryA);


}catch(Exception e){
// some code here
}finally{
//code to close statement, resultset, connection
}

[masijade]

No, you don't need to close it (you probably should close the rs though, wrapping it in a separate try/catch block just for all eventuallities).

[skaspersen]

You can re-use the statement, you do however want to close the resultset as soon as you are done with it

If your application makes use of the DB regularly I would also hold on to the connection and only close it when the application closes.