
The following command needs to be used for executing the DemoJDBC class.

(Assuming that you are in the same directory as the DemoJDBC.class is)
java -cp /usr/local/depot/oracle-jdbc/lib/classes111.zip:. DemoJDBC

  =============================================================

import java.io.*;
import java.lang.*;
import java.sql.*;

public class DemoJDBC {
	public static void main(String[] args) {
		String url = "jdbc:oracle:thin:@zaurak.cis.ksu.edu:1521:PROD";
		Connection con = null;
		Statement stmt = null;
		
		try {
			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
			Class.forName("oracle.jdbc.driver.OracleDriver");
			con = DriverManager.getConnection(url, "kalyans", "Sakhamuri");
			stmt=con.createStatement();
			String query = "Select * from Customers";
			ResultSet result = stmt.executeQuery(query);
			while(result.next()) {
				System.out.println(result.getString("Name"));
			}
		} catch(SQLException sqle) {
			System.out.println("SQL Exception occured");
			sqle.printStackTrace();
		} catch(ClassNotFoundException e) {
			System.out.println("The Driver Manager Class Is Not Found");
			e.printStackTrace();
		}
		finally {
			try {
				if(con != null)
					con.close();
				else
					System.out.println("Connection doesn't exist");
			} catch(SQLException exc) {
				System.out.println("Connection could not be closed");
				exc.printStackTrace();
			}
		}
	}
}

