I want to create a simple jsp page which shows data from a table on the page. There will be buttons on the form to insert/update and delete records from the table.
I need to break the logic up into a 3 tier model, effectively I want the user interface seperate from the business logic, seperate from the database logic.
I need some ideas on how to accomplish this.
Can I use a normal bean to hold the business logic? This business logic bean will then be called directly from the form if the user presses say the add record button. From the business logic bean, the database bean will be called which will run the stored proc / queries etc, and return the resultsets in an arraylist back to the logicbean, which will in turn return the arraylist back for display to the jsp page?
Any ideas please.