A typical operation consists of the following steps:

Opening or fetching a connection
Identifying or preparing the query to execute
Preparing or adding all the dynamic parameters in the query
Executing the query or DML
Retrieving the result set (as appropriate)
Converting the result into appropriate data structure or DTO
Exception handling or clean up of the resources (like closing statements, connections, etc.)

A Data Access Layer already provides an abstraction for many of these aspects, but does it in their own specific manner. The DAF breaks the operational steps across the following key entities:

These classes effectively model the entire code sequence orpattern that a developer typically uses. All of them are within the package – com.intellectdesign.canvas.database. Now, let us look into each of these classes and their features.

View the following Pages

Browser not supported