insertpagetemplate.java

来自「JAVA邮件系统」· Java 代码 · 共 92 行

/* 
 *显示页面增加摸板
 */

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

public class InsertPageTemplate 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.getInsertWebPageTemplate  ();
			
	   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(); 
		}
		
}