JAVA-JDBC
New JAVA-JDBC - Persistence and Database Programming with JDBC Technology
Native JDBC and Spring JdbcTemplate, entities and their relationships, Spring Data JPA and Java EE environment
Description
The aim of this training is to demonstrate how to store and manage data in a relational database using Java platform with JDBC technology.
The training includes complex practical exercises using IntelliJ IDEA, Maven build tool, and MariaDB database.
Outline
- Database access from Java, the JDBC driver
- The java.sql package, DriverManager class, and Connection interface
- Using DataSource
- Schema initialization, Flyway and Liquibase
- Executing SQL queries, Statement and ResultSet interfaces
- Unit and integration testing
- Using generated identifiers
- Transaction management
- Handling BLOBs
- Spring JdbcTemplate
Prerequisites
Knowledge of the following topics is required: secure handling of development tools, packages, classes, interfaces, and exception handling.
Since part of the training materials is in English, basic English skills at the level of reading documentation are required. The training is conducted in Hungarian, based on Hungarian-language slides.