/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package refresher;

import oracle.sql.*;
import java.sql.*;
import oracle.jdbc.*;
import oracle.jdbc.pool.*;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.ResultSet;

public class Main {
    public static void main(String[] args) throws ClassNotFoundException, SQLException
    {
        DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
        //Class.forName("oracle.jdbc.driver.OracleDriver");

        String url = "jdbc:oracle:thin:@localhost:1521:XE";
        Connection conn = DriverManager.getConnection(url, "HR", "hr");

        conn.setAutoCommit(false);
        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select * from JOBS");

        while(rset.next())
        {
            System.out.println(rset.getString(1));
        }

        stmt.close();
        System.out.println("Finished!");
    }
}