forgetuserchannel.java

JAVA邮件系统

/**
 * 
 *
 *替换密码提示问题模板
 */
import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*;
/**
 * 
 *	ForgetUserChannel.java
 * @author Zhu Jian Min
 * 2000.7.21
 */
public class ForgetUserChannel 
{

	
	public void makeChannel(Person p,TemplateList tempList,HtmlOut desHtml)
	{
		return ;
	}
	public void MakeQuestionTemplate(Person p,TemplateList tempList,HtmlOut desHtml)
	{
	
		SingleTemplate st = tempList.searchTemplate ("ROOT");
		if(st==null){
			desHtml.setErrorID(desHtml.TEMPLATE_NOTFIND,"",
							   "用户密码提示模板没发现","ForgetUser");	
			return;
		}
		
		//get user info;
		String name=p.username ;
		//取得用户输入的密码提示问题
		
		String queryString;		
		ResultSet rs;
		String ques="";
		DBOperater DB = new DBOperater ("person");
		try 
		{
			queryString = "select username,question from person where username='"+name+"'";
			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());
						}			
					 }
			}
			desHtml.addString(st.getEndString());
				}
			}else 
			{
				DB.close();
				return;}
			
		} catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return ;
		}
		DB.close();
		//...
		
		}

}