Everything you need to know about JDBC

Name: Everything you need to know about JDBC
Rating: 4.9 (17 reviews)

Connecting Java applications to an RDBMS using JDBC API

Created byVinod Kumar Kayartaya

Last updated 5/2020

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

Course content

5 sections • 13 lectures • 1h 30m total length

Overview of JDBC4:36
Working of JDBC application4:22

Connecting to H2 database12:53
Set up a Java project in Eclipse and add the H2 database driver. Load the driver class and connect with DriverManager using the connection string, username, and password.
DbUtil class6:45
Create a final DBUtil class with a private constructor and static getConnection to load the driver and open a JDBC connection using a properties file.
Create table10:15
Create a table from a Java program using a try-with-resources block to manage the JDBC connection and statement, executing a create table command on an H2 database.
Insert a record10:05
Insert a record into the products table from the Java application using JDBC, reading user input via a keyboard utility, and discuss SQL injection risks and shift to prepared statements.
Insert record using PreparedStatement5:54
Batch execution5:47
Get multiple records from DB6:39
Retrieve multiple records from a database using JDBC by executing a select query with a prepared statement and iterating the result set to print product names and prices.
Get single record from DB5:49
Learn to fetch a single product record from the database using a prepared statement with a parameter placeholder, safely handling zero or one result.

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

Everything you need to know about JDBC

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 9min

Software setup1 lecture • 8min

Coding JDBC8 lectures • 1hr 4min

A bit advanced topics1 lecture • 9min

Finally...1 lecture • 1min

Requirements

Description

Who this course is for: