maildzadd.java

JAVA邮件系统

import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class MailDZAdd extends HttpServlet 
{

    public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException
    {
		doGet(request,response);
	}
	
	public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException
    {
		HtmlOut htmlOut = new HtmlOut (response);
		
		// 得到名字和口令
		String name="",pass;

		Person person = new Person();
		person.setName (CommonMethods.GetUserName(request));
		pass = CommonMethods.GetUserPass (request);
		if( person.getName ()==null || (!person.checkPassword(pass)) )
		{
	    	htmlOut.setErrorID (htmlOut.SHOW_SIMPLE_MESSAGE ,"",
								"请先登录！","Login?action=reLog");
			htmlOut.outHtml();
			return;
		}

		String sAddFrom = CommonMethods.getParameterValue (
											request,"addfrom");
		String sAddSubject = CommonMethods.getParameterValue (
											request,"addsubject");
		String sDelete = CommonMethods.getParameterValue (
											request,"delete");
		int warntype = 0;
		int nWarnby   = 0;
		if( sAddFrom!=null||sAddSubject!=null||sDelete!=null ){
			DBOperater DB = new DBOperater ("");
			ResultSet rs=DB.executeQuery ("select * from useremail where username='"
										  + person.getName () +"'");
		
			try{
				if( rs!=null&&rs.next () ){
					warntype= rs.getInt (4);
					nWarnby = rs.getInt (5);
				}
			}catch(Exception e){
			}
		
			
			if( warntype<2 ){
				htmlOut.setErrorID (htmlOut.SHOW_SIMPLE_MESSAGE  ,"",
								"现在你不能选择通知，请回前页！",
								"MailDZServlet");
				htmlOut.outHtml();
				DB.close ();
				return;
			}
			if( sAddFrom!=null &&sAddFrom.length ()>0 ){
				String sVa = CommonMethods.getParameterValue (
									request,"from");
				DB.executeUpdate ( "insert into useremail values('"
								   + person.getName ()+"','"
								   + sVa + "','"
								   + "" + "',"
								   + warntype  + ","
								   + nWarnby
								   +")" );
			}
			if( sAddSubject!=null &&sAddSubject.length ()>0 ){
				String sVa = CommonMethods.getParameterValue (
									request,"subject");
				DB.executeUpdate ( "insert into useremail values('"
								   + person.getName ()+"','"
								   + "" + "','"
								   + sVa + "',"
								   + warntype  + ","
								   + nWarnby
								   +")" );
			}
			String sVa = CommonMethods.getParameterValue (
									request,"value");
			if( sDelete!=null &&sDelete.compareTo ("from")==0 ){
				DB.executeUpdate ( "delete from useremail where username='"
									  + person.getName () +"' and mailfrom='"
								      +sVa+"'" );
			}
			if( sDelete!=null &&sDelete.compareTo ("sub")==0 ){
				DB.executeUpdate ( "delete from useremail where username='"
									  + person.getName () +"' and subject='"
								      +sVa+"'" );
			}
			DB.close ();
		}
		
		Vector allWarns = new Vector (5,5);
		Vector allWarnTypes = new Vector (5,5);
		
		DBOperater DB = new DBOperater ("");
		ResultSet rs=DB.executeQuery ("select * from useremail where username='"
									  + person.getName () +"'");
		
		try{
			while( rs!=null&&rs.next () ){
				String sFrom = rs.getString (2);
				String sSub= rs.getString (3);
				if( sFrom!=null&&sFrom.length ()>0 ){
					allWarns.addElement ( sFrom );
					allWarnTypes.addElement ("1");
				}
				if( sSub!=null&&sSub.length ()>0 ){
					allWarns.addElement ( sSub );
					allWarnTypes.addElement ("2");
				}
			}
		}catch(Exception e){
		}
		
		DB.close ();
		TemplateList tempList = CommonMethods.getMailDZAddTemplate ();
		String sKey;
		if(tempList!=null){
			SingleTemplate st=tempList.searchTemplate("ROOT");
			for(int i=0;i<st.getKeyNum()  ;i++){
				sKey= st.getKeyAt (i);
				htmlOut.addString ( st.getStringAt (i) );
				if( sKey .compareTo("cgi-path")==0 )
					htmlOut.addString (CommonMethods.sHostNameCGI);
				if( sKey.compareTo ("alluserselect")==0 ){
					for( int j=0;j<allWarns.size ();j++){
						if( ( (String)allWarnTypes.elementAt (j) ).compareTo ("1")==0 ){
							htmlOut.addString ( "<br>来自\""+
												(String)allWarns.elementAt(j)  
												+"\"的邮件"
												+"<a href=MailDZAdd?delete=from&value="
											    +(String)allWarns.elementAt(j)  
												+">"+" 删除"+"</a>"
											   );
						}
						if( ( (String)allWarnTypes.elementAt (j) ).compareTo ("2")==0 ){
							htmlOut.addString ( "<br>主题包含\""+
												(String)allWarns.elementAt(j)  
												+"\"的邮件"
												+"<a href=MailDZAdd?delete=sub&value="
											    +(String)allWarns.elementAt(j)  
												+">"+" 删除"+"</a>"
											   );
						}
					}
				}
			}		
			htmlOut.addString (st.getEndString ());
		}
		htmlOut.outHtml ();
	}
}