Chapter Two: Java Database Connectivity (JDBC)

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/15

flashcard set

Earn XP

Description and Tags

These flashcards cover key concepts, components, and terminology related to Java Database Connectivity (JDBC), providing essential vocabulary for understanding JDBC architecture, transactions, and SQL operations.

16 Terms

1
New cards

JDBC

Java Database Connectivity, the standard Java API that allows Java programs to interact with relational databases.

2
New cards

JDBC API

The layer providing standard interfaces and classes for Java applications to interact with databases.

3
New cards

JDBC Driver Manager

Central class responsible for managing JDBC drivers and establishing connections to databases.

4
New cards

JDBC Driver

Vendor-specific software that bridges Java application's JDBC calls and the database's native protocol.

5
New cards

Transaction

A logical unit of database operations that must be executed completely to ensure data integrity.

6
New cards

CRUD Operations

Create, Read, Update, and Delete; the four basic functions of persistent storage in databases.

7
New cards

PreparedStatement

A precompiled SQL statement used for executing parameterized queries to enhance security and performance.

8
New cards

CallableStatement

Used to execute stored procedures in the database allowing complex operations and output parameters.

9
New cards

ACID Properties

Atomicity, Consistency, Isolation, Durability; the key properties that guarantee reliable transactions.

10
New cards

SQL Injection

A code injection technique where an attacker can execute arbitrary SQL code on a database.

11
New cards

ResultSet

An iterator that holds data retrieved from a database query, allowing Java applications to process results.

12
New cards

Type 1 JDBC Driver

JDBC-ODBC Bridge Driver, which is now deprecated and uses ODBC to connect with databases.

13
New cards

Type 2 JDBC Driver

Native-API Driver that requires native libraries and is platform-dependent.

14
New cards

Type 3 JDBC Driver

Network Protocol Driver that uses middleware to convert JDBC calls into database-specific calls.

15
New cards

Type 4 JDBC Driver

Thin Driver, fully written in Java that communicates directly with the database's native protocol.

16
New cards

Exception Handling

Managing errors that occur during database operations to ensure smooth application performance.