This repository contains the source code and resources for building a Student Management App using JDBC (Java Database Connectivity). The project is inspired by the crash course provided by the YouTube channel "Learn Code with Durgesh," which can be found here.
JDBC is a Java API that allows Java programs to interact with relational databases. This project leverages JDBC to create a comprehensive student management system that can perform CRUD (Create, Read, Update, Delete) operations on student records stored in a database.
- Connect to a database using JDBC and establish a connection with the database server.
- Create tables to store student information using SQL statements.
- Implement functionality to add, retrieve, update, and delete student records in the database.
- Build a user-friendly command-line interface for interacting with the application.
- Utilize JDBC prepared statements to prevent SQL injection attacks and enhance security.
- Perform database CRUD operations with persistance in a running database server.
To get started with the project, follow the step-by-step tutorial provided by Learn Code with Durgesh here. The tutorial covers the basics of JDBC and guides you through the process of building the Student Management App.
- Clone the repository:
git clone https://github.com/your-username/jdbc-student-management-app.git
-
Open the project in your favorite Java IDE.
-
Configure your database connection details in the code, including the database URL, username, and password in a environment variable file (.env).
-
Run the application and interact with the command-line interface to perform CRUD operations on student records.
-
ADD - Add a new student to the database.
-
DELETE - Delete a student from the database.
-
UPDATE - Update a student in the database.
-
DISPLAY - Display all students in the database.
-
EXIT - Exit the application.
Contributions to the project are welcome! If you find any issues or have suggestions for improvements, please open an issue or submit a pull request.
This project is licensed under the MIT License.