import java.sql.*;

public class ExemploConexao
{
  public static void main (String args[])
  {
   /* inicio de configuracao dos parms. do BD */

    String nomeClasseDriver = "oracle.jdbc.driver.OracleDriver";
    String conexao = "jdbc:oracle:thin:@ntorades01:1521:orcl";
    String usuario = "scott";
    String senha = "tiger";

    try  // carregar o driver...
    {
      Class.forName (nomeClasseDriver);
    }
    catch (ClassNotFoundException e)
    {
      System.out.println ("Driver nao encontrado...");
      return;
    }  

    try  // acessar o banco...
    {
      Connection c;
      c = DriverManager.getConnection(conexao,usuario,senha);
      // aqui entra SQL
      String consultaSQL = "select * from empregado";
      PreparedStatement pstm = c.prepareStatement (consultaSQL);
      ResultSet rs = pstm.executeQuery();
      while (rs.next())
      {
        System.out.println ("------------------------------------");
        System.out.println ("EMPNO...: "+rs.getInt("EMPNO"));
        System.out.println ("ENAME...: "+rs.getString("ENAME"));
        System.out.println ("JOB.....: "+rs.getString("JOB"));
        System.out.println ("MGR.....: "+rs.getInt("MGR"));
        System.out.println ("HIREDATE: "+rs.getDate("HIREDATE"));
        System.out.println ("SAL.....: "+rs.getDouble("SAL"));
        System.out.println ("COMM....: "+rs.getDouble("COMM"));
        System.out.println ("DEPTNO..: "+rs.getInt("DEPTNO"));
      }
      System.out.println ("------------------------------------");
      rs.close();
      pstm.close();
      // fim do SQL
      c.close();
    }
    catch (SQLException e)
    {
      System.out.println ("Problemas de acesso ao BD...");
      return;
    } 
  }
}