InterviewSolution
| 1. |
Introduction to JDBC: |
|
Answer» JDBC is an Application Programming Interface(API) for Java, which is helpful for interaction with the database and for EXECUTING the SQL query. JDBC is an abbreviation used for Java Database Connectivity. It uses JDBC drivers for connecting with the database. JDBC API is used to access tabular data stored in relational databases like Oracle, MySQL, MS Access, etc. Components of JDBC:There are four major components of JDBC using which it can interact with a database. They are:
Earlier, ODBC API was used as the database API to connect with the database and execute the queries. But, ODBC API uses C language for ODBC drivers(i.e. platform-dependent and unsecured). Hence, Java has defined its own JDBC API that uses JDBC drivers, which offers a natural Java interface for communicating with the database through SQL. JDBC is required to provide a “pure Java” SOLUTION for the development of an application using Java programming. |
|