// *****************************************************
// Copyright (c) 2006-2010 iAnywhere Solutions, Inc.
// Portions copyright (c) 2006-2010 Sybase, Inc.
// All rights reserved. All unpublished rights reserved.
// *****************************************************
// This sample code is provided AS IS, without warranty or liability
// of any kind.
//
// You may use, reproduce, modify and distribute this sample code
// without limitation, on the condition that you retain the foregoing
// copyright notice and disclaimer as to the original iAnywhere code.
//
// *********************************************************************
package com.ianywhere.ultralitej.demo;

import com.ianywhere.ultralitej12.*;

/**
 * ReadSeq -- sample program to demonstrate reading a Database table
 * sequentially.
 */
public class ReadSeq
{
    /**
     * mainline for program.
     *
     * @param args command-line arguments
     *
     */
    public static void main
	( String[] args )
    {
	try {
	    Configuration config = DatabaseManager.createConfigurationFile( "Demo1.ulj" );
	    Connection conn = DatabaseManager.connect( config );
	    PreparedStatement stmt = conn.prepareStatement( "SELECT * FROM Employee ORDER BY number" );
	    ResultSet cursor = stmt.executeQuery();
	    for( ; cursor.next(); ) {
		int emp_no = cursor.getInt( 1 /* "number" */ );
		String last_name = cursor.getString( "last_name" );
		String first_name = cursor.getString( 3 /* "first_name" */ );
		int age = cursor.getInt( 4 /* "age" */ );
		Demo.display( first_name + ' ' + last_name );
		Demo.display( "  empl. no = "
			    , Integer.toString( emp_no )
			    , "  age = "
			    , Integer.toString( age ) );
	    }
	    cursor.close();
	    stmt.close();
	    conn.release();
	} catch( ULjException exc ) {
	    Demo.displayException( exc );
	}
    }
}