Hi Ali,
If it is possible to describe more abt your project, at least the architecture.
With MVC u can have 2 approaches..
1. jsp(view), servlet(as controller) and javabean(as model).pass the request from the jsp to the servlet, let the servlet do the buisness logic processing and all the db related stuf including the db connection can be put in a bean and that can be invoked by the servlet, after processing the servlet picks up a jsp page for display.
2. A full jsp-centric architecture where
jsp(view)jsp(controller)and javabean(model)
3. A full servlet-centric architecture where
a servlet(view) servlet(controller) and
java classes/java bean as model.
4. An
EJB centric architecture
a) jsp(view)/servlet(controller and client to the EJB(Entity Bean..models data)
b) jsp as client to the EntityBean
U can make a decision based on the overall nature,no of users, data involved, transactions involved and take up any of the above approaches.
Rishi Singh
SCJP,SCWCD