Java Topics
JDBC Interview Questions
Last Updated : 26 May, 2026
title: JDBC Interview Questions
title: JDBC Interview Questions description: Java Database Connectivity interview questions with answers
Q1. JDBC kya hai?
Java Database Connectivity — Java program ko database se connect karne ki API hai. java.sql package mein hoti hai.
Q2. JDBC ke steps kya hain?
- Driver load karo:
Class.forName("com.mysql.cj.jdbc.Driver") - Connection banao:
DriverManager.getConnection(url, user, pass) - Statement create karo
- Query execute karo
- ResultSet process karo
- Connection close karo
Q3. Statement vs PreparedStatement vs CallableStatement?
| Statement | PreparedStatement | CallableStatement | |
|---|---|---|---|
| -- | -- | -- | -- |
| Use | Simple queries | Parameterized queries | Stored procedures |
| SQL Injection | Vulnerable | Safe | Safe |
| Performance | Low | High (pre-compiled) | High |
Q4. SQL Injection kya hai aur kaise rokein?
User input se malicious SQL execute karna. PreparedStatement use karo, ? placeholders use karo.
Q5. ResultSet kya hai? Types?
Query ka result hold karta hai. Types:
TYPE_FORWARD_ONLY— Sirf aageTYPE_SCROLL_INSENSITIVE— Kisi bhi directionTYPE_SCROLL_SENSITIVE— DB changes reflect hoti hain
Q6. Transaction management JDBC mein?
con.setAutoCommit(false);
// queries...
con.commit(); // ya
con.rollback(); // error parQ7. Connection Pool kya hai?
Pre-created connections ka pool. Baar-baar connection banana costly hota hai. HikariCP, C3P0 popular libraries hain.
Q8. Batch Processing kya hai?
Multiple SQL statements ek saath execute karna — performance better hoti hai.
stmt.addBatch(sql1);
stmt.addBatch(sql2);
stmt.executeBatch();Q9. JDBC mein Exception handling?
SQLException catch karo. getErrorCode() aur getSQLState() se details milti hain.
Q10. DriverManager vs DataSource?
DriverManager— Simple, no pooling, testing ke liyeDataSource— Production use, connection pooling support
Exam Focus
Revise definitions, diagrams, examples, and short-answer points for JDBC Interview Questions.
Interview Use
Prepare one clear explanation, one practical example, and one common mistake for this Java topic.
Search Terms
java, java programming, core java, java master course, java notes, master, course, interview
Related Java Topics