Skip to main content

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 .
Labels:

Comments

Post a Comment

Popular posts from this blog

JSP page directives

A jsp page directive looks like this: <%@ directive attribute="value" %> I am not gonna explain each and every page directives here . I would like to discuss about two page directives  which is import and include. First of all consider the import directive . The following simple program illustrate the use of import page directive: The output would be something looks like this: <%@ page language="java" contentType="text/html; charset=UTF-8"     pageEncoding="UTF-8"%>  <%@ page import="java.util.Date" %>   //page directive <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Jsp Basics</title> </head> <body> <%=new Date() %> </body> </html> Tue Nov 12 17:42:34 I...
1 comment
Read more

a simple example for jdbc PreparedStatement

a simple example for PreparedStatement package basics.in.java.blogspot.in; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main { private static final String USERNAME="root"; private static final String PASSWORD=""; private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot"; public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); Connection conn=null; Statement stmt=null; ResultSet rs=null; try { conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD); System.out.println("database connection successful"); //stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); String sql="select * fr...
1 comment
Read more