Goals
- Master access to databases in Java using JDBC
Program
JDBC: presentation of the API, types of drivers (1-4), modes
Loading JDBC drivers
Direct access or through a Datasource configured on the server side.
Connection to various data sources with a Java driver
Recovery of a connection
Interactions with the database:
– simple requests: Statement
– requests with parameters: PreparedStatement
– execution of procedures: CallableStatement
Execution and processing / browsing of results
Connection management: open / close, connection pool
Transaction
management Exception management: types, capture and processing
Automatic resource release (try-with-resources)
DAO pattern: principle, class diagram
Implementation of a singleton for the connection
Construction of the DAO interface and implementation
Outsourcing of the configuration in .properties files
Duration
2 days
Price
£ 1241
Audience
Developers, project managers
Prerequisites
Have followed the "Java initiation" course or have equivalent knowledge - Notions of SQL
Reference
JAV100308-F
Sessions
Contact us for more informations about session date