Java Database Connectivity (JDBC) Studies

General Objective

• Know the main features of JDBC in theory and practice.
• Develop the basic structure of a project with JDBC.
• Implement the DAO Pattern (Data Access Object) manually with JDBC.

Studies Overview

JDBC

• Java's standard API for data access

DAO:

• Data Access Object Pattern or DAO pattern is a way of organizing code to handle the communication between your program and a database. It helps keep your code clean and separates the logic for interacting with data from the rest of your application.

Folders Overview

1. jdbc_v(1, 2, 3, 4, 5, 6) - Setting some fundamentals ideas.
2. jdbc_dao - Implementation of some advanced methods.

Tips & Tricks

• Use PreparedStatement and its Set methods instead of Statement to avoid SQL Injection.

Installations of the tools (MacOS)

• MySQL Community Server
• MySQL Workbench
• MySQL Java Connector - Select Platform Independent

Adding the MySQL to PATH (MacOS)

1. At the Terminal, type:

    open .zshrc
   

2. At the new zshrc tab, type:

    # MySQL Path.
    export PATH=${PATH}:/usr/local/mysql-8.0.37-macos14-arm64/bin
   

Now, save and close the tab.