A simple JDBC application sample code

The basic process for a single data retrieval operation using JDBC would be as follows.
  • a JDBC driver would be loaded;
  • a database Connection object would be created from using the DriverManager (using the database driver loaded in the first step);
  • a Statement object would be created using the Connection object;
  • a SQL Select statement would be executed using the Statement object, and a ResultSet would be returned;
  • the ResultSet would be used to step through (or iterate through) the rows returned and examine the data.
The following JDBC code sample demonstrates this sequence of calls.
import java.sql.* 

public class JDBCSample { 
public static void main( String args[]) { 

String connectionURL = "jdbc:postgresql://localhost:5432/movies;user=java;password=samples"; 

// Change the connection string according to your db, ip, username and password 

try { 

// Load the Driver class. 


// If you are using any other database then load the right driver here. 

//Create the connection using the static getConnection method 

Connection con = DriverManager.getConnection (connectionURL); 

//Create a Statement class to execute the SQL statement 

Statement stmt = con.createStatement(); 

//Execute the SQL statement and get the results in a Resultset 

ResultSet rs = stmd.executeQuery("select moviename, releasedate from movies"); 

// Iterate through the ResultSet, displaying two values 

// for each row using the getString method 

while (rs.next()) 

System.out.println("Name= " + rs.getString("moviename") + " Date= " + rs.getString("releasedate"); 


catch (SQLException e) { 



catch (Exception e) { 



finally { 

// Close the connection 




    Blogger Comment
    Facebook Comment