prepared statement is not working according to if condition

[rakhi sinha]

This is servlet by which i am inserting values in the database but if i dont enter any value of i2,q2,c2,i3,q3 and c3 then according to my servlet it should not insert any values to database but it is not doing so..if condition is not working......

 
String a = req.getParameter("ccno");//ccno  
     String k=req.getParameter("radiobutton1");//item type
    String i1 = req.getParameter("i1");//description of item1
     String q1 = req.getParameter("q1");//quantity1
    String c1 = req.getParameter("c1"); //price1
    String i2 = req.getParameter("i2");//description of item2
   String q2 = req.getParameter("q2");//quantity2
   String c2 = req.getParameter("c2"); //price2
    String i3 = req.getParameter("i3");//description of item3
   String q3 = req.getParameter("q3");//quantity3
    String c3 = req.getParameter("c3"); //price3
PreparedStatement pst = con.prepareStatement("INSERT into p VALUES(?,?,?,?,?)"); 
     if(i1!=null)
     {
     pst.setString(1,k);  
     pst.setString(2,i1); 
     pst.setString(3,q1);  
     pst.setString(4,c1); 
     pst.setString(5,a); 
     pst.executeUpdate();
     }
     pst3.close();
    
     if(i2!=null)
     { 
      pst.setString(1,k);  
     pst.setString(2,i2); 
     pst.setString(3,q2);  
     pst.setString(4,c2); 
     pst.setString(5,a);  
     pst.executeUpdate();
     }
     if(i3!=null)
     {
      pst.setString(1,k);  
     pst.setString(2,i3); 
     pst.setString(3,q3);  
     pst.setString(4,c3); 
     pst.setString(5,a);  
     pst.executeUpdate();
        }
     pst.close();

this is second servlet

out.println("<tr>"+
"<td>1.</td>"+
"<td>"+"<input type=\"text\" name=\"i1\" /></td>"+
"<td>" +"<input type=\"text\" name=\"q1\" /></td>"+
"<td> "+"<select name=\"select8\">"+"<option>1</option><option>2</option><option>3</option></select></td>"+
"<td>"+"<input type=\"text\" name=\"c1\" /></td>"+"</tr>");
out.println("<tr>"+
"<td>2.</td>"+
"<td>"+"<input type=\"text\" name=\"i2\" /></td>"+
"<td>"+"<input type=\"text\" name=\"q2\" /></td>"+"<td>"+"<select name=\"select10\">"+
"<option>1</option><option>2</option><option>3</option></select></td>"+"<td>"+
"<input type=\"text\" name=\"c2\" /></td>"+"</tr>");
out.println("<tr>"+"<td>3.</td>"+"<td>"+"<input type=\"text\" name=\"i3\" /></td>"+
"<td>"+"<input type=\"text\" name=\"q3\" /></td>"+"<td>"+"<select name=\"select11\">"+
"<option>1</option><option>2</option><option>3</option></select></td>"+"<td>"+
"<input type=\"text\" name=\"c3\" /></td>"+"</tr>"+"</table></td>");
out.println(" </tr> </table>");
out.println("</b> <input type=\"submit\" name=\"Submit\" value=\"Submit\" ><br></centre>

[Tim Moores]

This looks like the exact same question you asked in http://www.coderanch.com/t/573992/JDBC/java/prepared-statement, where apparently you just gave up after receiving several replies.

[Martin Vajsar]

Rakhi, there is no way an if condition would "not be working". If the i1 is not null, the body of the if statement is executed, if it is null, it isn't executed. There is no third possibility out there.

I'd strongly suggest to activate logging in your application (if you do not know why, try to search out or maybe ask in some relevant forum here) and print all the variables in your code to a log to see what you're getting in. Another option would be to debug your application using a debugger, if that is feasible for your architecture. You need to learn at least one of these two approaches, if you want to be able to do a career in programming.

[rakhi sinha]

Martin Vajsar wrote:Rakhi, there is no way an if condition would "not be working". If the i1 is not null, the body of the if statement is executed, if it is null, it isn't executed. There is no third possibility out there.

I'd strongly suggest to activate logging in your application (if you do not know why, try to search out or maybe ask in some relevant forum here) and print all the variables in your code to a log to see what you're getting in. Another option would be to debug your application using a debugger, if that is feasible for your architecture. You need to learn at least one of these two approaches, if you want to be able to do a career in programming.

i dont understand why my code is not running ......how to activate logging in my application.

[Wendy Gibbons]

Tim Moores wrote:This looks like the exact same question you asked in http://www.coderanch.com/t/573992/JDBC/java/prepared-statement, where apparently you just gave up after receiving several replies.

I was going to reply:
You still haven't changed your varibale names.