Week 5

PostgreSQL

Relationships and Constraints

Normalization

Joins

JDBC

SQL Injection2

IoC & DI

Practice

Assignment

Back end Track

Under construction

<aside> 🚧

This page is currently under construction. Please check back later.

</aside>

Implementation plan:

  1. What is JDBC — Java Database Connectivity
  2. Adding the PostgreSQL JDBC driver dependency
  3. Establishing a connection: DriverManager.getConnection(url, user, password)
  4. Creating statements: Statement vs PreparedStatement
  5. Executing queries: executeQuery (SELECT) and executeUpdate (INSERT/UPDATE/DELETE)
  6. Processing results with ResultSet
  7. Closing resources (connection, statement, result set)
  8. Connection strings and configuration
  9. Exercise: query the PostgreSQL database from Java

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

CC BY-NC-SA 4.0 Icons

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.