This project implementation follows the Spring MVC configuration and setup presented in our section on the PWP (Chapter 1, Creating a Personal Web Portal (PWP)). The only formal addition in here, is the data layer part, since there will be a database management server involved in the operation of the whole SMP transactions, from login authentication, to archiving of records.
Two layers will be added into the implementation and these are the data access object layer and the service layer. We first set up the DAO layer, which is needed for data persistency. This is the only layer that directly accesses the database server, given the appropriate driver manager and credentials. All data objects contain SQL transactions that will directly access the database concerned. Generally, the DAO must be as light as possible to simply provide a connection to the database, but sometimes it is abstracted so there is a different database backend.
The other is the service layer. This...