What is JDBC and History of JDBC

What is JDBC?

JDBC is a java-based API for connecting to relational databases such as mysql , sql,sql server ,postgresql and many others. JDBC stands for “Java Database Connectivity ”. JDBC introduced in 1997 as a part of JDK 1.1 and it been a part of all release of java SE since 1997.  

History of JDBC

Who uses JDBC?

Common uses:

• -web-based applications hosted by java Enterprise Edition(JEE) servers
• -Desktop applications working with local and remote databases.

Not-so common uses:

• -Android application
•  -calls to web service middleware are more common 

Alternative to JDBC

• -Higher level abstraction(usually part of larger application frameworks)
•   -Spring JdbcTemplate
•  -RIFE

Data mapping APIs

• -          Hibernate: the most popular object-relational mapping (ORM) API
• -          I batis: Apache project for mapping SQL results to Java objects
• -          Java Persistence API(JPA): Part of the java EE platform

All the above mentioned mechanisms reduce the code you have to write but in the background it use JDBC to talk to Database. Through this post  I believe you have gain some basics knowledge about JDBC .