resultset is not working properly

[Rd Dari]

Hi all,


I have following code... what is the problem in this it is fetching value only second query

stmt=(Statement)con.createStatement();
                          sql="Select society_name,appartment_no,grid_last_units,dg_last_units from resident_elec_bill_ref where society_name='"+elec_id+"'";
                          rs=stmt.executeQuery(sql);
                          System.out.println("qry is:: "+sql);
                          if(rs.next()){
                           do{
                             bn=true;
                             socs=rs.getString(1);
                             apt_no=rs.getString(2);
                             lgridunit=rs.getString(3);
                             lastdgunit=rs.getString(4);
                             
                             System.out.println("Society Name is ===  "+socs);
                             System.out.println("Appartment NO is ====  "+apt_no);
                             System.out.println("Grid unit is ====  "+lgridunit);
                             System.out.println("DG unit is ====   "+lastdgunit);
                           }while(rs.next());
                           }
                            stmt=(Statement)con.createStatement();
                            sql1="Select * from appartment where society_name='"+elec_id+"'";
                            rs=stmt.executeQuery(sql1);
                            System.out.println("Query second is " + sql1);
                                 while(rs.next()){
                                 bn=true;
                                 socs=rs.getString(3);
                                 apt_no=rs.getString(6);
                                 lgridunit=rs.getString(20);
                                 lastdgunit=rs.getString(21);
                                 %>
                                <tr>
                                <input type="hidden" name="society_name" value="<%=socs%>">
                                    <td align="center" class="centerfont" width="12%">
                                        <input type="text" size="10" name="flat_no" value="<%=apt_no%>"></td>
                                    <td align="center" width="18%">
                                        <input type="text" size="14" name="grid_last_unit" value="<%=lgridunit%>"></td>
                                    <td align="center" width="18%">
                                        <input type="text" size="14" name="grid_new_unit" value=""></td>
                                    <td align="center" width="18%">
                                        <input type="text" size="14" name="dg_last_unit" value="<%=lastdgunit%>"></td>
                                    <td align="center" width="18%">
                                        <input type="text" size="14" name="dg_new_unit" value=""></td>
                                    <!--td align="center">
                                        <input type="button" name="button" class="button" value="Report" onclick="//return showBill('<%//=rs.getString(2)%>')"></td-->
                                </tr>
                            <%
                            }
                            %>

I have value in resident_ele_bill_ref but it is not taking that values...

please tell me what is the wrong in this code...

Thanks

[Jeanne Boyarsky]

closing accidental duplicate: http://www.coderanch.com/t/545634/JDBC/java/resultset-not-working-properly