This repository contains hands-on JDBC examples developed to understand low-level database interaction using Java.
The projects demonstrate how Java applications connect to relational databases, execute SQL queries, handle result sets, call stored procedures, and integrate file handling with database operations.
This repository strengthens foundational backend and database programming knowledge.
- Java
- JDBC
- SQL
- Oracle / MySQL (depending on configuration)
Projects:
-
DBcon1 -
DBcon2 -
DBcon3 -
Establishing JDBC connections
-
Using DriverManager
-
Executing basic SQL statements
Project: DBcon5_prepareStm
- Parameterized SQL queries
- Preventing SQL injection
- Improved query performance
Project: DbCon6_resultSet
- Processing query results
- Iterating through ResultSet
- Column data extraction
Projects:
-
DbCon7_Callable -
DbCon7_Callable_Function -
Calling stored procedures
-
Handling IN / OUT parameters
-
Database function invocation
Projects:
-
DBcon8_FileStreams -
DBcon8_FileStreams2 -
Storing files in database
-
Retrieving files from database
-
BLOB / CLOB handling
Project: DBTable_Testing
- Table structure testing
- Query execution validation
- Direct JDBC API usage
- SQL query execution lifecycle
- Connection, Statement, ResultSet management
- Exception handling
- Resource cleanup
- Established JDBC connections manually
- Executed SQL queries using Statement & PreparedStatement
- Processed ResultSet efficiently
- Called stored procedures using CallableStatement
- Integrated file streams with database storage
- Strengthened SQL and database fundamentals
- Add transaction management examples
- Introduce batch processing
- Compare JDBC vs ORM (JPA/Hibernate)
- Add connection pooling examples
Ganta Lakshman Naga Durga Sairam
Java Full Stack Developer
Hyderabad, India