Hello...
I have some classes within my model...which do some tasks..
For connections i use apache connection pooling stuff....
My question is..
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?
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