//Title:        Your Product Name
//Version:
//Copyright:    Copyright (c) 1998
//Author:       Mikael Bonnier
//Company:      Orbin
//Description:  Your description


package dbtest;
import java.sql.*;

public class QueryMyTable
{
   public static void main(String[] args) throws ClassNotFoundException
   {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      try
      {
         Connection dbConn = DriverManager.getConnection("jdbc:odbc:DataSet Tutorial",
            "SYSDBA", "masterkey");
         Statement sqlStmt = dbConn.createStatement();
         ResultSet rSet = sqlStmt.executeQuery(
            "SELECT COUNTRY, CURRENCY"
            + " FROM COUNTRY");
         while(rSet.next())
         {
            System.out.println(rSet.getString("COUNTRY") + '\t' + rSet.getString("CURRENCY"));
         }
         sqlStmt.close();
         dbConn.close();
      }
      catch(SQLException e)
      {
         System.out.println(e);
      }
   }
}