Can I use more than one Resultset objects through as many Statement objects using a single Connection object...when i am doing this ,there is an error message" connection is already busy with another statement". Please help me to sort it out
You can have multiple statements on one connection (though only one resultset per connection, normally), but seemingly, your connection can only have one statement active at the same time. Are you, per chancce, using the JDBC-ODBC Bridge, if so take a look at this: http://java.sun.com/products/jdbc/faq.html#15
If they are coming from the same statement, no. The API clearly says that any time a statement executes a query, all previous resultsets will be closed. Multiple statements on the same connection will allow you to have multiple resultsets. One per statement. However, as has been pointed out, if you are using the JDBC-ODBC bridge you may only have one statement at a time.
What DB are connecting to, and what Driver are you using?