dimanche 26 mai 2019

I want to give 'edit-link i.e edit' if ans column of table from database is null

I am retriving answer from ans column by using jdbc and showing it into a jsp page in a form of a table, if ans column is null or empty then i have to give a user edit link, but if ans column has a value then i m goin to show answer but the problem is if-else condition is not working.Please help me to solve this,My code is given below:

<div class="table-responsive">
                  <table class="table center-aligned-table">
                    <thead>
                      <tr class="text-primary">
                        <th>Question No</th>
                        <th>Question Name</th>
                        <th>Answer:</th>
                        <th> </th>
                        <th> </th>

                        <th></th>
                        <th></th>
                        <th></th>
                      </tr>
                      </thead>
                       <tbody>
                      <% 

                         try{

                             int oopa=1;

                             //String nme=(String)session.getAttribute("vname7");

                             DbCon cc=new DbCon();
                             Connection onn=cc.fun();
                             Statement stt=onn.createStatement();

                             ResultSet r=stt.executeQuery("select ques,ans from postquestion;");

                             while(r.next()){ 


                      %> 


                      <tr class="">
                        <td><center><%=oopa++%></center></td> 
                        <td><%=r.getString(1)%></td> 
                        <% 


                           if(r.getString(2)==null) 
                           {
                               %>


                               <td><a href="">Edit</a></td> 


                               <%
                               }
                         else
                              {   
                               %>
                        <td><%=r.getString(2)%></td>

                        <%  
                         }  
                        %>

                          <td> </td>

                      </tr>


                       <%

                           }
}
                          catch(Exception vjin){

                                  System.out.println("I am vjin: "+vjin);
                                  vjin.printStackTrace();

                                  }

                       %>

                    </tbody>
                  </table>
                </div>


Aucun commentaire:

Enregistrer un commentaire