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.

|
Current Comments
16 comments so far (post your own) View All Comments Latest 10 Comments:Im really get a greate assurance to getting in this site This is very helpful giuide for the students of all types like B.E,M.C.A,M.E,M.Tech...etc.
Posted by J.V.V.RAJENDRA on Friday, 03.28.08 @ 16:10pm | #54582
Hi, this is very very good website to refer. It is helping me a lot. Thank u very much.
Posted by Umme Shafiya on Thursday, 03.27.08 @ 15:13pm | #54486
hi! this is a good step from ur organisation for the students like us who r pursuing MCA or other professional courses.
Posted by Arushi saxena on Tuesday, 03.11.08 @ 11:47am | #52261
hi this is a very good site for java tutorials specially......really a good site.
thanx
Posted by gaurav leekha on Friday, 02.29.08 @ 15:00pm | #50701
hii
it is really good website ................really good
Posted by abc on Thursday, 02.14.08 @ 12:53pm | #48242
i m a beginner and think it provides me a base
Posted by kathiresan.R on Wednesday, 11.21.07 @ 11:18am | #38135
first i want to thank u sir for that great effort
but there r aproblem i finished java 2 se i want to get in jdbc but idont know how to start what should i do to get in and start ,where i do projects depend on jdbc
i will be happy if u advice me how to start wht should i have
thanks again
Posted by mohamed moharam on Sunday, 11.4.07 @ 05:00am | #35481
this site is very good &helpful for begginer.it helped me very nicely in my project
Posted by simrat on Tuesday, 07.24.07 @ 12:17pm | #21818
hi sir,
I m fresher i finished my java course but i have so many doubts..with the help of rose india .net i am clearing my doubts..sir i have one problem in jdbc plz send me the program of copying one table(database) to another(database) table..
thankyou sir..
Posted by vaishnavi on Saturday, 06.2.07 @ 13:16pm | #18008
This is very helpful side for beginners
Posted by Ram Sudheer on Wednesday, 05.30.07 @ 11:36am | #17709