changeinfochannel.java

JAVA邮件系统

/**
 * 
 * 替换用户更改信息模板
 * @author Zhu Jian Min
 */
import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*;
/**
 * 
 * 
 * @author Zhu Jian Min
 */
public class ChangeInfoChannel 
{
	
	public void makeChannel(Person p,TemplateList tempList,HtmlOuter desHtml)
	{
		return ;
	}
	public void MakeChangeInfoTemplate(Person p,TemplateList tempList,HtmlOut desHtml)
	{
	
		SingleTemplate st = tempList.searchTemplate ("ROOT");
		if(st==null)
			return;
		
		//get user info;
		String name=p.username ;
			//取得用户输入的密码提示问题
		String queryString;	
		ResultSet rs;
		String ques="";
	    DBOperater DB = new DBOperater ("person");
		try 
		{
			
			queryString = "select * from person where username='"+name+"'";		
	   	      	    	
	        rs = DB.executeQuery (queryString);
			if(rs!=null){
				if(rs.next())
				{
					int nKey = st.getKeyNum ();
		            String sKey ;
		           
					for(int i=0;i<nKey;i++){
					  
						desHtml.addString (st.getStringAt (i));
						sKey = st.getKeyAt (i);
						System.out.println ("sKey:"+sKey);
						if( sKey!=null&&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());
			    
			  }
	   	    
		  }
		  else{
		    DB.close();
		    return;
		  }
			
		} catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return ;
		}
		DB.close();
		//...
		}
}