Skip to content

README.md

Latest commit

 

History

History
50 lines (31 loc) · 1.88 KB

README.md

File metadata and controls

50 lines (31 loc) · 1.88 KB

JDBC Assignment

Connecting to MySQL Database and Running Basic Queries

Objective:

This assignment aims to introduce students to JDBC (Java Database Connectivity) and guide them through connecting to a MySQL database and executing queries.

Instructions:

Part 1: Setup

  1. Download and install MySQL: Install MySQL on your machine if you haven't already. You can download it here.

  2. Create a Database: Using MySQL Workbench or any MySQL client, create a new database named university.

  3. Create a Table: Within the university database, create a table named students with the following columns:

    • id (INT, PRIMARY KEY, AUTO_INCREMENT)
    • name (VARCHAR)
    • age (INT)

Part 2: Java Program

Write a Java program that connects to the MySQL database and performs the following operations:

  1. Connect to the Database:

    • Use JDBC to establish a connection to the MySQL database.

  2. Insert Data:

    • Insert at least two records into the students table.

  3. Retrieve Data:

    • Retrieve and print all records from the students table.

  4. Update Data:

    • Update the age of one student.

  5. Delete Data:

    • Delete one student from the table.

Part 3: Submission

Submit the Java source code file along with a screenshot of the table you created using MySQL Shell in the same way you submitted your last assignment.

Additional Tips:

  • Use the JDBC documentation (Oracle JDBC API) as a reference guide.
  • Ensure you have the MySQL Connector/J library in your project. You can download it here.
  • If you face any issues, you can contact your technical executives and peers in the community!