Sunday, November 10, 2013

Result set in jsp



       try
       {


       Connection conn12=null;
    XXPNDBConnection db12=new XXPNDBConnection();
    conn12=db12.getPooledConnection();
    Statement stmt12=conn12.createStatement();
    ResultSet rs12=null;

    rs12=stmt12.executeQuery(" select in_time,out_time from xxpn_elapsed where TIMING is not null");

     String stime=null;
     String otime=null;

     while(rs12.next())
     {
     stime=rs12.getString(1);
     otime=rs12.getString(2);
     }



       %>

      <td nowrap="" align="left"><font size="2"><%=stime%>-<%=otime%> </font></td>

No comments:

Post a Comment