Programming Tutorials

(追記) (追記ここまで)

A simple JDBC application sample code

By: Ramlak in JDBC Tutorials on 2007年04月04日 [フレーム]

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.

JDBCSample.java

 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
 Connection con;
 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
 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) {
 e.printStackTrace();
 } catch (Exception e) {
 e.printStackTrace();
 } finally {
 // Close the connection
 con.close();
 }
 }
}

Previous
<< The Structure of JDBC

Next
How connection pooling works in Java and JDBC>>

(追記) (追記ここまで)