What is JDBC?

By: Sun Printer Friendly Format    


The JDBC API is a Java API that can access any kind of tabular data, especially data stored in a Relational Database.

JDBC helps you to write java applications that manage these three programming activities:

  1. Connect to a data source, like a database
  2. Send queries and update statements to the database
  3. Retrieve and process the results received from the database in answer to your query

    The following simple code fragment gives a simple example of these three steps:

    Connection con = DriverManager.getConnection
               ( "jdbc:myDriver:wombat", "myLogin","myPassword");
    			  
    Statement stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM Table1");
    while (rs.next()) {
    	int x = rs.getInt("a");
    	String s = rs.getString("b");
    	float f = rs.getFloat("c");
    	}
    

    This short code fragment instantiates a DriverManager object to connect to a database driver and log into the database, instantiates a Statement object that carries your SQL language query to the database; instantiates a ResultSet object that retrieves the results of your query, and executes a simple while loop, which retrieves and displays those results. It's that simple.


Ask a Question



Most Viewed Articles (in JDBC )

Latest Articles (in JDBC)

Comment on this tutorial

Ask a Question

Subscribe to Tutorials

Related Tutorials

Archived Comments

1. Very precise and informative tutorial. Appreciated
View Tutorial          By: Rishi Raj at 2011-07-08 12:25:04

2. pls send me the brief description about jdbc conne
View Tutorial          By: vikas at 2011-08-09 07:07:53

3. how to connect jdbc in java on mysql
View Tutorial          By: naseem at 2011-10-26 19:26:45

4. how to connect jdbc in java on mysql
View Tutorial          By: saravana kumar at 2012-01-30 06:06:57

5. java calculator code
View Tutorial          By: Ryan at 2016-03-11 11:19:46