如何比较结果集两个对象

Question

Plase帮助，如何根据结果集对象比较选中复选框？我在分局有两张桌子。一个是主题，它包含

  category         | sub_category
    --------------+-------------
Arts and Humanities|   Arts and Humanities (General)
Arts and Humanities|   History
Arts and Humanities|   Language and Linguistics
Arts and Humanities|   Media Technology

另一个是topic_alerts，它包含

     username              |   topic  
     ----------------------------------------
hareesh.nare@gmail.com |  History
    hareesh.nare@gmail.com |  Language and Linguistics
   hareesh.nare@gmail.com  |Media Technology

在我的jsp页面中，显示基于选定的sub_category的分类

在那之后

 <% 
         String topic="";
             Connection con=Singleton.getMySqlConnection();
              Statement st=con.createStatement();
            Statement st1=con.createStatement();
            String userid=(String)session.getAttribute("userid");
          ResultSet rs1=st.executeQuery("select sub_category from subjects where category='"+category+"'");     
          ResultSet rs2=st1.executeQuery("select topic from topic_alerts where username='"+userid+"' order by topic ");
        %>

现在，我想选中一个基于topic_alerts表的复选框，主题值等于subjects表的值。

<%while(rs1.next()){%>

<%if(rs2.next()){%>
<%
topic=rs2.getString(1);
System.out.println("topic="+topic);
System.out.println("alert="+rs1.getString(1));

%>
<%}%>
      <tr class="tablePlainWhite" style='vertical-align:top'>
<td><input type="checkbox" value="<%=rs1.getString(1)%>" <%if((rs1.getString(1).equals(topic))){%> CHECKED name="top"<%}else{%> name="topic" <%}%>></td>
<td><%=rs1.getString(1)%></td>
<td nowrap align="center"><a href="">Latest Results</a>&nbsp;&nbsp;<a href="">Archive/Details</a></td>
<td align="center">Weekly</td></tr>
 <%}%>  

这里只选中最后一个复选框媒体技术之前，历史，和语言和语言学没有被选中。

如何修复这些..。

Answer 1

但我用的就像

<%if(rs2.next()){%>
<%
topic=rs2.getString(1);
%>
<%}%>   

      <tr class="tablePlainWhite" style='vertical-align:top'>
<td><input type="checkbox" value="<%=rs1.getString(1)%>" <%if((rs1.getString(1).equals(topic))){%> CHECKED name="top" <%}else{%> name="topic" <%rs2.previous();%> <%}%>></td>
<td><%=rs1.getString(1)%></td>
</tr>
 <%}%>

Answer 2

尝试比较两个resultSet的逻辑：

while(rs1.next()){
// Compare till rs1 reach to the last record
  while(rs2.next()){
     if(){
       // Coding
     }
  }
//will move resultSet cursor to first position.
rs2.first();
}