Hi there,

i am starting using jdbc these days. My first tests use something
like:

Statement stat = connection.getStatement();
stat.execute("SELECT * FROM customer");
handleResult(stat.getResultSet());
stat.execute("SELECT * FROM employees";
handleResult(stat.getResultSet());

..and they work.

I have two questions:
1) When i had a look at some tutorials at sun.com i found out, that
all executions use executequery or executeupdate.... never the pure
execute is used.
Is there a special reason for this?

2) In my testapplication i could use the same statement more than
once. Is there a reason why one should create new statements for each
query? And why is there no exception thrown when i try to use it
twice?

Thanks for any answer. :)

K.Stamme