3.8 - Introduction to Databases - Java Database Connectivity API

We cover how to programmatically connect to a database in Java using JDBC.

0:00 JDBC
0:19 Introduction
1:12 Process
1:48 Loading a driver
2:39 Making a connection
3:06 Transactions
3:43 Prepared statements
5:13 Select statements
6:36 Clean up
7:09 Demonstration
7:58 Adding a driver
8:49 Loading a driver
9:10 Create a connection
10:02 Formulate a query
11:09 Clean up
12:03 getBook example
16:00 getBooks example
17:49 Best practice: exceptions
18:30 Best practice: always use prepared statements
19:53 Best practice: avoid wildcards
20:20 Other Issues

This video series was designed for Computer Science II (CSCE 156) in the School of Computing at the University of Nebraska-Lincoln.