How to Get SQL Results in Java?

Hello,

I'm new to java and have a few questions when running sql. I have no problems connecting to the Oracle 9i database, but my questions are these:

(1) I have a CREATE TABLE statement. How do I check to see if the table was actually created? SQL returns the statement "table created" if it was successful. I've tried different "out.print(resultSet.*" statements to return either success or failure, but nothing is working.

(2) I created a measure called sqlQuery. Can I put multiple sql statements in this measure? How do I get a resultSet for each sql statement and not just the last one?

(3) Is it possible to use the * (i.e., select * from tablename) in Java? I've tried this unsuccessfully too.

Many thanks

[755 byte] By [newjavagirla] at [2007-11-27 11:58:20]