This repository provides a comprehensive learning experience for Java Database Connectivity (JDBC), along with a practical Contact Management App built using the MVC architecture.
- JDBC Notes.txt: A detailed guide explaining JDBC concepts and steps to connect with a database.
- JDBC Extra.txt: Additional tips and tricks for advanced JDBC usage.
Contains demo programs that illustrate common JDBC operations:
- BatchExecution.java: Demonstrates executing multiple SQL statements in one go.
- DeleteData.java: Shows how to delete records from a database.
- DeleteDataPreparedStatement.java: Delete records securely using
PreparedStatement. - InsertData.java: Demonstrates inserting data into a database.
- InsertDataPreparedStatement.java: Insert data securely using
PreparedStatement. - JDBC_Steps.java: A guide to the fundamental steps of using JDBC.
- ReadData.java: Shows how to retrieve data from a database.
- ReadDataPreparedStatement.java: Retrieve data securely using
PreparedStatement. - UpdateData.java: Demonstrates updating data in the database.
- UpdateDataPreparedStatement.java: Update data securely with
PreparedStatement.
This console-based app is structured using the MVC (Model-View-Controller) architecture:
- controller/Controller.java: Handles user interactions and updates the model.
- model/Contact.java: Represents the contact data and interactions with the database.
- view/View.java: Manages the user interface for displaying contacts and accepting input.
- Add, update, delete, and display contacts.
- Search by name, company, email, city, or phone number.
- Store multiple phone numbers for a single contact.
- Java (JDK 8+)
- JDBC (Java Database Connectivity)
- MySQL/PostgreSQL/SQLite (Database)
- MVC Architecture
- PreparedStatement for secure SQL queries
Feel free to raise any issues or ask questions through GitHub Issues or the repository’s contact section.
🔗 [GitHub Repo Link]
This project is open-source and available under the MIT License. See the LICENSE file for more details.