how to use <%=temp%> i retrieving data

[Rakesh Keerthi]

Hi I have the below code in my jsp

try{
    int i=0;
    int temp=0, temp1=0,temp2=0, temp3=0, temp4=0;
    ps=con.prepareStatement("Select DBID,Query_Raised,TR from Scope1 where TR!='null' AND (Query_Answered is null OR Count1 is null)");
    rs=ps.executeQuery();
    out.println("<b>QueryRaised</b>");
       while(rs.next())
                   
        {
           temp=temp+1;
           temp1=temp1+1;
           temp2=temp2+1;
           temp3=temp3+1;
           temp4=temp4+1;        
           i++;
           %>
                      
                      <tr><form name="abc" method="post" action="Up_Query_DB.jsp">
                      <td><input type="text" value="<%=i%>" name="id1" id="id1"></td>
                      <td><center><input type="text" value="<%=rs.getString("DBID")%>" readonly="readonly" id="<%=temp%>" name="<%=temp%>" size="100"></center></td>
                      <td><input type="button" value="Resume" name="<%=temp1%>" id="<%=temp1%>" onClick="invoke(5)"></td>
                      <td><input type="button" value="Update Answer" name="<%=temp2%>" id="<%=temp2%>"></td>
                      <td><input type="text" name="<%=temp3%>" id="<%=temp3%>" style="border:hidden"/></td>           
                      <td><input type="Submit" value="Submit Answer" name="<%=temp4%>" id="<%=temp4%>"/>
                      </td>
                      </form></tr>
    
        <% }
rs.close();
con.close();
}
catch(Exception e)
               {
    
    out.println(e);
    
}

alternatively i used EL as shown below.

try{
    int i=0;
    int temp=0, temp1=0,temp2=0, temp3=0, temp4=0;
    ps=con.prepareStatement("Select DBID,Query_Raised,TR from Scope1 where TR!='null' AND (Query_Answered is null OR Count1 is null)");
    rs=ps.executeQuery();
    out.println("<b>QueryRaised</b>");
       while(rs.next())
                   
        {
           temp=temp+1;
           temp1=temp1+1;
           temp2=temp2+1;
           temp3=temp3+1;
           temp4=temp4+1;        
           i++;
           %>
                      
                      <tr><form name="abc" method="post" action="Up_Query_DB.jsp">
                      <td><input type="text" value="<%=i%>" name="id1" id="id1"></td>
                      <td><center><input type="text" value="<%=rs.getString("DBID")%>" readonly="readonly" id="${temp}" name="${temp}" size="100"></center></td>
                      <td><input type="button" value="Resume" name="${temp1}" id="${temp1}" onClick="invoke(5)"></td>
                      <td><input type="button" value="Update Answer" name="${temp2}" id="${temp2}"></td>
                      <td><input type="text" name="<${temp3}>" id="${temp3}" style="border:hidden"/></td>           
                      <td><input type="Submit" value="Submit Answer" name="${temp4}" id="${temp4}"/>
                      </td>
                      </form></tr>
    
        <% }
rs.close();
con.close();
}
catch(Exception e)
               {
    
    out.println(e);
    
}

and in my servlet I've the below code

try{
           String a=request.getParameter("id1");
           String sc=request.getParameter("temp"+a);
           String upd=request.getParameter("temp3"+a);
           out.println(a);
       out.println(sc);
       out.println(upd);
           java.util.Date today = new java.util.Date();
       java.sql.Timestamp t= new java.sql.Timestamp(today.getTime());
       ps=con.prepareStatement("Update Scope1 Set Query_Answered='"+upd+"', TA='"+t+"' where DBID='"+sc+"'");

here i'm unable to retrieve the data from the textboxes, when i tried to print the results it is printing null.
please help me with how to retrieve the data.
This code is working if there is only 1 row.
Thanks

[Marc Peabody]

The parameter names aren't the same. You can see this by selecting "View Source" in your browser. You'll see that the parameters are NOT named things like "temp31" but rather are names like "1".

You also are susceptible to a SQL injection attack the way your putting the submitted answers directly into a database query.

[Rakesh Keerthi]

Thank you Marc for the reply. could you please help me how do i solve this.

Thanks

[Marc Peabody]

I'm not going to rewrite the entire thing for you. I want you to solve this problem.

Do you know what I meant when I said "View Source" in your browser? If so, have you tried it? What did you see?

Also, realize that you can put actual static text as part of a name to make it easier to retrieve the data:
name="upd${tempIndex}"

[Bear Bibeault]

Rakesh Keerthi,
Your post was moved to a new topic.