SHOUBHIK BOSE

<%@ page import="javax.servlet.http.HttpSession"%>

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


<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>MESSAGE BOX</title>
</head>
<body>
	<h2> RECIEVED MESSAGES </h2>

<a name="a" href="/DEMO1/submitEmail.jsp">COMPOSE MESSAGE</a>
<a name="a" href="/DEMO1/showMessage.jsp">RECIEVED MESSAGES</a>
<a name="a" href="/DEMO1/showSentMessage.jsp">SENT MESSAGES</a>

<a></a>
<%
	HttpSession hs=request.getSession(false);
	String uid=(String)hs.getAttribute("user_id");
%>

The logged in user is: <%=uid %>
	<br><br><br>
	<table frame="box">
		<tr>
		  <td>SUBJECT </td>  <td> SENT BY </td> <td>SENT TO</td>
		<tr>
<%
    Connection con = null;
	Statement stmt = null;
	try {
		Context initContext = new InitialContext();
		DataSource ds = (DataSource)initContext.lookup("java:comp/env/jdbc/DataSource");
	// Get a database connection
	con = ds.getConnection();
	}
	catch(java.lang.Exception e) {
		e.printStackTrace();
		System.err.print(e.getClass().getName());
		System.err.println(e.getMessage());
	}

	try{
		stmt = con.createStatement();

		ResultSet rs=stmt.executeQuery("SELECT MESSAGE_DETAILS.OPENED, MESSAGE_DETAILS.MESSAGE_ID, MESSAGE_DETAILS.SENDEE_ID, MESSAGE_DETAILS.SENDER_ID, MESSAGE_DETAILS.SUBJECT, MESSAGE_DETAILS.MESSAGE_ID FROM SHOUBHIK.MESSAGE_DETAILS AS MESSAGE_DETAILS WHERE MESSAGE_DETAILS.SENDEE_ID = "+uid);

		while (rs.next()) {
%>


		<tr>
		    <td><a target="iframe_a" name="a" href="/DEMO1/showBody.jsp?mid=<%=rs.getString("message_id")%>"><%=rs.getString("subject")%> </a></td>
			<td><%= rs.getString("sender_id") %></td>
			<td><%= rs.getString("sendee_id") %></td>
		</tr>

			<%
		}

		rs.close();
		stmt.close();
		con.close();
	}

	catch(Exception e){

		e.printStackTrace();
		System.err.print(e.getClass().getName());
		System.err.println(e.getMessage());

	}
	stmt.close();
	con.close();

%>

</table>
<br><br><br>
<iframe src="/DEMO1/showMessage.jsp" name="iframe_a" width="700"></iframe>
</body>
</html>