/jdbc

Working with Databases in Java using JDBC, Datasource, Connection Pool, Flyway and JDBC Template

Primary LanguageJava

Working with Databases in Java

  • JDBC
  • Datasource
  • Connection Pool
  • Flyway and JDBC Template

Diagram

diagram

How to get started

  • switch to branch git checkout start
  • watch YouTube video

Exercise

  • Add the ability to edit movies
  • Add actor table and associate them with movies You will need to create a new migration called: V1__ActorTable.sql and the following sql to create the actor table
CREATE TABLE actor
(
    id    bigserial primary key,
    name  TEXT NOT NULL,
    movie bigint REFERENCES movie (id),
    unique (name, movie)
);

Join the community