<%@page language="java" import="Database.*,mominpura.*"%> <%! String character; java.sql.Connection connection; java.sql.Statement st; java.sql.ResultSet rs; %> <%="Please wait the result is being fetcheded for :" + request.getParameter("sec") %> <% character=request.getParameter("sec"); try{ Class.forName(mominpura.DbLayer.driver).newInstance(); connection = java.sql.DriverManager.getConnection(mominpura.DbLayer.url); st = connection.createStatement(); rs = st.executeQuery("select * from grave where left(grave_code,1)='"+character+"' order by cast(substring(grave_code,2) as unsigned)"); if(rs!=null) { %> <% while(rs.next()){ String surName=rs.getString("sur_name"); String firstName=rs.getString("first_name"); String lastName=rs.getString("last_name"); String fathersName=rs.getString("fathers_name"); int id=rs.getInt("id"); String graveCode=rs.getString("grave_code"); %> <% } %>

Grave Code	Name	Fathers Name/Husband Name
<%=adText.AdText.firstLetterToUpperCase(graveCode)%>	<%=firstName+" "+lastName+" "+surName%>	<%=fathersName%>	Show Grave

<% } st.close(); connection.close(); } catch(Exception e){ e.printStackTrace(); } %>