Connections issue

[Miltos Tereres]

Hello...
I have some classes within my model...which do some tasks..
For connections i use apache connection pooling stuff....
My question is..

   
class myServlet
{
      list=customers.getblabla();
      list=products.getall();

} 

getblabla() and getall() is ok to get a new connection from the pool ? Is there a better way to just use one connection as long as the servlet is being executed?

[Sagar Rohankar]

As you're using DBCP, then getting and releasing connection object in each method is good and widely used technique.
Actually, what you need is good tutorial on DAO and DTO, for this, follow:
http://balusc.blogspot.com/2008/07/dao-tutorial-data-layer.html