What is JDBC and ODBC..?

Question

Accepted Answer

JDBC is a Java API for connecting and executing queries on a database. ODBC is a standard API for connecting and querying databases.

JDBC stands for Java Database Connectivity.
It provides a set of classes and interfaces to connect and interact with databases using Java.
JDBC allows developers to write database-independent code.
ODBC stands for Open Database Connectivity.
It is a standard API that allows applications to access data in various database management systems.
ODBC provides a common interface for different database systems, enabling interoperability.
JDBC is specific to Java, while ODBC is a platform-independent API.
JDBC drivers are written in Java, while ODBC drivers are written in C/C++.
JDBC is widely used in Java-based applications, while ODBC is used in various programming languages.
Example: In Java, to connect to a MySQL database using JDBC, we would use the JDBC driver for MySQL and establish a connection using the DriverManager class.
Example: In a C++ application, to connect to a Microsoft SQL Server database using ODBC, we would use the ODBC driver for SQL Server and establish a connection using the ODBC API.

Top TCS IOT And DE interview questions & answers