Unit 4: Database Connectivity

JDBC (Java Database Connectivity)

Programs

1. Simple JDBC Program

2. JDBC Program with Prepared Statement

3. Rowset

4. Scrollable and Updatable result sets

5. Swing Connection with Database

6. Transactions in JDBC

7. Sql Escapes

Running the JDBC program

1. Install MySQL on your machine

2. Create a database of your choice

3. Run the program

Using Docker to run MySQL

If you want to run the JDBC program, but do not want to install MySQL on your machine, you can use Docker to run a MySQL container.

Use the following commands in order to run a MySQL container: (Make sure you have Docker installed on your machine)

1. Pull the MySQL image from Docker Hub

   docker pull mysql:latest

2. Run the MySQL container

   docker run --name mysql-db -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 -d mysql:latest

3. Access the MySQL container

   docker exec -it mysql-db bash

   mysql -u root -p
   # The password is "password"

4. Create a database

   CREATE DATABASE primecsitb; -- or any name you want

5. Run the JDBC program