opt=rs.getString("FinancialYear");
  %>

<option value="<%=opt%>"><%=opt%></option>
 <%
}


 %>
</select>

    </td>
    </tr>

   <!--            <tr>
                 <td bgcolor="#00FFFF"><b>CLASS</b></td>
                 <td bgcolor="#00FFFF"><select name="tcls" id="cls">
                  <option value="gen">GENERAL</option>
                   <option value="slp">SLEEPER</option>
                   </select>
                 </td>
               </tr>     -->
             </table>

             <p>
               <input type="submit" value="SearchAMC">
             </p>
             <p><a href="home.jsp">LOGOUT</a></p>
             </div>
             <p align="center"> </p>
             <p align="center"><br>
          </p></td>
         </tr>
       </table>
     </div>


 <center>
  <div id="view_res"></div>
 </center>

<%-- Document : view Created on : Nov 29, 2013, 4:32:39 PM

--%>

search_trial.jsp

<%--

--%> <%@page import="java.sql.*"%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>

    <%

    String exportToExcel = request.getParameter("exportToExcel");
    if (exportToExcel != null
            && exportToExcel.toString().equalsIgnoreCase("YES")) {
        response.setContentType("application/vnd.ms-excel");
        response.setHeader("Content-Disposition", "inline; filename="
                + "excel.xls");

    }

     String so=request.getParameter("sr");
  out.println(so);
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String sSql ="SELECT * from details where FinancialYear='"+so+"'"; String sDBQ = "C://Users/keltron022/Documents/amc.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + sDBQ + ";DriverID=22;READONLY=true"; Connection cn = null; Statement st = null; ResultSet rs = null; try {

cn = DriverManager.getConnection( database ,"",""); st = cn.createStatement(); rs = st.executeQuery( sSql ); String s="";

%>
<table border='1'>