Data Access with JDBC

The value provided by the TODAY Framework JDBC abstraction is perhaps best shown by the sequence of actions outlined in the following table below. The table shows which actions Infra takes care of and which actions are your responsibility.

Table 1. Infra JDBC - who does what?
Action	Infra	You
Define connection parameters.		X
Open the connection.	X
Specify the SQL statement.		X
Declare parameters and provide parameter values		X
Prepare and run the statement.	X
Set up the loop to iterate through the results (if any).	X
Do the work for each iteration.		X
Process any exception.	X
Handle transactions.	X
Close the connection, the statement, and the resultset.	X

The TODAY Framework takes care of all the low-level details that can make JDBC such a tedious API.