pointratetemplate.java

JAVA邮件系统

/* 
 *
* 显示点击率统计摸板
 */

import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
/**
 * 
 * PointRateTemplate.java
 * @author Zhu Jian Min
 * 2000.8.23
 */

public class PointRateTemplate extends HttpServlet {


     public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
		doGet(request,response);
	}
	public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
      
	   HtmlOut htmlOut = new HtmlOut (response);
	

	
	
	   TemplateList tempList =CommonMethods.getPointRateTemplate ();
			
	   SingleTemplate st = tempList.searchTemplate ("ROOT");
	   if(st==null)
			htmlOut.setErrorID(htmlOut.CHANNEL_NOT_FIND,"","没找到点击率统计摸板","Login");
		
	   String queryString;	
 
		DBOperater DB = new DBOperater ("pointtype");
		
		try 
		{
			
		  int nKey = st.getKeyNum ();
		
		   String sKey ;
			
			for(int i=0;i<nKey;i++){
			 htmlOut.addString (st.getStringAt (i));
			  sKey = st.getKeyAt (i);
			  queryString = "select type from pointtype ";
			 ResultSet rs=DB.executeQuery(queryString);
			  if(rs!=null){
				while(rs.next())
				{
					String key=rs.getString(1);
					if (key!=null){
					 htmlOut.addString ("<option value="+key+">"+key.trim()+"</option>");
				     }
			     }
				rs.close();
			  }
			else{
				htmlOut.setErrorID(htmlOut.CHANNEL_NOT_FIND,"","数据库出错,rs为空","Login");
			    DB.close();
				}
			  }
	   	     htmlOut.addString(st.getEndString());
			
		} catch(Exception ex) {
				htmlOut.setErrorID(htmlOut.CHANNEL_NOT_FIND,"","数据库出错","Login");
			DB.close();
			
		}
		DB.close();
		//...
		htmlOut.outHtml(); 
		}
		
}