FAQ.txt                  firebirdjmx.jar       firebirdsql.rar
FirebirdSQL-1.0.0.zip    firebirdsql-full.jar  jdbc2_0-stdext.jar
JDBC20_conformance.html  firebirdsql-test.jar  lib
faq.html                 firebirdsql.jar       release_notes.html

jaas.jar  log4j-core.jar  mini-concurrent.jar  mini-j2ee.jar

CLASSPATH="$CLASSPATH:/usr/java/j2sdk1.4.1_04/jre/jdbc/jdbc2_0-stdext.jar: /usr/java/j2sdk1.4.1_04/jre/jdbc/firebirdsql.jar: /usr/java/j2sdk1.4.1_04/jre/jdbc/lib/jaas.jar: /usr/java/j2sdk1.4.1_04/jre/jdbc/lib/log4j-core.jar: /usr/java/j2sdk1.4.1_04/jre/jdbc/lib/mini-concurrent.jar: /usr/java/j2sdk1.4.1_04/jre/jdbc/lib/mini-j2ee.jar"

import java.sql.*;

public class Bco
{
    public static void main(String args[])
   {
        System.out.println("#testando acesso a banco de dado Interbase\n\n");
        Connection conn = null;
        String teste = "SELECT NOME FROM TAB_CLI_001;";
        try
      {
         Class.forName("org.firebirdsql.jdbc.FBDriver");
                        conn = DriverManager.getConnection( "jdbc:firebirdsql:ip_do_servidor/3050:/caminho_do_bco_de_dados.gdb", "SYSDBA", "masterkey");
         System.out.println("Sucesso na conexão! Massacre!\n");
         Statement stm = conn.createStatement();
         ResultSet rs = stm.executeQuery(teste);
         while (rs.next())
         {
            String linha = rs.getString("NOME");
            System.out.println("Cliente:" +linha);
         }
        
         System.out.println("select realizado\n");
      }
      catch(ClassNotFoundException e)
      {
                        System.out.println("excessao ClassNotFound...");
                        e.printStackTrace();
      }
      catch(SQLException e)
      {
                        System.out.println("SQL Exception... Erro dos Bravos");
                        e.printStackTrace();
      }
      finally
      {
         try
         {
            conn.close();
         }
         catch(SQLException onConClose)
         {
            System.out.println("error on closing");
            onConClose.printStackTrace();
         }
      }
   }
}