急！~~~两个while(rs.next)表单怎么取值？

<body>
<%      
DBSQLManager dbsm = new DBSQLManager();
String sql="select * from tjksb";
dbsm.setSqlStr(sql);
dbsm.executeQuery();
ResultSet rs=dbsm.getRs();
%>
<table width="700" border="1" cellpadding="0" cellspacing="0" bgcolor="#f1f3f5" align="center">
  <tr>
    <th height="20" colspan="6" class=tableHeaderText><a class="title">个人套餐选择</a>  
  </tr>
<form name="form" action="gr_tc_choice_make.jsp" method="post">
  <tr>
    <th height="20" colspan="2" class=tableHeaderText>个人编号：
    <input type="text" name="grbh">
    <th class=tableHeaderText> 
    <th colspan="3" class=tableHeaderText>
 </tr>
  <tr>
    <th height="20" colspan="2" class=tableHeaderText>
    <th class=tableHeaderText height="20">  
    <th class=tableHeaderText>
  </tr>
  <%
  while (rs.next()){
  %>
  <tr>
    <th class=tableHeaderText height="20">检查科室
    <th class=tableHeaderText><input type="text" readonly name="ksmc" value="<%=rs.getString("ksmc")%>">
    <th class=tableHeaderText height="20">  
    <th class=tableHeaderText>
  </tr>
  <%    
        String ksbh= new String(rs.getString("ksbh"));    

DBSQLManager dbsm_ = new DBSQLManager();
String sql_="select a.ksbh,a.ksmc,b.xmmc,b.xmbh from tjxmb as b,tjksb as a where a.ksbh=b.ksbh and a.ksbh='"+ksbh+"'";
dbsm_.setSqlStr(sql_);
dbsm_.executeQuery();
ResultSet rs_=dbsm_.getRs();
%>
  <tr>
    <th width="21%" height="20" colspan="2" class=tableHeaderText><div align="center">项目编号</div>
    <th class=tableHeaderText width="21%" height="20"><div align="center">项目名称</div>
    <th class=tableHeaderText width="13%"><div align="center">选择</div> 
  </tr>
<%     while(rs_.next()) 
{
%>
  <tr>
    <td height="20" colspan="2"><div align="center"><%=rs_.getString("xmbh")%></div></td>
    <td height="20"><div align="center"><%=rs_.getString("xmmc")%></div></td>
    <td><div align="center">
      <input type="checkbox" name="xmbm" value="<%=rs_.getObject("xmbh")%>"></div></td>
  </tr>
  <%}
 }%>
  <tr>
      <td colspan="2"><input type="submit" name="submit" value="确认"></td>
      <td><input type="reset" name="reset" value="重置"></td> 
  </tr>
  </form>
</table> 怎么取得 项目编号(xmbh)的值 并根据个人编号(grbh)插入数据库？希望提供下源码。(分不够再加)

解决方案 »

  1.   

    只用一个循环的时候完全正常
    用2个循环后，递交表单失败 错误提示：
    HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    root cause java.lang.NullPointerException
    org.apache.jsp.gr_005ftc_005fchoice_005fmake_jsp._jspService(gr_005ftc_005fchoice_005fmake_jsp.java:96)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    note The full stack trace of the root cause is available in the Tomcat logs.
      

  2.   

    应该是sql和rs重名了！你把一个换个名字看看