keepforlzs.java

JAVA邮件系统

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

public class KeepForLzs extends HttpServlet 
{
	String sLeibie;
	String sLanmu;

    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 = CommonMethods.getParameterValue (request,"Name");
		String pass = CommonMethods.getParameterValue (request,"Password");
		if(name!=null&&pass!=null){
			htmlOut.addCookie ("username",name);
			htmlOut.addCookie ("password",pass);
		}
		else{//other we get it by cookie;
			name = CommonMethods.GetUserName(request);
			pass = CommonMethods.GetUserPass(request);
		}
		Person p=new Person();
		p.setName (name);
		if( p.getName ()==null || (!p.checkPassword(pass))
			||(!p.IsSuperMan () && !p.IsManager ()))
		{
	    	htmlOut.setErrorID (htmlOut.SHOW_SIMPLE_MESSAGE ,"",
								"请先登录！","Login?action=reLog");
			htmlOut.outHtml();
			return;
		}
		String sql="select * from webaccess order by access DESC";
		DBOperater DB = new DBOperater("");
		ResultSet rs;
		
		try{
			rs = DB.executeQuery (sql);
			while(rs.next () ){
				String sID = rs.getString (1);
				String sAccess= rs.getString (3);
				getTitle(sID);
				htmlOut.addString ("类别："+ sLeibie);
				htmlOut.addString ("；栏目："+ sLanmu);
				htmlOut.addString ("；访问量："+ sAccess);
				htmlOut.addString ("<br>");
			}
		}catch(Exception e){
		}
		DB.close ();
		htmlOut.outHtml();
	}

	void getTitle(String sID)
	{
		DBOperater DB = new DBOperater("");
		ResultSet rs;
		String sql="select * from category where cateid = '"
			+sID+"'";
			
		try{
			rs = DB.executeQuery (sql);
			if(rs.next () ){
				sLanmu = rs.getString (2);
			}
		}catch(Exception e){
		}
		
		sql="select * from category where cateid = '"
			+sID.substring(0,4)+"0000" +"'";
		try{
			rs = DB.executeQuery (sql);
			if(rs.next () ){
				sLeibie = rs.getString (2);
			}
		}catch(Exception e){
		}
		DB.close ();
	}
	
}