You can have one connection  and use multiple statements  on it as long as u dont
close the connection. And coming to the resultsets, All execution methods in the
Statement interface implicitly close a statment's current ResultSet object  if an
open one exists. if you have to use the resultset  again use different statement
objects on it. It will work.