DEV Community

Praneeth4027
Praneeth4027

Posted on

JAVA DATABASE CONNECTIVITY (JDBC)

JDBC is Java application programming interface that permits the Java software engineers to get to information base administration framework from Java code. It was created by JavaSoft, an auxiliary of Sun Microsystems. It empowers the java projects to execute SQL proclamations.

JDBC is an application programming interface that characterizes how a java developer can get to the information base in plain organization from Java code utilizing a bunch of standard interfaces and classes written in the Java programming language. JDBC gives techniques to questioning and refreshing the information in Relational Database Management framework, for example, SQL, Oracle and so forth

The Java application programming interface gives a system to progressively stacking the right Java bundles and drivers and enrolling them with the JDBC Driver Manager that is utilized as an association production line for making JDBC associations which supports making and executing proclamations, for example, SQL INSERT, UPDATE and DELETE. Driver Manager is the foundation of the JDBC engineering.

By and large all Relational Database Management Systems uphold SQL and we as a whole realize that Java is stage free, so JDBC makes it conceivable to compose a solitary information base application that can run on various stages and cooperate with various Database Management Systems.

Java Database Connectivity is like Open Database Connectivity (ODBC) which is utilized for getting to and overseeing information base, yet the thing that matters is that JDBC is planned explicitly for Java programs, while ODBC isn’t relied on any language.

In this way JDBC encourages the software engineers to compose java applications that deal with these three programming exercises:

It causes us to interface with an information source, similar to an information base.

It encourages us in sending questions and refreshing proclamations to the information base and

Recovering and handling the outcomes got from the information base regarding offering an explanation to your question.

Item COMPONENTS OF JDBC

The JDBC API
2.The JDBC Driver Manager

3.The JDBC Test Suite

4.The JDBC-ODBC Bridge

Top comments (0)