We want to build an Application using JSP and Servlets in Websphere environment. Our application will have about 150 tables. One method we are considering is to have the Servlet as the controlling module, JSP for the presentation. All the business logic will be placed in a bean which will be accessed from JSP. It will be very helpful if you can suggest any other possible methods to implement.
The above design is the standard web application design pattern called the model-view-controller (MVC) pattern. As you stated the JSP's provide the view, the servlet is the controller and the bean represents the model. You may want to think about implementing three types of beans; command, view and data beans. The command bean will control the processing of the business logic either by implementing the logic or delegating to back end systems. A view bean would serve as an intermediary (provide the 'contract') between the JSP's(which display the output) and the data beans which have the data to be displayed in the output. The data bean has the results of the processing performed by the command bean or the back end system.