/*
 * 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
um drive nativo.
 */
class ConectaNAT {


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

        String url   = "jdbc:ff-microsoft://150.161.2.118:1433/if101";
                                         //Protocolo:Drive:LocalizacaoDoBD


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

        try {

            Class.forName("connect.microsoft.MicrosoftDriver");
                                                 //Carrega o drive Nativo
            Driver driver2 = new connect.microsoft.MicrosoftDriver();
            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 ();
        }

    }

}