Java connect to Oracle using jdbc

import java.sql.*;

public class TestDBConnection {
static public void main(String args[]) throws Exception {
  String connStr = "jdbc:oracle:thin:@[host]:[port]:[sid]";
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  Connection conn = DriverManager.getConnection(connStr,"[user]","[password]");
  
  Statement statement = conn.createStatement();
  String sqlText = "select user, sysdate from dual";
  ResultSet resultSet = statement.executeQuery(sqlText);
  while (resultSet.next()) {
    String userName = resultSet.getString("user");
    Date currentDate = resultSet.getDate("sysdate");
    System.out.println("User: " + userName);
    System.out.println("Date: " + currentDate);
}
conn.close();
}
}

Possible output:

c:\java\java TestDBConnection

User: scott
Date: 2013-06-05

Prerequisities: install jdbc driver, setup CLASSPATH environment variable.