title: Execute Multiple Select Statement in java
body: <p>I have to confirm that can we execute multiple select statement in one shot and get multiple resultsets. Please give me some idea for doing this. </p>
  
  <p>I have to execute two select query in one statement:-  </p>
  
  <pre><code>String sql="select * form test;  
  select * from test where empid=1;" 
  </code></pre>
  
  <p>I am expecting to run like this :-  </p>
  
  <pre><code>statement.execute(sql);
  </code></pre>
  
  <p>thanks</p>