Search:

I believe that you can use the same Statement, I think as long as you don't close it or the connection. What happens if you try this?

How can you have one ResultSet from different queries? A query will generate a ResultSet, and so I'm confused by your statement.