Connecting Java applications to an RDBMS using JDBC API
Free tutorial
Created by Vinod Kumar Kayartaya
English
What you’ll learn
- JDBC Architecture and API
- Setting up H2 Database
- Connecting Java applications to an RDBMS
- Executing SQL commands
- Handling result of SQL SELECT statements
- Handling auto-incrementing primary key fields
Requirements
- Basic knowledge of Java programming language
- Very basic knowledge of RDBMS and SQL commands would be helpful
Description
JDBC (Java DB Connectivity) is a Java Standard API for connecting a Java application to an RDBMS. Although you may not need to use JDBC directly in any application today, it is important to understand how it works. Any modern frameworks like Hibernate or JPA which are ORM (Object-Relation-Mapper) or Mybatis which is an SQL mapper, behind the scene use JDBC.
In this class, we will be looking into the architecture of a JDBC application, connecting to a DB, executing SQL statements, and handling the results of SQL SELECT statements. We will also be learning how to setup a light weight DB called H2, with out having to install anything on our computer.
The class is completely hands-on based, so get ready to code a lot.
Who this course is for:
- A beginner to Java programming
- Developer looking to execute SQL commands using native Java API
Show less
Course content
5 sections • 13 lectures • 1h 30m total lengthCollapse all sections
Introduction2 lectures • 9min
- Overview of JDBC04:36
- Working of JDBC application04:22
Software setup1 lecture • 8min
- Setup H2 Database07:42
Coding JDBC8 lectures • 1hr 4min
- Connecting to H2 database12:53
- DbUtil class06:45
- Create table10:15
- Insert a record10:05
- Insert record using PreparedStatement05:54
- Batch execution05:47
- Get multiple records from DB06:39
- Get single record from DB05:49
A bit advanced topics1 lecture • 9min
- Get auto generated primary key09:20
Finally…1 lecture • 1min
- Thank you note and bonus lecture00:44