%
String legal = (String)session.getAttribute("UserName");
if(legal==null)
{
%>
Session expired, Sign-In again
<%
}
else
{
%>
<%@ include file="include/connection.jsp" %>
<%@ page import="java.util.Date" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.File" %>
<%!
ResultSet rs,rs1,rs2;
Statement stmt1;
String Subject=null;
String mail_from=null;
String mail_from_name=null;
String mail_file=null;
String mail_from_flag=null;
%>
<% String ss=(String)session.getAttribute("UserFlag");
try
{
String query = "Update anandu_mails.mail_info set read_flag='Y' where id=" + Integer.parseInt(request.getParameter("Edit"),10);
stmt.executeUpdate(query);
query = "select mail_info.*,user_info.* from anandu_mails.mail_info,anandu_mails.user_info where user_info.username=mail_info.mail_from and mail_info.id=" + Integer.parseInt(request.getParameter("Edit"),10);
rs = stmt.executeQuery(query);
if(rs.next())
{
mail_from=rs.getString("mail_from");
mail_from_name=rs.getString("firstname")+" " + rs.getString("middlename")+" " + rs.getString("lastname");
mail_file=rs.getString("mail_file");
mail_from_flag=rs.getString("user_flag");
}
%>
Untitled Document
<% }
catch(Exception e)
{
System.out.println("Exception caught lower is:"+e.getMessage());
}
%>
<%}%>