package frametest;

import java.sql.*;

public class dbtest
{
    public static void main (String [] args)
    {
        String JDBC_DRIVER = "oracle.jdbc.driver.OracleDriver";
        String JDBC_STRING = "jdbc:oracle:thin:@football:1521/XE";
        String USER_NAME = "hr";
        String PASSWD = "manager";

        Connection conn = null;
        ResultSet rs = null;
        Statement stmt = null;

        try
        {
            Class.forName(JDBC_DRIVER);
            conn = DriverManager.getConnection(JDBC_STRING, USER_NAME, PASSWD);
            stmt = conn.createStatement ();

            String query = "SELECT * FROM jobs";
            rs = stmt.executeQuery(query);
            while(rs.next())
            {
                System.out.println(rs.getString(1));
            }

                        stmt.close();
                        conn.close();
        }
        catch(SQLException sqlEx)
        {
            sqlEx.printStackTrace();
        }
        catch(ClassNotFoundException e)
        {
            e.printStackTrace();
        }
    }
 }