webpagemanagechannel.java

JAVA邮件系统

/**
 * 管理页面
 * 
 *WebPageManageChannel.java
 * @author Zhu Jian Min
 * 2000.8.24
 */
import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*;

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

public class WebPageManageChannel 
{	
		
	public void makeUserManage(Person p,TemplateList tempList,HtmlOut desHtml,
								  String type,String webpage)
	{
		SingleTemplate st,st2;
		String queryString="";
		String channelContent = "";
	   	st = tempList.searchTemplate("ROOT");
		if(st==null) {
			desHtml.setErrorID(desHtml.TEMPLATE_NOTFIND,"",
							   "未找到页面管理主模板","Login");
			return ;
		}
		TemplateList tempList2=CommonMethods.getWebPageShowTemplate();
		st2= tempList2.searchTemplate("ROOT");
		if(st2==null) {
			desHtml.setErrorID(desHtml.TEMPLATE_NOTFIND,"",
							   "未找到页面管理主模板之显示模板","Login");
			return ;
		}
		Person person = new Person ();
		
	
		if(type!=null) {
			if(type!=null)
		  type=type.trim();
		  
		 queryString+=" and  type='" + type + "' ";
		}
		String username=p.getName();
		//得到用户名称	
		if(type!=null)
		if(type.compareTo("全部")==0)
			queryString="";
		
		
		queryString="select * from pointrate where  ID>0"+queryString;
		String typeB[],webpageB[];
		int ID[],nPage=10000;
		ID=new int[nPage];
		typeB=new String[nPage];
		webpageB=new String[nPage];
		
		int j=1;
		ResultSet rs;		
		DBOperater DB = new DBOperater ("pointrate");
		try 
		{
		    rs = DB.executeQuery(queryString);
			if(rs!=null){
	   	    	
			if(!rs.next())
	   	    { // 记录已空
			 int Keysum = st.getKeyNum();//取得页面管理主模板的关键字个数
		       desHtml.addString ("没有要查询的页面信息");
		     for(int i=0;i<Keysum;i++) {
			  desHtml.addString (st.getStringAt (i));
			  String UsKey=st.getKeyAt(i);
			  if(UsKey.compareTo("type")==0)
						{
							 
		DBOperater DB2= new DBOperater ("pointrate");
		                try 
		                  {
			                   ResultSet rs1=DB2.executeQuery("select type from pointtype ");
			                     if(rs1!=null){
				                      while(rs1.next())
				                           {
					                          String key=rs1.getString(1);
					                             if (key!=null){
					                                 desHtml.addString ("<option value="+key+">"+key.trim()+"</option>");
				                                                }
			                                }
				                       rs1.close();
			                                   }
			
			
			 
		
			                   else{
				                    desHtml.setErrorID(desHtml.CHANNEL_NOT_FIND,"","数据库出错,rs为空","Login");
			                           DB2.close();
				                   }
			 
	   	    
			
		          } catch(Exception ex) {
				  desHtml.setErrorID(desHtml.CHANNEL_NOT_FIND,"","数据库出错","Login");
			         DB2.close();
			
		              }
		           DB2.close();
	               	}
			  
		      }
				desHtml.addString(st.getEndString());
				DB.close();
	   	    	return ;
	   	    }
			//将数据库中的数据逐条的取得放到相应的数组中
			do
			{
	   	    if (j>nPage-1) break;
			ID[j]=rs.getInt("ID");
			typeB[j]=rs.getString("type");
			webpageB[j]=rs.getString("webpage");
			j++;
			}while(rs.next());
		   DB.close();
			}else{
			DB.close();
			}
			
		}catch(Exception ex) {
			desHtml.setErrorID(desHtml.USER_ANSWER_IS_INCORRECT,
							   "","页面详细信息出错","UserManage");
			 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 (typeB[l]);							
						}
						if( s2Key.compareTo("页面")==0 )
						{
							desHtml.addString (webpageB[l]);							
						}
						
						if( s2Key.compareTo("ID")==0 ){
							
							desHtml.addString (""+ID[l]);
						}
					
								
						
					}
				}
				desHtml.addString(st2.getEndString());
			}
			if(sKey.compareTo("type")==0)
						{
							 
		DBOperater DB1= new DBOperater ("pointrate");
		                try 
		                  {
			                   ResultSet rs1=DB1.executeQuery("select type from pointtype ");
			                     if(rs1!=null){
				                      while(rs1.next())
				                           {
					                          String key=rs1.getString(1);
					                             if (key!=null){
					                                 desHtml.addString ("<option value="+key+">"+key.trim()+"</option>");
				                                                }
			                                }
				                       rs1.close();
			                                   }
			
			
			 
		
			                   else{
				                    desHtml.setErrorID(desHtml.CHANNEL_NOT_FIND,"","数据库出错,rs为空","Login");
			                           DB1.close();
				                   }
			 
	   	    
			
		          } catch(Exception ex) {
				  desHtml.setErrorID(desHtml.CHANNEL_NOT_FIND,"","数据库出错","Login");
			         DB1.close();
			
		              }
		           DB1.close();
	               	}
		}
		//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);
				      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");
			 DB.close();
			return ;
		}
		
	}
	
		
  
		
		
	
	public boolean checkWebPage(String webpage,String type,HtmlOut desHtml)
	{
		
		String queryString;
		ResultSet rs;
		
		DBOperater DB = new DBOperater ("pointrate");
		try 
		{
			queryString ="select * from pointrate where  webpage='"+webpage+"' and  type='" +type +"' ";						
			rs = DB.executeQuery(queryString);
			if(rs!=null){
	   	    	
			if(rs.next())
	   	    {// 此类型存在,这个类型中已经包含了此页面
				
				DB.close();
				return false;
				
			}
			else
			{//页面在类型中不存在
				DB.close();
				return true;
			}
			
			}
			else{
			desHtml.setErrorID(desHtml.TEMPLATE_NOTFIND,"",
							   "数据库出错,rs为空","WebPageManageChannel");
			DB.close();
			return false;
			}
		} catch(Exception ex) {
			desHtml.setErrorID(desHtml.TEMPLATE_NOTFIND,"",
							   "数据库出错","WebPageManageChannel");
			DB.close();
			return false;
		}
		
		
		
	}
	
	public boolean checkType(String type,HtmlOut desHtml)
	{
		
		String queryString;
		ResultSet rs;
		
		DBOperater DB = new DBOperater ("pointtype");
		try 
		{
	
			queryString = "select * from pointType where type='" +
				      type + "'";						
			rs = DB.executeQuery(queryString);
			if(rs!=null){
	   	    	
			if(rs.next())
	   	    {// 此类型存在
				DB.close();
				return false;
				
			}else{//此类型不存在
				DB.close();
				return true;
			}
	   	    
			}
			else
			{//rs=null
				desHtml.setErrorID(desHtml.TEMPLATE_NOTFIND,"",
							   "数据库出错","WebPageManageChannel");
				DB.close();
			    return false;
			}
		} catch(Exception ex) {
			desHtml.setErrorID(desHtml.TEMPLATE_NOTFIND,"",
							   "数据库出错","WebPageManageChannel");
			DB.close();
			return false;
							 
							  
		}
		
		
	}
	public int  GetWebPageID(){
		
		String queryString;
		
		ResultSet rs;
		int ID;
		DBOperater DB = new DBOperater ("pointrate");
		try 
		{
			
			
	   	    rs=DB.executeQuery("Select ID From pointrate order by Id Desc ");
			if(rs!=null){
			if (rs.next()){
	    	ID=rs.getInt("ID");
			 DB.close();
			return ID+1;
			}
			else{
			 return 1;//如果数据库为空
			}
	   	  
			}else{
				DB.close();
				return -1;}
		} catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return -1;
		}//查找ID出错返回 -1;
	}
	public boolean insertWebPagedata(String Query)
	{
		    DBOperater DB = new DBOperater ("pointrate");
			try{
	   	     DB.executeUpdate (Query);      	
			}catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return false;
		}
			 DB.close();
		 //用户不存在返回true
		return true;
	}
}