Loading repository dataβ¦
Loading repository dataβ¦
Shubh2-0 / repository
π Dive into JDBC practice with two projects: Student Management Application and Student Management Application with DAO Pattern. Learn CRUD operations, DAO layer abstraction, code organization, and extensibility. Clone, configure, and contribute to level up your JDBC skills. Let's explore the world of database interaction! ππ©βπ»π
A transparent discovery signal based on current public GitHub metadata.
This score does not audit code, security, maintainers, documentation quality, or suitability. Verify the repository and its current documentation before adoption.
From CRUD basics to DAO pattern - complete JDBC learning path
Projects Β· Get Started Β· Learn JDBC
This repository provides hands-on practice with JDBC (Java Database Connectivity). Learn how to connect Java applications to databases, perform CRUD operations, and implement the DAO (Data Access Object) pattern for clean architecture.
Basic JDBC implementation covering:
| Feature | Description |
|---|---|
| Add Student | Insert new records |
| View Students | Query all records |
| Update Student | Modify existing data |
| Delete Student | Remove records |
Advanced implementation with clean architecture:
| Component | Responsibility |
|---|---|
| Model | Student entity class |
| DAO Interface | Contract for data operations |
| DAO Implementation | JDBC implementation |
| Service Layer | Business logic |
βββββββββββββββββββ
β Java Application β
ββββββββββ¬βββββββββ
β 1. Load Driver
βΌ
βββββββββββββββββββ
β JDBC Driver β
ββββββββββ¬βββββββββ
β 2. Get Connection
βΌ
βββββββββββββββββββ
β Connection β
ββββββββββ¬βββββββββ
β 3. Create Statement
βΌ
βββββββββββββββββββ
β Statement β
ββββββββββ¬βββββββββ
β 4. Execute Query
βΌ
βββββββββββββββββββ
β ResultSet β
βββββββββββββββββββ
// Establish connection
Connection conn = DriverManager.getConnection(url, user, password);
// Create statement
PreparedStatement ps = conn.prepareStatement("SELECT * FROM students WHERE id = ?");
ps.setInt(1, studentId);
// Execute and process
ResultSet rs = ps.executeQuery();
while(rs.next()) {
System.out.println(rs.getString("name"));
}
| Technology | Purpose |
|---|---|
| Java 8+ | |
| MySQL Database | |
| Maven Build | |
| Eclipse IDE |
# Clone repository
git clone https://github.com/Shubh2-0/JDBC-Practice.git
cd JDBC-Practice
# Create database
mysql -u root -p
CREATE DATABASE student_db;
# Update connection details in code
# Run the application!
Contributions welcome! Add more JDBC examples, improve documentation, or fix bugs.
Shubham Bhati - Java Developer
Keywords: JDBC Java MySQL Database CRUD DAO-Pattern PreparedStatement Connection SQL