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. 

Class.forName("org.postgresql.Driver"); 

// 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) { 

e.printStackTrace(); 

} 

catch (Exception e) { 

 e.printStackTrace(); 

} 

finally { 

// Close the connection 

con.close(); 

} 

} 

} 
SHARE
    Blogger Comment
    Facebook Comment