The data access layer is made up of DAO classes that manipulate the database via the JDBC API. SQL code is stored in XML files as SQL templates and DSO classes are used to specify what related data to load for a query.
DAO DSO SQL template