📚 A simple Java-based student management system using JDBC to perform CRUD operations.
🔗 View on GitHub
- 🎯 About the Project
- 🔑 Features
- ⚙️ Getting Started
- 🧰 Usage
- 📂 Project Structure
- 🧮 Technologies Used
- 🤝 Contributing
- 📝 License
- 👤 Contact
This is a command-line Java application designed to manage student data using JDBC. It allows users to:
- Add new students
- View all or specific student details
- Update student records
- Delete student entries
It’s a great practice project for learning JDBC, Java, and basic database interactions.
| Feature | Description |
|---|---|
| ➕ Add Student | Insert new student records into the database |
| 🔍 View Students | Retrieve and display student records |
| ✏️ Update Student | Edit existing student details |
| ❌ Delete Student | Remove student records by ID |
| 🗄️ JDBC Integration | Seamless database connectivity using JDBC |
| 🧹 Clean Code | Organized structure following OOP principles |
Ensure you have the following installed:
- ✅ Java JDK 8 or higher
- ✅ Maven
- ✅ MySQL or compatible RDBMS
- ✅ IDE (IntelliJ, Eclipse, VSCode, etc.)
-
Clone the Repository
git clone https://github.com/sumitojha2002/student-management-jdbc.git cd student-management-jdbc -
Configure Database
Update DB credentials in your code (likely in a DBConnection or config class):
String url = "jdbc:mysql://localhost:3306/your_db";
String user = "your_username";
String password = "your_password";- Build the Project
nvm clean install- Run the App
java -cp target/student-management-jdbc-1.0-SNAPSHOT.jar MainWhen you run the app,you'll see a menu like:
Welcome to Student Management System
- Add Student
- View All Students
- Update Student
- Delete Student
- Exit Enter your choice:
student-management-jdbc/
├── src/
│ └── main/
│ ├── java/
│ │ └── com/
│ │ └── studentmgmt/
│ │ ├── dao/ # Data Access Objects
│ │ ├── model/ # POJOs like Student.java
│ │ ├── service/ # Business Logic
│ │ └── Main.java # Entry Point
│ └── resources/
│ └── application.properties (optional)
├── pom.xml
└── README.md- ☕ Java 8+ – Core programming language
- 🧩 JDBC – For database connectivity
- 🐬 MySQL – Relational database
- 📦 Maven – Build automation tool
- 🧠 OOP – Object-oriented design
Contributions are welcome!
- 🍴 Fork the repo
- 🛠️ Create a feature branch
git checkout -b feature-name
- 💾 Commit your changes
git commit -m 'Add new feature' - 📨 Open a Pull Request Please ensure your code follows best practices and includes necessary documentation/comments.
This project is licensed under the MIT License.
Sumit Ojha
⭐️ Star this repo if you found it useful!