usermanagechannel.java

JAVA邮件系统

/**
 * 替换用户管理模板
 * 
 *UserManageChannel.java
 * @author Zhu Jian Min
 * 2000.8.1
 */
import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*;

/**
 * 
 *
 * @author Zhu Jian Min
 */

public class UserManageChannel 
{	
		
	public void makeUserManage(Person p,TemplateList tempList,HtmlOut desHtml,
								  String condition,String keyword)
	{
		SingleTemplate st,st2;
		String queryString="";
		String channelContent = "";
	
		st = tempList.searchTemplate("ROOT");
		if(st==null) {
			desHtml.setErrorID(desHtml.TEMPLATE_NOTFIND,"",
							   "未找到用户管理主模板","Login");
			return ;
		}
		TemplateList tempList2=CommonMethods.getUserShowTemplate();
		st2= tempList2.searchTemplate("ROOT");
		if(st2==null) {
			desHtml.setErrorID(desHtml.TEMPLATE_NOTFIND,"",
							   "未找到用户管理主模板之显示模板","Login");
			return ;
		}
		Person person = new Person ();
		//条件查询的条件 condition=条件 keyword=关键字,得到查询的字符串
		if(condition!=null&&keyword!="") {
		  if(condition!=null)
		  condition=condition.trim();
		 
		  if(keyword!=null)
		  keyword.trim();
		 queryString+="where " +condition + " like '" + keyword + "%'";
		}
		String username=p.getName();
		//得到用户名称	
		queryString="select username,firstname,email,gender,education,jobfunction,state,phone,BP,city,address,ID,mark,joinDate from person "
					+queryString;
		String name[],firstname[],eMail[],gender[],education[],jobfunction[],state[],phone[],BP[],sCity[],address[],joinDate[];
    int mark[];
		int ID[],nPage=150;
		ID=new int[nPage];
		name=new String[nPage];
		firstname=new String[nPage];
		eMail=new String[nPage];
		gender=new String[nPage];
		education=new String[nPage];
		jobfunction=new String[nPage];
		state=new String[nPage];
		phone=new String[nPage];
		BP=new String[nPage];
		sCity=new String[nPage];
		address=new String[nPage];
		joinDate=new String[nPage];
    mark = new int[nPage];
		int j=1;
		ResultSet rs;		
		DBOperater DB = new DBOperater ("person");
		try 
		{
		    rs = DB.executeQuery(queryString);
			//将数据库中的数据逐条的取得放到相应的数组中
			if(rs!=null){
				while(rs!=null&&rs.next())
				{
	   				if (j>nPage-1)
						break;
					name[j]=rs.getString(1);
					firstname[j]=rs.getString(2);
					eMail[j]=rs.getString(3);
					gender[j]=rs.getString(4);
					education[j]=rs.getString(5);
					jobfunction[j]=rs.getString(6);
					state[j]=rs.getString(7);
					phone[j]=rs.getString(8);
					BP[j]=rs.getString(9);
					sCity[j]=rs.getString(10);
					address[j]=rs.getString(11);
					ID[j]=rs.getInt(12);
					joinDate[j]=rs.getString(14);
          mark[j]=rs.getInt (13);
					j++;
				};
				DB.close();
			}else{
				DB.close();
			}

		}catch(Exception ex) {
			desHtml.setErrorID(desHtml.USER_ANSWER_IS_INCORRECT,
							   "","用户详细信息出错","UserManage");
			System.out.println ( "用户详细信息出错"+ex.toString()  );
			DB.close();
			return ;
		}

		int nKey = st.getKeyNum();//取得用户管理主模板的关键字个数
		int n2Key = st2.getKeyNum();//取得用户管理显示模板的关键字个数
		String sKey,s2Key;
		for(int i=0;i<nKey;i++) {
			desHtml.addString (st.getStringAt (i));
			sKey = st.getKeyAt (i);
			if( sKey .compareTo("cgi-path")==0 )
				desHtml.addString (CommonMethods.sHostNameCGI);
			if( sKey.compareTo("内容")==0 )
			{
				for(int l=1;l<j;l++) {
					for(int k=0;k<n2Key;k++) {
						desHtml.addString (st2.getStringAt (k));
						s2Key = st2.getKeyAt (k);

						if( s2Key .compareTo("cgi-path")==0 )
							desHtml.addString (CommonMethods.sHostNameCGI);

						if( s2Key.compareTo("用户名称")==0 )
						{
							desHtml.addString (name[l]);
						}
						if( s2Key.compareTo("真实姓名")==0 )
						{
							desHtml.addString (firstname[l]);
						}
						if( s2Key.compareTo("EMail")==0 )
							desHtml.addString (eMail[l]);
						if( s2Key.compareTo("性别")==0 )
						{
							desHtml.addString (gender[l]);
						}
						if( s2Key.compareTo("教育程度")==0 )
						{
							desHtml.addString (education[l]);
						}
						if( s2Key.compareTo("工作性质")==0 )
						{
							desHtml.addString (jobfunction[l]);
						}
						if( s2Key.compareTo("省份")==0 )
						{
							desHtml.addString (state[l]);
						}
						if( s2Key.compareTo("电话")==0 ){

							desHtml.addString (phone[l]);
						}
						if( s2Key.compareTo("寻呼机")==0 ){

							desHtml.addString (BP[l]);
						}
						if( s2Key.compareTo("城市")==0 ){

							desHtml.addString (sCity[l]);
						}
						if( s2Key.compareTo("地址")==0 ){

							desHtml.addString (address[l]);
						}
						if( s2Key.compareTo("ID")==0 ){

							desHtml.addString (""+ID[l]);
						}
						if( s2Key.compareTo("入会时间")==0 ){

							desHtml.addString (joinDate[l]);
						}
            if(s2Key.compareTo ("用户级别")==0)   {
              if (mark[l] == 1)
                desHtml.addString ("超级用户");
              else if (mark[l]==2)
                desHtml.addString ("管理员");
              else
                desHtml.addString ("一般用户");
            }
					}
					desHtml.addString (st2.getEndString() );
				}
			}
		}
		//desHtml.addString("这是第几页");
		desHtml.addString(st.getEndString());
		return;
	}

	public void makeUserInfo(Person p,TemplateList tempList,HtmlOut desHtml,int nID)
	{
		SingleTemplate st;
		st = tempList.searchTemplate("ROOT");
		if(st==null) {
			return ;
		}

		String queryString;
		ResultSet rs;
		String ques="";
	    DBOperater DB = new DBOperater ("person");
		try
		{

			queryString = "select * from person where ID='"+nID+"'";

	        rs = DB.executeQuery (queryString);
			if(rs!=null){
				while(rs.next())
				{
					int nKey = st.getKeyNum ();
		            String sKey ;

				for(int i=0;i<nKey;i++){

			       desHtml.addString (st.getStringAt (i));
			       sKey = st.getKeyAt(i);
					if( sKey .compareTo("cgi-path")==0 )
						desHtml.addString (CommonMethods.sHostNameCGI);
					else{
						String key=rs.getString(sKey);
						if (key!=null){
							desHtml.addString (key.trim());//将模板中有TeleContents的替换为数据库中的数据
						}
					}

				}
				desHtml.addString(st.getEndString());

				}

			DB.close();
			}else{
				DB.close();
				return ;
			}
		} catch(Exception ex) {
			desHtml.setErrorID(desHtml.USER_ANSWER_IS_INCORRECT,
							   "","用户详细信息出错","UserManage");
			System.out.println ( "用户详细信息出错"+ex.toString()  );
			DB.close();
			return ;
		}

	}

}