myszchannel.java

JAVA邮件系统

import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*;

/*
 * 
 *
 * @author zhukejun
 */

public class MyszChannel 
{
	public void MakeSzInfo( Person p,TemplateList tempList,HtmlOut servlet,int pagenum )
	{
		
	   SingleTemplate st = tempList.searchTemplate("ROOT");
	   if(st==null)
	   {
		   servlet.setErrorID (servlet.SINGLE_TEMPLATE_NOTFIND,"",
							   "MySz.html is not find","Login");
		   servlet.outHtml ();
			return;		
	   }
	   boolean bool=false;
	   String username,selected="",unselect="",queryString,pagestring;
	   int i,j=0,k=0,selectcount,allcount,unselectcount,selectpagecount;
	   username=p.username; 
		//get user channel to String[] userchannel;
		String userchannel[][];
		userchannel=new String[100][3];
			
		DBOperater DB = new DBOperater ("userchannel");
			
		queryString ="select channelname,a.channelid,a.type from channel a,userchannel b where b.username='"+CommonMethods.DealWithSQLParameter(username)+"' and b.channelid=a.channelid";				
		ResultSet rs = DB.executeQuery (queryString);
		i=0;
		if(rs!=null){
			try{
					while(rs.next())
					{   
						userchannel[i][0] = rs.getString(1).trim();	
						userchannel[i][1] = rs.getString(2).trim();
						if(rs.getString(3).trim().compareTo ("1")==0)
							userchannel[i][2] ="窄";
						else
							userchannel[i][2] ="宽";
						i=i+1;
				
					}
				}catch(Exception e){
						 }
		}
		selectcount=i;
					   		       		   
			
		
		//get unselect channel to String[] unselectchannel;
		
		String allchannel[][];
		String unselectchannel[][];
		allchannel=new String[100][3];
		unselectchannel=new String[100][3];
		
			queryString ="select channelname,channelid,type from channel";				
	   	    rs = DB.executeQuery (queryString);
			i=0;
			if(rs!=null){
				try{
					
					while(rs.next())
						{   
							allchannel[i][0] = rs.getString(1).trim();	
							allchannel[i][1] = rs.getString(2).trim();
							if(rs.getString(3).trim().compareTo ("1")==0)
							allchannel[i][2] ="窄";
						else
							allchannel[i][2] ="宽";
							i=i+1;
						}
					}catch(Exception er){
				   }
			}
			allcount=i;
			
		
			unselectcount=allcount-selectcount;
			/*i=0;
			while(i<allcount)
			{
				for(j=0;j<selectcount;j++)
				{
						
					if(userchannel[j][1].compareTo(allchannel[i][1])==0)
					{
						allchannel[i][0]=allchannel[allcount-1][0];
						allchannel[i][1]=allchannel[allcount-1][1];
						allcount=allcount-1;
						i=0;
						bool=true;
					}
				}
				if(bool!=true)
				i=i+1;
				bool=false;
			}*/
			k=0;
			for(i=0;i<allcount;i++)
			{
				for(j=0;j<selectcount;j++)
				{
						
					if(userchannel[j][1].compareTo(allchannel[i][1])==0)
					{
						bool=true;
						break;
					}
				}
				if(bool==false)
				{
					unselectchannel[k][0]=allchannel[i][0];
					unselectchannel[k][1]=allchannel[i][1];
					unselectchannel[k][2]=allchannel[i][2];
					k=k+1;
				}
				bool=false;
			
			}
			
			//unselectchannel=allchannel;
			
					   		       		   
		//get user pagechannel to String[] userpagechannel;
		String userpagechannel[][];
		userpagechannel=new String[100][3];
		
			queryString ="select channelname,a.channelid,a.type from channel a,userchannel b where b.username='"+CommonMethods.DealWithSQLParameter(username)+"' and b.pagenumber="+pagenum+" and b.channelid=a.channelid";				
				
			rs = DB.executeQuery (queryString);
			i=0;
			if(rs!=null){
				try{
						while(rs.next())
						{   
							userpagechannel[i][0] = rs.getString(1).trim();	
							userpagechannel[i][1] = rs.getString(2).trim();
							if(rs.getString(3).trim().compareTo ("1")==0)
								userpagechannel[i][2] ="窄";
							else
								userpagechannel[i][2] ="宽";
							i=i+1;
				
						}
				}catch(Exception e){
				  }
			}
			selectpagecount=i;
	    DB.close ();
		//...替换关键字
		
		int nKey = st.getKeyNum ();
		for(i=0;i<nKey;i++){
			servlet.addString (st.getStringAt (i));
			String sKey = st.getKeyAt (i);
			if( sKey .compareTo("cgi-path")==0 )
				servlet.addString (CommonMethods.sHostNameCGI);
			if(sKey.compareTo ("pagenumber")==0){
			
				
					pagestring="<INPUT name=p type=hidden value="+pagenum+">";
				
				servlet.addString(pagestring);
		
			}		
			if(sKey.compareTo ("当前页")==0){
				pagestring=""+pagenum+"";
				servlet.addString(pagestring);
		
			}	
			
			if(sKey.compareTo ("unselect")==0){
			
				for(j=0;j<unselectcount;j++)
				{
					unselect=unselect+"<option value="+unselectchannel[j][1]+">"+unselectchannel[j][0]+"("+unselectchannel[j][2]+")"+"</option>";
				}
				servlet.addString(unselect);
		
			}			
			if(sKey.compareTo ("selected")==0){
				for(j=0;j<selectpagecount;j++)
				{
					
					selected=selected+"<option value="+userpagechannel[j][1]+">"+userpagechannel[j][0]+"("+userpagechannel[j][2]+")"+"</option>";
				}
				servlet.addString(selected);
			}			
		}
		servlet.addString (st.getEndString () );
		
	}

}