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 = stmt.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
COPYRIGHT © 2017 java-samples.com. ALL RIGHTS RESERVED.