/*
 * Copyright (c) 1997-1999 Departamento de Informática - UFPE
 */
   
import java.net.URL;
import java.sql.*;

/**
 * Classe de teste de acesso a Banco de Dados atraves de JDBC utilizando
uma bridge.
 */                                                                           
class ConectaODBC {


    /**
     * Método de teste.
     */                               
     public static void main (String args[]) {

	String url   = "jdbc:odbc://150.161.2.118:1433/if101";   //Protocolo:Drive:LocalizacaoDoBD


	String query = "SELECT * FROM scbs"; // Query SQL

	try {

		
		Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");  //Carrega o drive ODBC
		DriverManager.setLogStream(System.out);
                Connection con = DriverManager.getConnection(url, "phmb", "phmb");
                DatabaseMetaData dma = con.getMetaData ();
                System.out.println("\nConnected to " + dma.getURL());
                System.out.println("Driver       " + dma.getDriverName());
                System.out.println("Version      " + dma.getDriverVersion());
                System.out.println("");
  

                Statement stmt = con.createStatement (); // Abre a coneccao com o BD

		ResultSet rs = stmt.executeQuery (query);  // Executa a query SQL



		//Imprime o resultado da query SQL
                while(rs.next()) {
                    System.out.println(rs.getString("autor"));
                    System.out.println(rs.getString("titulo"));
                    System.out.println(rs.getString("codigo"));
                    System.out.println(rs.getString("area"));
                    System.out.println(rs.getString("centro"));
                    System.out.println(rs.getString("dpto"));
                    System.out.println(rs.getString("local"));
                    System.out.println(rs.getString("responsavel"));
                }



		rs.close();
                stmt.close();
                con.close();


	}
	catch (SQLException ex) {
	
		System.out.println ("\n*** SQLException caught ***\n");
	        while (ex != null) {
	              System.out.println ("SQLState: " + ex.getSQLState ());
	              System.out.println ("Message:  " + ex.getMessage ());
	              System.out.println ("Vendor:   " + ex.getErrorCode ());
	              ex = ex.getNextException ();
	              System.out.println ("");
	        }

	}
	catch (java.lang.Exception ex) {
	
		ex.printStackTrace ();
	}


     }

}