Writing your first JDBC Application?

Ok, after a long time, here is core technical blog for all of u.
If u r wondering how to access MySQL database using JAVA program. The answer is JDBC application!

Before going to coding, u must understand certain aspects of JDBC programming.

1. You must include Jconnector in the classpath of ur machine so that Java program can interact with ur database schema. Further, you must import packages to use built-in SQL execution functions in Java.

2. You have to register the JDBC driver so that u can open a communication channel to database.

3. Then, you have open the Connection using getConnection() Method.It’s use is demonstrated later in the code.

4. After, the Connection is established, you need to execute a query. For that purpose, it requires using an object of type Statement for building and submitting an SQL
statement to the database.

5. After the execution of query, the result is stored in ResultSet. You will often use the appropriate ResultSet.getXXX() method to retrieve the data from the result set.

6. Atlast, it is always safe to close all the resources instead of relying on JVM’s garbage collection.

Here is the sample code!
//STEP 1. Import packages

import java.io.*;
import java.sql.*;
public class cleaning
public static void main(String[] args)

Connection con=null;
Statement stmt =null;
ResultSet rs=null;
//STEP 2: Register JDBC driver

//STEP 3: Open a connection con=DriverManager.getConnection(“jdbc:mysql://localhost:3306/student?user=root&password=it”);

//STEP 4: Execute a query
String sql;
sql = “SELECT RollNo, FirstName, LastName, FirstSem FROM Finalyr”;
rs = stmt.executeQuery(sql);

//STEP 5: Extract data from result set
String rollno= rs.getString(“rollno”);
String firstname = rs.getString(“firstname”);
String lastname = rs.getString(3);
int firstsem = rs.getInt(4);
System.out.println(“Roll no.: ” + rollno +”, “+ firstname+ ” “+lastname+”,Ist Sem:”+firstsem);

//STEP 6: Clean−up environment
catch(SQLException se){
//Handle errors for JDBC
catch(Exception e){
//Handle errors for Class.forName
//finally block used to close resources
catch(SQLException se){



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s