Home Jdbc What is JDBC?
Questions:Ask|Latest

 
 

Share on Google+Share on Google+

What is JDBC?

Advertisement
JDBC is Java application programming interface that allows the Java programmers to access database management system from Java code.

What is JDBC?

     

JDBC is Java application programming interface that allows the Java programmers to access database management system from Java code. It was developed by JavaSoft, a subsidiary of Sun Microsystems.

Definition
Java Database Connectivity
in short called as JDBC. It is a java API which enables the java programs to execute SQL statements. It is an application programming interface that defines how a java programmer can access the   database in tabular format from Java code using a set of  standard interfaces and classes written in the Java programming language.

JDBC has been developed under the Java Community Process that allows multiple implementations to exist and be used by the 
same application. JDBC provides methods for querying and  updating the data in Relational Database Management system  such as SQL, Oracle etc. 

The Java application programming interface provides a mechanism for dynamically loading the correct Java packages and drivers and registering them with  the JDBC Driver Manager that is used as a connection factory for creating JDBC connections which supports creating and executing statements such as SQL INSERT, UPDATE and DELETE. Driver Manager is the backbone of the jdbc architecture.

Generally all Relational Database Management System supports SQL and we all know that Java is platform independent, so JDBC  makes it possible to write a single database application that can run on different platforms and interact with different Database Management Systems. 

Java Database Connectivity is similar to Open Database Connectivity (ODBC) which is used for accessing and managing database, but the difference is that JDBC is designed specifically for Java programs, whereas ODBC is not depended upon any language. 

In short JDBC helps the programmers to write java applications that manage these three programming activities:

1. It helps us to connect to a data source, like a database.
2. It helps us in sending queries and updating statements to the database and 
3. Retrieving and processing  the results received from the database in terms of answering to your query.

 

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: April 13, 2007

Related Tutorials

Ask Questions?    Discuss: What is JDBC?   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
smile
June 15, 2011
jdbc

why we use jdbc??
manoj kumar
August 16, 2011
java

what is fundamental concepts of java?
manoj kumar
August 16, 2011
java

what is the basic of java
Sathya
August 19, 2011
JDBC

What r the Salient features of JDBC connectivity when compared to other connectivities?
damu
November 14, 2011
send all concepts of jdbc and odbc

good
satish ghuagarkar
February 27, 2013
java

JDBC is Java application programming interface that allows the Java programmers to access database management system from Java code. What is JDBC? JDBC is Java application programming interface that allows the Java programmers to access database management system from Java code. It was developed by JavaSoft, a subsidiary of Sun Microsystems. Definition Java Database Connectivity in short called as JDBC. It is a java API which enables the java programs to execute SQL statements. It is an application programming interface that defines how a java programmer can access the database in tabular format from Java code using a set of standard interfaces and classes written in the Java programming language. JDBC has been developed under the Java Community Process that allows multiple implementations to exist and be used by the same application. JDBC provides methods for querying and updating the data in Relational Database Management system such as SQL, Oracle etc. The Java application programming interface provides a mechanism for dynamically loading the correct Java packages and drivers and registering them with the JDBC Driver Manager that is used as a connection factory for creating JDBC connections which supports creating and executing statements such as SQL INSERT, UPDATE and DELETE. Driver Manager is the backbone of the jdbc architecture. Generally all Relational Database Management System supports SQL and we all know that Java is platform independent, so JDBC makes it possible to write a single database application that can run on different platforms and interact with different Database Management Systems. Java Database Connectivity is similar to Open Database Connectivity (ODBC) which is used for accessing and managing database, but the difference is that JDBC is designed specifically for Java programs, whereas ODBC is not depended upon any language. In short JDBC helps the programmers to write java applications that manage these three programming activities: 1. It helps us to connect to a data source, like a database. 2. It helps us in sending queries and updating statements to the database and 3. Retrieving and processing the results received from the database in terms of answering to your query.
mohit
November 23, 2011
jdbc

Java Database Connectivity, a Java API that enables Java programs to execute SQL statements. This allows Java programs to interact with any SQL-compliant database. Since nearly all relational database management systems (DBMSs) support SQL, and because Java itself runs on most platforms, JDBC makes it possible to write a single database application that can run on different platforms and interact with different DBMSs. JDBC is similar to ODBC, but is designed specifically for Java programs, whereas ODBC is language-independent. read more at www.getpapers.org
v.g.venkata ramana
November 26, 2011
just compliment

it is very clear and understadable.
Dinesh Kumar
December 29, 2011
JAVA

It is very good..site for learning. awesome
suresh kumar
January 9, 2012
i have some problem in jdbc

any one give me full discription of jdbc
rahul
March 3, 2012
love

life is short love is long lovers are die but love can not die
anuj
April 26, 2012
how to get coneection

i want to connectivity of the java
ajay
May 31, 2012
my SQL using java

how can i connect java with mySQL....is it necessary to learn advance java if i want to work on mySQl simply for my knowledge of database...
shri
June 29, 2012
Just learn about the jdbc

I want to learn only jdbc programming of java.
musa
July 3, 2012
learning

its so nice
hitesh
September 20, 2012
tutorial

nice article
sumit yadav
September 28, 2012
advance java

JDBC is Java application programming interface that allows the Java programmers to access database management system from Java code. It was developed by JavaSoft, a subsidiary of Sun Microsystems.
priyesh
October 9, 2012
jdbc

i want to know more much
rakesh
October 17, 2012
jdbc defination

this described very good for basically beginer it is very helpful for learner
DMCA.com