insertwebpage.java

JAVA邮件系统

/* 
 *
 *将用户输入的页面类型和页面加到数据库中
 */

import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 * 
 * @InsertWebPage
 * @author Zhu Jian Min
 * 2000.8.25
 */

public class InsertWebPage extends HttpServlet {


    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
      
 		HtmlOut htmlOut = new HtmlOut (response);
      
	
		
	String type,webpage,pointtype;
	int ID;
    type = request.getParameter("type");
	type=CommonMethods.DealWithGBCodeOfRequest(type);
	if(type!=null)
		type=type.trim();
	webpage=request.getParameter("webpage");
	webpage=CommonMethods.DealWithGBCodeOfRequest(webpage);
	pointtype=request.getParameter("pointtype");
	pointtype=CommonMethods.DealWithGBCodeOfRequest(pointtype);
	if(pointtype!=null){
		pointtype=pointtype.trim();
	}
	if(webpage!=null){
		webpage=webpage.trim();
	}
	WebPageManageChannel wpmChannel=new WebPageManageChannel();
	ID=wpmChannel.GetWebPageID();
	if(pointtype.compareTo("")!=0&&pointtype!=null){
		
		if(!wpmChannel.checkType(pointtype,htmlOut)){
		      htmlOut.setErrorID(htmlOut.USER_HAS_BEEN_EXISTED ,"","此页面类型已经存在",
		       "InsertPageTemplate");
		         
		}
	    else
	       {
		//设置sql 语句
		    String Query="insert pointType(type) values('" +pointtype+ "')";
		    //将数据插入到数据库中
	      
		    if(!wpmChannel.insertWebPagedata(Query))
		    {
			 	htmlOut.setErrorID(htmlOut.USER_HAS_SUCCEEDED_TO_CHANGE_HIS_INFOMATION,
							   "","数据库插入时出错","InsertPageTemplate");
		    }
	    	 else
		   {
			
			htmlOut.setErrorID(htmlOut.USER_HAS_SUCCEEDED_TO_CHANGE_HIS_INFOMATION,
							   "","您已经成功的加入了该页面类型","InsertPageTemplate");
			
			
								
		   }
	     }
	
	    }
	
	
	
	
	 else{
		
	      if(!wpmChannel.checkWebPage(webpage,type,htmlOut))
    	{
		htmlOut.setErrorID(htmlOut.USER_HAS_BEEN_EXISTED ,"","此页面已经存在",
		"InsertPageTemplate");
		
        	
	     }
	   else
	   {
		//设置sql 语句
		
		 String Query="insert pointrate values('"+ID+"','" +type+ "','"+webpage+"')";
		 //将数据插入到数据库中
	
		 if(!wpmChannel.insertWebPagedata(Query))
		 {
			 	htmlOut.setErrorID(htmlOut.USER_HAS_SUCCEEDED_TO_CHANGE_HIS_INFOMATION,
							   "","数据库插入时出错","WebPageManage");
		 }
		 else
		 {
			
			htmlOut.setErrorID(htmlOut.USER_HAS_SUCCEEDED_TO_CHANGE_HIS_INFOMATION,
							   "","您已经成功的加入了该页面","InsertPageTemplate");
			
								
		 }
	}
	}
	htmlOut.outHtml();		
	
     }
}