// Original by Sudhir Kumar Rustogi <skrustog@eos.ncsu.edu>
// Modified by Munindar Singh


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

public class SKRSample
{
  public static void main(String args[])
  {
    try
      {
	Class.forName("com.sybase.jdbc.SybDriver");
      }
    catch (ClassNotFoundException cnfe)
      {
      }
    try
      {
        String user = "";
        String password = "";
	String url = "jdbc:sybase:Tds:remus.csc.ncsu.edu:4000";

        for (int n = 0; n<args.length; n++) {
         if (args[n].equals("-u")) user = args[++n];
         else if (args[n].equals("-p")) password = args[++n];
         else throw new IllegalArgumentException("Unknown argument.");
        }

        System.out.println("Any of the following may throw an SQLException.");

        System.out.println("Opening a connection.");
	 
	Connection con = DriverManager.getConnection(url, user, password);

	System.out.println("Creating a statement object.");

	Statement stmt = con.createStatement();

	System.out.println("Executing the query.");

        System.out.println("Assumes there is a Staff table.");

	ResultSet rs = stmt.executeQuery("Select salary from Staff");

        System.out.println("Process the result set.");

	if (rs.next())
	  {
	    int value = rs.getInt(1);
	    System.out.println("Fetched value " + value);
	  }
      }

    catch (SQLException sqe)
      {
	System.out.println("Unexpected exception : " +
			   sqe.toString() + ", sqlstate = " +
			   sqe.getSQLState());
	System.exit(1);
      }
    System.exit(0);
  }
}