JDBC introduction
- It is a technology that enables the java program to manipulate data stored into the database.
- It is a java application programming interface
o That allows the java programmers to access database management system for java code.
o 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
- It was developed by Javasoft (a subsidiary of Sun Microsystems).
- It has been developed under the java community process that allows multiples implementation to exist and be used by the same application
- It is a java api which enables the java programs to execute sql statements
- It provides methods for querying and updating that data in relational database management system such as sql, oracle... Etc.
- It is given to develop java based persistence logic to interact with db s/w and to manipulate db data.
- In java, Jdbc application are two tier application because they contain two layers and that two layers of two tier application can reside in same computer or in two different computer.
- A layer in the application is logical partition in the application representing logics.
- Sun micro system gives Jdbc as specification having rules and guidelines to develop Jdbc driver s/w.
- JDBC driver is the bridge s/w between java application and db s/w and It converts java calls to db s/w calls
- Since jdbc is an open specification
- Any s/w vendor can develop jdbc driver based on this specification for any db s/w
- Working with jdbc is nothing but working with jdbc driver to interact with db s/w
- Every db s/w needs separate jdbc driver eg: java application needs jdbc driver for oracle to interact with oracle db s/w and similarly for MySql to interact with MySql db s/w
- Since all jdbc driver are coming based on the common jdbc specification rules and guidelines given by sun micro system.
- The way we work with these entire jdbc drivers from our java application to interact with db s/w is going to be such similar.
- Jdbc drivers can be expected from three parties ie., sun micro system, db vendors(creators of db s/w like oracle), third party vendors
- It is always recommended to work with db vendor supplies jdbc drivers to make java application interacting with db s/w
- According to java api means set of classes and interface which comes in the form of package every java technology and java specification contains api
Specification: it is a document that contains rules and guidelines to develop new s/w
- Open Specification: The specification that is free for multiple s/w vendor companies to develop s/w is called as. Eg: Jdbc, Servlet, ejb etc.
- Proprietary Specification: the specification that is specific to one company and only that company is allowed to develop the s/w based on specification. Eg: net specification