This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
How can I run Multiple Query in A Single ResultSet ?
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.ResultSet rs=st.executeQuery(st1); //-----I put one String ...
java.sql.ResultSet rs1=st.executeQuery(st2); ///---------I put second string
NOTE: I need Only one result Set. and one loop while(rs.next() but the rs content both two result
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
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
However, if you want to use a single resultset then you need to modify your query
Ujjwal B Soni <baroda, gujarat, india> <+918866008962>
"Helping hands are better than praying lips......"