JDBC Tutorial - Crash Course

Опубликовано: 20 Май 2022
на канале: Marco Codes
27,264
782

Ever looked for a comprehensive intro to JDBC that is fun and entertaining at the same time? Then have a look at this brand-new episode of "Marco Codes": JDBC Tutorial [Crash Course].

In this video, you'll learn how to use JDBC, i.e. the basic API that every Java program uses to access databases. Understand what JDBC drivers are and where to get them. How to use an embedded H2 database, in addition to the usual suspects like MySQL or Postgres. Fire off SQL select, insert, update and delete statements from Java. And finally learn about connection pools and the overall Java database framework/library landscape. By the end of the tutorial, there won't be many questions left when it comes to accessing databases with Java.


► References
https://jb.gg/4xdxq5

► Table Of Contents
00:00 Intro
00:16 Project Overview
01:05 H2 Database Setup
02:01 JDBC Driver List
02:41 DriverManager
03:37 JDBC Urls - Overview
04:16 H2 JDBC Url - Options
07:02 H2 - Schema/Data Initialization
10:10 SQL - SELECT FROM
10:52 SQL Injection
13:52 SQL - INSERT INTO
15:16 SQL - UPDATE
16:11 SQL - DELETE
17:32 DataSource
18:37 Connection Pools
19:22 HikariCP
22:56 Library Landscape

► FOLLOW ME
https://www.marcobehler.com
  / marcobehler