aspose file tools*
The moose likes JDBC and the fly likes MULTIPLE Query IN a RS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MULTIPLE Query IN a RS" Watch "MULTIPLE Query IN a RS" New topic
Author

MULTIPLE Query IN a RS

avijit majumder
Greenhorn

Joined: Sep 01, 2009
Posts: 15
How can I run Multiple Query in A Single ResultSet ?
Example---
String st1="select sum(salary) from v_table where id=2 and post!='manager'";
String st2="select sum(salary) from v_table where post!='staff'";
java.sql.Connection con=....
java.sql.Statement st=con.createStatement();
java.sql.ResultSet rs=st.executeQuery(st1); //-----I put one String ...
while(rs.next()){
//dosome thing.
}
java.sql.ResultSet rs1=st.executeQuery(st2); ///---------I put second string
while(rs1.next()){
//dosome thing.
}

NOTE: I need Only one result Set. and one loop while(rs.next() but the rs content both two result
Like AddBatch--->
java.sql.Statement stmt=con.createStatement();
stmt.addBatch(insert_query1); //insert_query1="insert intto table1 values....
stmt.addBatch(insert_query2); //insert_query2 ="insert intto table2 values....
int[] inserts = stmt.executeBatch(); // both table insert complet


ujjwal soni
Ranch Hand

Joined: Mar 28, 2007
Posts: 403
If you want to use a single result-set then its a better idea to close the first one (off course after result set has been iterated) and then executeQuery on the same instance of result set. See the code below, you will get a better idea




Try this




However, if you want to use a single resultset then you need to modify your query



Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+919909981973>
"Helping hands are better than praying lips......"
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MULTIPLE Query IN a RS