如何把兩個(gè)rs結(jié)果集中的內(nèi)容合并到一個(gè)結(jié)果集中
假設(shè)你的二個(gè)數(shù)據(jù)集分別是:???
?? rs1??? 和??? rs2???
????
?????????????????? List??? list??? =??? new??? ArrayList();???
?????????????????? list.add(rs1);???
?????????????????? list.add(rs2);???
?????????????????? try??? {???
?????????????????????????? for??? (int??? i??? =??? 0;??? i??? <??? list.size();??? i++)??? {???
?????????????????????????????????? while??? (((ResultSet)??? list.get(i)).next())??? {???
?????????????????????????????????????????? //在這里取數(shù)據(jù)???????????????
?????????????????????????????????? }???
?????????????????????????? }???
?????????????????? }??? catch??? (SQLException??? e)??? {???
?????????????????????????? e.printStackTrace();???????
?????????????????? }???
?????????? }???
????
?? 不管你有多少個(gè)數(shù)據(jù)集,都放到那個(gè)list里就可以了。
?? rs1??? 和??? rs2???
????
?????????????????? List??? list??? =??? new??? ArrayList();???
?????????????????? list.add(rs1);???
?????????????????? list.add(rs2);???
?????????????????? try??? {???
?????????????????????????? for??? (int??? i??? =??? 0;??? i??? <??? list.size();??? i++)??? {???
?????????????????????????????????? while??? (((ResultSet)??? list.get(i)).next())??? {???
?????????????????????????????????????????? //在這里取數(shù)據(jù)???????????????
?????????????????????????????????? }???
?????????????????????????? }???
?????????????????? }??? catch??? (SQLException??? e)??? {???
?????????????????????????? e.printStackTrace();???????
?????????????????? }???
?????????? }???
????
?? 不管你有多少個(gè)數(shù)據(jù)集,都放到那個(gè)list里就可以了。
posted on 2007-11-02 10:55 李云澤 閱讀(613) 評(píng)論(0) 編輯 收藏 所屬分類: J2EE