Learning JDBC

A project I built while learning Java Database Connectivity. Implements CRUD, Data Access Object pattern on a postgreSQL database built ontop a docker container.

Getting Started

Clone this repo to your local machine How To Guide

Order of operations

These commands are for linux/Mac, changes will need to made if you are running this in Microsoft Windows.

Prerequisites

• Basic Knowledge of JAVA. Great tutorial on Javatpoint.
• Java JDK 8 at least installed on Local machine. Oracle Doc for Mac & Windows.
• An IDE installed in local machine. Used intelliJ IDEA.
• Docker is installed Download.
• psql client is installed Postgres/psql.

Running PostgreSQL

1. Pull Docker Image docker pull postgres

2. Build data directory mkdir -p ~/srv/postgres

3. Run docker image docker run --rm --name lil-postgres -e POSTGRES_PASSWORD=password -d -v $HOME/srv/postgres:/var/lib/postgresql/data -p 5432:5432 postgres

Stopping PostgreSQL

docker stop lil-postgres

Logging into Database

• psql -h localhost -U postgres -d hplussport

Creating starter data

1. psql -h localhost -U postgres -f database.sql
2. psql -h localhost -U postgres -d hplussport -f customer.sql
3. psql -h localhost -U postgres -d hplussport -f product.sql
4. psql -h localhost -U postgres -d hplussport -f salesperson.sql
5. psql -h localhost -U postgres -d hplussport -f orders.sql

Running the tests

After setting up development environment, docker container

• Build & Run
• Can also run SQL commands on terminal after logging in.

You should comprehensive outputs in the terminal....Hurray you have a functional database.

Built With

• Java
• JDBC
• PostgreSQL
• Docker

Authors

• Divine Odazie