<%@page language="java" import="Database.*,mominpura.*"%> <%! int id,dod_day,dod_year,dob_day,dob_year; String dod_month,dob_month,grave_code; java.sql.Connection connection; java.sql.Statement st; java.sql.ResultSet rs; String getPictureURL(String graveCode){ if(Character.isLetter(graveCode.charAt(0))){ StringBuffer sb=new StringBuffer(graveCode); sb.insert(1,'/'); return sb.toString(); } return graveCode; } %> <% grave_code=request.getParameter("id"); id=Integer.parseInt(request.getParameter("id")); 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 id="+id); 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"); // long dod=rs.getLong("date_of_death"); // long dob=rs.getLong("date_of_birth"); dod_day=rs.getInt("dod_day"); dod_month=rs.getString("dod_month"); dod_year=rs.getInt("dod_year"); dob_day=rs.getInt("dob_day"); dob_month=rs.getString("dob_month"); dob_year=rs.getInt("dob_year"); String gender=rs.getString("sex"); String otherInfo=rs.getString("cause_of_death"); %>

<%=surName+" "+firstName+" "+lastName%>

Recite Sura Fatiha

<% } %>

Grave Code	<%=graveCode%>
Family's Name	<%=surName%>
First Name	<%=firstName%>
Last Name	<%=lastName%>
Father's Name/Husband's Name	<%=fathersName%>
Date of Death	<%--=java.text.DateFormat.getDateInstance(java.text.DateFormat.FULL).format(new java.util.Date(dod))--%> <%=(dod_day>0?Integer.toString(dod_day):"")%>-<%= (!dod_month.equals("-1")?dod_month:"")%>-<%=(dod_year>0?Integer.toString(dod_year):"")%>
Date of Birth	<%--=java.text.DateFormat.getDateInstance(java.text.DateFormat.FULL).format(new java.util.Date(dob))--%> <%=(dob_day>0?Integer.toString(dob_day):"")%>-<%= (!dob_month.equals("-1")?dob_month:"")%>-<%=(dob_year>0?Integer.toString(dob_year):"")%>
Gender	<%=gender%>
Other Information	<%=otherInfo%>

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