import java.io.UnsupportedEncodingException;
import java.sql.*;

public class ConnectionTest {
    public static void main(String[] args) {
        try {
            Class.forName("org.firebirdsql.jdbc.FBDriver");
            Connection connection;
            try {
                connection = DriverManager.getConnection("jdbc:firebirdsql://localhost:3050/C3Repository?" +
                        "lc_ctype=utf8&user=&password=");
                Statement statement = connection.createStatement();
                ResultSet resultSet;
                try {
                    resultSet = statement.executeQuery("select * from \"Employee\"");
                    System.out.println("code\tname");
                    while (resultSet.next()) {
                        int code = resultSet.getInt("code");
                        String name = "*";
                        try {
                            name = new String(resultSet.getString("lastName").getBytes(), "UTF8");
                        } catch (UnsupportedEncodingException ex) {
                            System.out.println(ex);
                        }
                        System.out.println(code + "\t" + name);
                    }
                } catch (SQLException ex) {
                    System.out.println("Can't execute query");
                    System.out.println(ex);
                }
            } catch (SQLException ex) {
                System.out.println("Can't get connection");
                System.out.println(ex);
            }
        } catch (ClassNotFoundException ex) {
            System.out.println("Can't load Firebird driver");
        }
    }
}