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