mysql and jdbc

From: yasaswi (yasaswi_at_encfor.com)
Date: 03/28/05 

Date: 28 Mar 2005 08:32:12 -0800

In the mysql database I have, after I get some values from 3 tables, I
have to get few more values from other tables, based on the values I
obtained in the first run. In a case like this, can I pass the
java.sql.Connection as a variable, between my methods.
In other words, can I dedicate each method to go and fetch some
specific data from the mysql database. I am using a DBCP connection
pool, but still, instead of using a new Connection in each method, can
a pass a java.sql.Connection to the methods?
Thanks,
Yasaswi