import java.util.*;
import java.io.*;
import java.sql.* ;

public class JDBCQuery
{

//public static void main(com.hyperion.essbase.calculator.Context ctx, String[] args) {
//runQuery(args);
//  }
    
  public static void main(String[] args) {
    runQuery(args);
  }
    
  public static void runQuery(String[] args) {
    int n = args.length;
    String strDSN = args[0];
    String strUser = args[1];
    String strPassword = args[2];
    String strQuery = args[3];

    for (int i=4; i < n ; i++) {
      strQuery = strQuery + " " + args[i];
    }

    try {
      // Load the database driver
      Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;

      Properties connectionProps = new Properties();
      connectionProps.put("user", strUser);
      connectionProps.put("password", strPassword);      // Print all warnings

      // Get a connection to the database
      Connection conn = DriverManager.getConnection( "jdbc:odbc:" + strDSN, connectionProps) ;

      for( SQLWarning warn = conn.getWarnings(); warn != null; warn = warn.getNextWarning() ) {
        System.out.println( "SQL Warning:" ) ;
        System.out.println( "State  : " + warn.getSQLState()  ) ;
        System.out.println( "Message: " + warn.getMessage()   ) ;
        System.out.println( "Error  : " + warn.getErrorCode() ) ;
      }

      // Get a statement from the connection
      Statement stmt = conn.createStatement() ;

      // Execute the query
      ResultSet rs = stmt.executeQuery( strQuery ) ;

      // Loop through the result set
      while( rs.next() )
         System.out.println( rs.getString(1) ) ;

      // Close the result set, statement and the connection
      rs.close() ;
      stmt.close() ;
      conn.close() ;
    }
    catch( SQLException se ) {
      System.out.println( "SQL Exception:" ) ;

      // Loop through the SQL Exceptions
      while( se != null ) {
        System.out.println( "State  : " + se.getSQLState()  ) ;
        System.out.println( "Message: " + se.getMessage()   ) ;
        System.out.println( "Error  : " + se.getErrorCode() ) ;

        se = se.getNextException() ;
      }
    }
    catch( Exception e ) {
      System.out.println( e ) ;
    }
  }

  }