checkmail.jsp

bbs设计是一个论坛方面的设计 基于jsp的系统设计

<%@ page language="java" import="java.util.*" %> 
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<%
//--------<<<<<<This code check if you have mail arrived when login>>>>>>>>>>>>>>>>---------------
int intRowCount=0;
String strReceiver="";
strReceiver=(String)session.getAttribute("user");
//String strUid=(String)session.getAttribute("uid");
//out.print(strReceiver+strUid);

//intUid=new Integer();
    String sql="SELECT INT_ID FROM INTRAMAIL WHERE STR_RECEIVER='"+strReceiver+"' and INT_FLAG=1";
    ResultSet Rst=DB.executeQuery(sql);
    if(Rst.next()){
	//--------------check who got mail------------------------
	if(application.getAttribute("vctWhogotmail")!=null){
		Vector v=new Vector();
		 v=(Vector)application.getAttribute("vctWhogotmail");
		 Integer intUid=new Integer(0);
         intUid=(Integer)session.getAttribute("uid");
		if(v.contains(intUid)){
	     
		 }else{
	    v.addElement(session.getAttribute("uid"));
	    application.setAttribute("vctWhogotmail",v);
	   }
	 
	
        }else{out.print("You need initiate first!!");}
		//-----------------------------------------)   
	}
	
	Rst.close();
%>