useradmin.java

JAVA邮件系统

/*  
 *
 */

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


/**

 */

public class UserAdmin extends HttpServlet {


    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {

		HtmlOut htmlOut = new HtmlOut (response);


		// 得到名字和口令
    String name,pass;
		//one way , user are login by name and pass;

		name = CommonMethods.getParameterValue (request,"Name");
		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 () )
		{
	    	htmlOut.setErrorID (htmlOut.SHOW_SIMPLE_MESSAGE ,"",
								"请先登录！","/WebManage");
			htmlOut.outHtml();
			return;
		}
    //根据用户选择进行操作：
    //delete--删除用户；common--将用户设为普通用户；
    //manager--将用户设为管理员；super--将用户设为超级用户
    String sAction=request.getParameter ("action");
    if ((sAction==null)||(sAction.trim ().length ()==0))
      sAction="";
    String[] sUsers=request.getParameterValues("single");
    int i=0 ,length=0;
    if((sAction!=null)&&(sAction.trim ().length ()!=0))
    {

		  if ((sUsers == null)||(sUsers.length ==0))
	  	{
		  	htmlOut.setErrorID (htmlOut.SHOW_SIMPLE_MESSAGE ,
			  					"","请选择用户","/UserAdmin");
			  htmlOut.outHtml ();
			  return;
		  }
		  length = sUsers.length ;
         for (i=0;i < length;i++)
		{

		  sUsers[i]= CommonMethods.DealWithGBCodeOfRequest (sUsers[i]);
		}
      //删除用户
      DBOperater DB = new DBOperater ("person");
      if(sAction.trim ().compareTo ("delete")==0)
		  {
        for (i=0;i < length;i++)
		    {
          DB.executeUpdate ( "delete from  person where username='"+ sUsers[i] +"'" );
		    }
      }
    //设为一般用户
     else if(sAction.trim ().compareTo ("common")==0)
      {
        for (i=0;i<length;i++)
        {
          DB.executeUpdate ( "update  person set mark=0 where username='"+ sUsers[i] +"'" );
        }
      }
    //设为管理员
      else if(sAction.trim ().compareTo ("manager")==0)
      {
       for(i=0;i<length;i++)
       {
         DB.executeUpdate ( "update  person set mark=2 where username='"+ sUsers[i] +"'" );
        }
      }
    //设为超级用户
      else if(sAction.trim ().compareTo ("super")==0)
      {
        for(i=0;i<length;i++)
        {
          DB.executeUpdate ( "update  person set mark=1 where username='"+ sUsers[i] +"'" );
        }
      }
    }

    String sCondition="";
    int page=0;
    String sPage=request.getParameter ("page");
    if  ((sPage==null)||(sPage.trim ().length ()==0))
        page=0;
    else
    {
       try{
          page=Integer.valueOf (sPage).intValue ();
       }catch(Exception e){
          page=0;
       }
    }
    String condition=request.getParameter ("condition");
    String keyword=request.getParameter ("keyword");

    if ((condition==null)||(condition.trim ().length ()==0))
    {
         condition="";
         sCondition="";
    }
    if((keyword==null)||(keyword.trim ().length ()==0))
    {
        keyword="";
        sCondition="";
    }
    if((condition.trim ().length ()>0)&&(keyword.trim ().length ()>0))
    {
        sCondition+=" where ";
        sCondition+=condition;
        sCondition+=" like ";
        sCondition+="'%";
        sCondition+=keyword;
        sCondition+="%'";
        page=0;
    }
  //  System.out.println ("sCondition is"+sCondition);
    TemplateList tempList=CommonMethods.getUserManageTemplate ();
		SingleTemplate st,st1;
		st = tempList.searchTemplate ("ROOT");
    st1=tempList.searchTemplate ("用户");
		if(st==null)
		{
      htmlOut.setErrorID (htmlOut.SINGLE_TEMPLATE_NOTFIND ,"",
								"无法找到模板","/WebManage");
			htmlOut.outHtml();
			return ;

		}
    if(st1==null)
    {
      htmlOut.setErrorID (htmlOut.SINGLE_TEMPLATE_NOTFIND ,"","无法找到模板","/WebManage");
      htmlOut.outHtml ();
      return ;
    }
    //替换模板文件
		int nKey = st.getKeyNum ();
    int nKey1=st1.getKeyNum ();
    String sKey1 = new String();
		String sKey= new String ();
		for(int j=0;j<nKey;j++){
			htmlOut.addString (st.getStringAt (j));
			sKey = st.getKeyAt (j);
      if((sKey.compareTo ("查找结果")==0)&&(sCondition.trim ().length ()>0))
        htmlOut.addString ("查找结果：");
			if( sKey.compareTo("cgi-path")==0 )
				htmlOut.addString (CommonMethods.sHostNameCGI);
      if(sKey.compareTo ("人数")==0)
        htmlOut.addString (p.getSumUser (sCondition)+"名");
      if(sKey.compareTo ("上一页")==0&&page>0)
        htmlOut.addString ("上一页");
      if(sKey.compareTo ("下一页")==0&&page<(p.getSumUser (sCondition)/10))
        htmlOut.addString ("下一页");
      if(sKey.compareTo ("上页")==0)
        htmlOut.addString ("/UserAdmin?page="+(page-1));
      if (sKey.compareTo ("下页")==0)
        htmlOut.addString ("/UserAdmin?page="+(page+1));
      if(sKey.compareTo ("当前页")==0)
        htmlOut.addString ((page+1)+"");
      if(sKey.compareTo("页数")==0)
        htmlOut.addString (page+"");
      if(sKey.compareTo ("内容")==0)
      {
      DBOperater DB1=new DBOperater ("person");
      try{
        String QueryString;
        QueryString="select username,firstname,email,gender,mark,joindate from person";
        QueryString+=sCondition;
        ResultSet rs=DB1.executeQuery (QueryString);
        int n=0;
        if(rs!=null)
			  {
				  while(rs.next())
	   			 {
              n++;
              if ((n>(10*(page+1)))||(n>p.getSumUser (QueryString)))
                 break;
              if (n>(page*10)) {
              for(int k=0;k<nKey1;k++){
                  htmlOut.addString (st1.getStringAt (k));
                  sKey1=st1.getKeyAt (k);
                  if (sKey1.compareTo ("用户名称")==0)
                     htmlOut.addString (rs.getString (1));
                  if (sKey1.compareTo ("真实姓名")==0)
                     htmlOut.addString (rs.getString (2));
                  if(sKey1.compareTo ("EMail")==0)
                     htmlOut.addString (rs.getString (3));
                  if(sKey1.compareTo ("性别")==0)
                     htmlOut.addString (rs.getString (4));
                  if(sKey1.compareTo("页数")==0)
                     htmlOut.addString (page+"");
                  if(sKey1.compareTo ("用户级别")==0)
                  {
                     int power;
                     power =rs.getInt(5);
                     if(power==1)
                        htmlOut.addString ("超级用户");
                     else if(power==2)
                        htmlOut.addString ("管理员");
                     else
                        htmlOut.addString ("一般用户");
                  }
                  if(sKey1.compareTo ("入会时间")==0)
                     htmlOut.addString (rs.getString (6));
              }
              htmlOut.addString (st1.getEndString ());
					}
          }
			}
		}catch(Exception ex) {
      System.err.println("SQLException: " + ex.getMessage());
    }
      }

		}
		htmlOut.addString (st.getEndString());
		htmlOut.outHtml();

		return;
    }


    public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
		    doGet(request,response);
	}
}