// Compile it by
//   javac oracle.java
//
// Run it by
//   java -cp .:$ORACLE_HOME/jdbc/lib/classes111.zip Hello

import java.sql.*;

class Hello
{
  public static void main(String args[]) throws Exception
  {
    //register oracle jdbc driver
    Class.forName("oracle.jdbc.driver.OracleDriver");

    //connect to database
    Connection connection = DriverManager.getConnection(
      "jdbc:oracle:thin:@dbserv.dc.umd.edu:1521:SC424",
      "YOUR_USERNAME", "YOUR_PASSWORD");

    //create a statment
    Statement statement = connection.createStatement();

    //create table
    statement.executeUpdate("CREATE TABLE hello (value varchar(32))");

    //insert data
    statement.executeUpdate("INSERT INTO hello VALUES('Hello world!')");

    //query db
    ResultSet res = statement.executeQuery("SELECT * FROM hello ");
    if (res != null)
      for(; res.next();)
        System.out.println(res.getString(1));
    res.close();

    //close statement and connection
    statement.close();
    connection.close();
  }
}