writexmlservlet.java

利用jxl和jdom到报表用的,可以自定义excel模板

            		String forwardPage = "firstSetupCellPlace.jsp?formName="+hiddenFormName;
            		//下面开始写入xml文件
            		XmlUtils.addToXml(xmlPath,"cell","place",place,"description",description,"field",field);
        			errorMessage = "位置【"+place+"】描述【"+description+"】对应的字段名【"+field+"】这一条记录添加成功！";
            		request.setAttribute("errorMessage", errorMessage);
            		request.getRequestDispatcher(forwardPage).forward(request,response); 
    			}else{
    				String errorMessage = "";
            		String forwardPage = "firstSetupCellPlace.jsp?formName="+hiddenFormName;
            		//下面开始写入xml文件
            		XmlUtils.createToXml(xmlPath,"cell","place",place,"description",description,"field",field);
        			errorMessage = "【"+hiddenFormName+".xml】的xml文件生成成功！";
            		request.setAttribute("errorMessage", errorMessage);
            		request.getRequestDispatcher(forwardPage).forward(request,response); 
    			}
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/firstSetupToXmlEdit")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String only = request.getParameter("only");
    			String i = request.getParameter("id");
    			String place = request.getParameter("placeEdit"+i);
    			String description = request.getParameter("descriptionEdit"+i);
    			String descriptionBase = request.getParameter("descriptionEditBase"+i);
    			String field = request.getParameter("fieldEdit"+i);
    			String fieldBase = request.getParameter("fieldEditBase"+i);
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			String errorMessage = "";
            	String forwardPage = "firstSetupCellPlace.jsp?formName="+hiddenFormName;
            	//下面开始修改xml文件
            	XmlUtils.editToXml(xmlPath, "cell", only, "place", place, "description", description, "field", field);
        		errorMessage = "位置【"+only+"】描述【"+descriptionBase+"】对应的字段名【"+fieldBase+"】修改后为位置【"+place+"】描述【"+description+"】对应的字段名【"+field+"】！";
            	request.setAttribute("errorMessage", errorMessage);
            	request.getRequestDispatcher(forwardPage).forward(request,response); 
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/firstSetupToXmlDelete")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String only = request.getParameter("only");
    			String i = request.getParameter("id");
    			String descriptionBase = request.getParameter("descriptionEditBase"+i);
    			String fieldBase = request.getParameter("fieldEditBase"+i);
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			String errorMessage = "";
            	String forwardPage = "firstSetupCellPlace.jsp?formName="+hiddenFormName;
            	//下面开始删除xml文件中的一条记录
            	XmlUtils.removeOneNodeName(xmlPath, "cell", "place", only);
        		errorMessage = "位置【"+only+"】描述【"+descriptionBase+"】对应的字段名【"+fieldBase+"】这条记录删除成功！";
            	request.setAttribute("errorMessage", errorMessage);
            	request.getRequestDispatcher(forwardPage).forward(request,response); 
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/setupToXmlAdd")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String place = request.getParameter("placeAdd");
    			String description = request.getParameter("descriptionAdd");
    			String field = request.getParameter("fieldAdd");
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			boolean flag = XmlUtils.fileIsExits(xmlPath);
    			if(flag){
    				String errorMessage = "";
            		String forwardPage = "setupCellPlace.jsp?formName="+hiddenFormName;
            		//下面开始写入xml文件
            		XmlUtils.addToXml(xmlPath,"cell","place",place,"description",description,"field",field);
        			errorMessage = "位置【"+place+"】描述【"+description+"】对应的字段名【"+field+"】这一条记录添加成功！";
            		request.setAttribute("errorMessage", errorMessage);
            		request.getRequestDispatcher(forwardPage).forward(request,response); 
    			}else{
    				String errorMessage = "";
            		String forwardPage = "setupCellPlace.jsp?formName="+hiddenFormName;
            		//下面开始写入xml文件
            		XmlUtils.createToXml(xmlPath,"cell","place",place,"description",description,"field",field);
        			errorMessage = "【"+hiddenFormName+".xml】的xml文件生成成功！";
            		request.setAttribute("errorMessage", errorMessage);
            		request.getRequestDispatcher(forwardPage).forward(request,response); 
    			}
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/setupToXmlEdit")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String only = request.getParameter("only");
    			String i = request.getParameter("id");
    			String place = request.getParameter("placeEdit"+i);
    			String description = request.getParameter("descriptionEdit"+i);
    			String descriptionBase = request.getParameter("descriptionEditBase"+i);
    			String field = request.getParameter("fieldEdit"+i);
    			String fieldBase = request.getParameter("fieldEditBase"+i);
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			String errorMessage = "";
            	String forwardPage = "setupCellPlace.jsp?formName="+hiddenFormName;
            	//下面开始修改xml文件
            	XmlUtils.editToXml(xmlPath, "cell", only, "place", place, "description", description, "field", field);
        		errorMessage = "位置【"+only+"】描述【"+descriptionBase+"】对应的字段名【"+fieldBase+"】修改后为位置【"+place+"】描述【"+description+"】对应的字段名【"+field+"】！";
            	request.setAttribute("errorMessage", errorMessage);
            	request.getRequestDispatcher(forwardPage).forward(request,response); 
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/setupToXmlDelete")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String only = request.getParameter("only");
    			String i = request.getParameter("id");
    			String descriptionBase = request.getParameter("descriptionEditBase"+i);
    			String fieldBase = request.getParameter("fieldEditBase"+i);
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			String errorMessage = "";
            	String forwardPage = "setupCellPlace.jsp?formName="+hiddenFormName;
            	//下面开始删除xml文件中的一条记录
            	XmlUtils.removeOneNodeName(xmlPath, "cell", "place", only);
        		errorMessage = "位置【"+only+"】描述【"+descriptionBase+"】对应的字段名【"+fieldBase+"】这条记录删除成功！";
            	request.setAttribute("errorMessage", errorMessage);
            	request.getRequestDispatcher(forwardPage).forward(request,response); 
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/submitToXmlAdd")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String place = request.getParameter("placeAdd");
    			String description = request.getParameter("descriptionAdd");
    			String field = request.getParameter("fieldAdd");
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			boolean flag = XmlUtils.fileIsExits(xmlPath);
    			if(flag){
    				String errorMessage = "";
            		String forwardPage = "submitCellPlace.jsp?formName="+hiddenFormName;
            		//下面开始写入xml文件
            		XmlUtils.addToXml(xmlPath,"cell","place",place,"description",description,"field",field);
        			errorMessage = "位置【"+place+"】描述【"+description+"】对应的字段名【"+field+"】这一条记录添加成功！";
            		request.setAttribute("errorMessage", errorMessage);
            		request.getRequestDispatcher(forwardPage).forward(request,response); 
    			}else{
    				String errorMessage = "";
            		String forwardPage = "submitCellPlace.jsp?formName="+hiddenFormName;
            		//下面开始写入xml文件
            		XmlUtils.createToXml(xmlPath,"cell","place",place,"description",description,"field",field);
        			errorMessage = "【"+hiddenFormName+".xml】的xml文件生成成功！";
            		request.setAttribute("errorMessage", errorMessage);
            		request.getRequestDispatcher(forwardPage).forward(request,response); 
    			}
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/submitToXmlEdit")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String only = request.getParameter("only");
    			String i = request.getParameter("id");
    			String place = request.getParameter("placeEdit"+i);
    			String description = request.getParameter("descriptionEdit"+i);
    			String descriptionBase = request.getParameter("descriptionEditBase"+i);
    			String field = request.getParameter("fieldEdit"+i);
    			String fieldBase = request.getParameter("fieldEditBase"+i);
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			String errorMessage = "";
            	String forwardPage = "submitCellPlace.jsp?formName="+hiddenFormName;
            	//下面开始修改xml文件
            	XmlUtils.editToXml(xmlPath, "cell", only, "place", place, "description", description, "field", field);
        		errorMessage = "位置【"+only+"】描述【"+descriptionBase+"】对应的字段名【"+fieldBase+"】修改后为位置【"+place+"】描述【"+description+"】对应的字段名【"+field+"】！";
            	request.setAttribute("errorMessage", errorMessage);
            	request.getRequestDispatcher(forwardPage).forward(request,response); 
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/submitToXmlDelete")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String only = request.getParameter("only");
    			String i = request.getParameter("id");
    			String descriptionBase = request.getParameter("descriptionEditBase"+i);
    			String fieldBase = request.getParameter("fieldEditBase"+i);
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			String errorMessage = "";
            	String forwardPage = "submitCellPlace.jsp?formName="+hiddenFormName;
            	//下面开始删除xml文件中的一条记录
            	XmlUtils.removeOneNodeName(xmlPath, "cell", "place", only);
        		errorMessage = "位置【"+only+"】描述【"+descriptionBase+"】对应的字段名【"+fieldBase+"】这条记录删除成功！";
            	request.setAttribute("errorMessage", errorMessage);
            	request.getRequestDispatcher(forwardPage).forward(request,response); 
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    }
    
    public void doPost(HttpServletRequest request, HttpServletResponse response) 
    					throws ServletException, IOException
    {
        doGet(request,response);
    }
}