Skip to content

hema143developer/StudentManagementSystemJava_JDBC

Repository files navigation

---- StudentManagementSystemJava_JDBC Java console app for student records using Java & JDBC

--- Student Management System - Java & JDBC

---Project Description This is a console-based Student Management System built using Java and JDBC.
It allows users to perform CRUD operations on student data stored in a MySQL database.

--- Key Features

  • Add new student records with ID, first name, last name, major, and GPA
  • View all student records
  • Update existing student details
  • Delete student records
  • Interactive console input for multiple students

--- Technologies Used

  • Java SE 8 or higher
  • JDBC API for database connectivity
  • MySQL for database management
  • Eclipse IDE for development

--- Setup and Installation

--- Prerequisites

  • Java Development Kit (JDK) installed
  • MySQL Server installed and running
  • Eclipse IDE installed

--- Steps

  1. Clone this repository to your local machine
  2. Import the project into Eclipse IDE
  3. Run the provided studentdb_setup.sql script in MySQL Workbench to create the database and table
  4. Update DBConnection.java with your own MySQL credentials
  5. Run MainApp.java to start the application

--- Usage

  • The application will prompt you to enter the number of students to add
  • Enter the details for each student as prompted
  • The application will manage student records in the MySQL database accordingly

--- Contribution Contributions are welcome. Please fork the repository and create a pull request with your enhancements.

--- License This project is licensed under the MIT License.


Thank you for using the Student Management System application!

About

Java console app for student records using Java & JDBC

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages