value not passing to the while loop

[Aravind Prasad]

Dear Ranchers,
I'm doing a project in JSP. In this I'm passinga value string value status which is equal to 0 and later will convert that to a integer value x. When i put the condition if(x==0) then it is not printing the function.

Please help me to sort out this problem..

String status = request.getParameter("status");
if(status.equals("all"))
{query = "Select * from register_order where client like'"+client+"' and fpono like '"+fpo_no+"' order by fpodate desc";
}
else
{query = "Select * from file_details where status="+status +" GROUP BY id";
}
[B]x = Integer.parseInt(status);
out.println("status="+x); [/B]
String id="",fpo="";
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{out.println(x);
i++;
id = rs.getString(1);
fpo= rs.getString(2);

if(!status.equals("all"))
{//out.println(status);
[B]if(x==0)
{String q = "Select * from register_order minus select * from file_details";
out.println(q);
}[/B] [I]//this part is not executing [/I]

Please help me..

Thanks in advance

regards

Aravind Prasad

[Pankaj Patel]

Your code is wrong.

You first tell me is it possible to convert String Variable to Integer.

You had compared your status variable to "all".
Now as for example what if your status value is "all".
It will come to Integer.parse("all") and will generate exception.

You can check it using

try
{
    //Your code goes here
}
catch(Exception e)
{
   e.printStackTrace();
}

[Aravind Prasad]

sorry that code is really wrong.. I sent the wrong one..

the code is here

if(status.equals("all"))
{query = "Select * from register_order where client like'"+client+"' and fpono like '"+fpo_no+"' order by fpodate desc";
}
else
{query = "Select * from file_details where status="+status +" GROUP BY id";
x = Integer.parseInt(status);
}

String id="",fpo="";
ResultSet rs = stmt.executeQuery(query);
//out.println("status = "+x);
while(rs.next())
{i++;
id = rs.getString(1);
fpo= rs.getString(2);
if(!status.equals("all"))
{
[B]if(x==0) [/B]
{String q = "select * from register_order where id not in  (select id from file_details)";
ResultSet rs1 = stmt1.executeQuery(q);
int j=0;
while(rs1.next())
{j++;
fpo= rs1.getString(2);
%>
<tr>
<td width=5% class="new" align="center"> <%=j%></td>
<td width=10% class="new" align="center"> <%=fpo%></td>
<td width=12% class="new" align="center"> <%=dateFormat.format(rs1.getDate(3))%></td>
<td width=12% class=new align=center> <%=dateFormat.format(rs1.getDate(4))%></td>
<td width="25%" class="new1" align="center">  <%=rs1.getString(5)%></td>
<td width="25%" class="new" align="center"> <%=rs1.getString(6)%></td>
<td width="5%" class="new" align="center">
<a class="textus" href="update.jsp?id=<%=id%>&fpo=<%=fpo%>" target="_parent">Update</a> 
</tr>
<%}
}
else
{String query1 = "Select * from register_order where id='"+id+"'";
//out.println(query1);
ResultSet rs1 = stmt1.executeQuery(query1);
while(rs1.next())
{fpo= rs1.getString(2);
%>
<tr>
<td width=5% class="new" align="center"> <%=i%></td>
<td width=10% class="new" align="center"> <%=fpo%></td>
<td width=12% class="new" align="center"> <%=dateFormat.format(rs1.getDate(3))%></td>
<td width=12% class=new align=center> <%=dateFormat.format(rs1.getDate(4))%></td>
<td width="25%" class="new1" align="center">  <%=rs1.getString(5)%></td>
<td width="25%" class="new" align="center"> <%=rs1.getString(6)%></td>
<td width="5%" class="new" align="center">
<a class="textus" href="update.jsp?id=<%=id%>&fpo=<%=fpo%>" target="_parent">Update</a> 
</tr>
<%}
   }
   }
   else
   {
   %>
<tr>
<td width=5% class="new" align="center"> <%=i%></td>
<td width=10% class="new" align="center"> <%=fpo%></td>
<td width=12% class="new" align="center"> <%=dateFormat.format(rs.getDate(3))%></td>
<td width=12% class=new align=center> <%=dateFormat.format(rs.getDate(4))%></td>
<td width="25%" class="new1" align="center">  <%=rs.getString(5)%></td>
<td width="25%" class="new" align="center"> <%=rs.getString(6)%></td>
<td width="5%" class="new" align="center">
<a class="textus" href="update.jsp?id=<%=id%>&fpo=<%=fpo%>" target="_parent">Update</a> 
</tr>
   
   <%
   }
}
 

I hope this is the correct code I'm sending.
Please help me to sort this thing

regards
Aravind Prasad

[Svend Rost]

Hi Aravind,

in the beginning of your code there is an if-else statement.

    
if(status.equals("all")){
  query = ...
}else{
 query = ...
 x = ...
}

If x isn't initialized (to 0) before the if-else statement and the string
status doesn't equal "all" x wont have the value 0. If it doesn't have the
value 0 the "program" wont enter the if(x==0) block of your code.

Does this make sence?

/Svend Rost