Re: JDBC help

[Bruce Jin <brucej@xxxxxxxxxxxxxxxxxxxx>]

JDBC Api reference: 
*http://java.sun.com/javase/6/docs/technotes/guides/jdbc/

JDBC basics: http://java.sun.com/docs/books/tutorial/jdbc/

*
Michael_Schutte@xxxxxxxxxxxx wrote:
> I'm just getting started with JDBC, does anyone know where I can get good
> reference manuals for the methods.
>
> While I have your attention, I want to write a procedure that will validate
> that a record exists on a different machine.  I already have a procedure
> that returns records back to the iSeries.
>
> I was thinking that it would look something like this...
>
> <code>
> stmt = "select * from table";
> If exists(stmt.executeQuery) { return true;}
> else {return false;}
> </code>
>
> If that doesn't work, I'd imagine that I could just say     select top 1 *
> from table   then check   rs.next
>
> I'm just looking for the best performance on getting data from this
> external machine.  Please advise...
>
> Michael Schutte
> Admin Professional
> Bob Evans Farms, Inc.
> Visit us on the web! www.bobevans.com
> We've built a better hotcake -- Stacked and Stuffed Hotcakes -- coming
> January 11th!
> For hotcake tips, interviews with our chefs and more, check out the Stacked
> and Stuffed blog at http://imstuffed.blogspot.com
>
>