maildzservlet.java

JAVA邮件系统

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

public class MailDZServlet 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;
		}

		int warntype = 0;
		int nWarnby   = 0;
		String sSet = CommonMethods.getParameterValue (request,"set");
		if( sSet !=null ){
			String sOpen = CommonMethods.getParameterValue (request,"warn");
			String sSel  = CommonMethods.getParameterValue (request,"dz");
			String warnby= CommonMethods.getParameterValue (request,"warnby1");
			
			if( warnby!=null )
				nWarnby |= 1;
			warnby= CommonMethods.getParameterValue (request,"warnby2");
			if( warnby!=null )
				nWarnby |= 2;
			if( sOpen!=null ){
				if( sOpen.compareTo ("close")==0 )
					warntype = 0;
				if( sOpen.compareTo ("open")==0 )
					warntype = 1;
			}
			if( sSel!=null&&sSel.compareTo ("dzselect")==0 )
				warntype = 2;
			DBOperater DB = new DBOperater ("");
			if( warntype==0 ){
				DB.executeUpdate ( "delete from useremail where username='"
									  + person.getName () +"'");
			}
			if( warntype==1 ){
				DB.executeUpdate ( "delete from useremail where username='"
									  + person.getName () +"'");
				DB.executeUpdate ( "insert into useremail values('"
								   + person.getName ()+"','"
								   + "" + "','"
								   + "" + "',"
								   + 1  + ","
								   + nWarnby
								   +")" );
			}
			if( warntype==2 ){
				ResultSet rs=DB.executeQuery ("select * from useremail where username='"
									  + person.getName () +"'");
				try{
					if( rs==null||!rs.next () ){
						DB.executeUpdate ( "insert into useremail values('"
								   + person.getName ()+"','"
								   + "" + "','"
								   + "" + "',"
								   + 2  + ","
								   + nWarnby
								   +")" );
					}
				}catch(Exception e){
				}
				DB.executeUpdate ( "update useremail set warntype = 2 , warnby = "
								  + nWarnby +" where username='"
								  + person.getName () +"'");
			}
			
			//set warn by in person table;
			DB.executeUpdate ( "update person set mailtx = "+nWarnby
							   +" where username='"
								  + person.getName () +"'");
			DB.close ();
			
			htmlOut.setErrorID (htmlOut.SHOW_SIMPLE_MESSAGE ,"",
								"设置成功！","MailDZServlet");
			htmlOut.outHtml ();
			return;
		}
		
		TemplateList tempList = CommonMethods.getMailDZTemplate ();
		String sKey;
		
		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){
		}
		
		DB.close ();
		
		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 ("warntype")==0 ){
					if( warntype==0 )
						htmlOut.addString ("0");
					else
						htmlOut.addString ("1");
				}
				if( sKey.compareTo ("seltype")==0 ){
					if( (warntype&1)!=0 )
						htmlOut.addString ("0");
					if( (warntype&2)!=0 )
						htmlOut.addString ("1");
				}
				if( sKey.compareTo ("warnby")==0 ){
					htmlOut.addString (Integer.toString(nWarnby) );
				}
			}		
			htmlOut.addString (st.getEndString ());
		}
		htmlOut.outHtml ();
	}
}