<%@ page contentType = "text/html;charset=windows-1250" %>
<%@ page import="java.sql.*, java.text.NumberFormat" %>

<%
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection connection =
DriverManager.getConnection("jdbc:firebirdsql:fbsql/3050:database?lc_type={encoding}", "login", "password");
Statement statement = connection.createStatement();
ResultSet resultset;
resultset = statement.executeQuery("SELECT * FROM table");
while (resultset.next())
{
  out.print(resultset.getString("id"));
  out.println("<br />");
}
resultset.close();
statement.close();
connection.close();
%>