How to get multiple result sets

what is the best way to send multiple queries into the database so that I
can run Statement.execute() and get back multiple result sets? i tried
something like:

PreparedStatement ps = "select * from table1; select * from table2";

running that I get back only a single result set... 

thanks.
john

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)