writexmlservlet.java

来自「利用jxl和jdom到报表用的,可以自定义excel模板」· Java 代码 · 共 437 行 · 第 1/2 页

JAVA
437 行
字号
12
            		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);
    }
}
12

writexmlservlet.java - 源码说明

本页面展示了「利用jxl和jdom到报表用的,可以自定义excel模板」中的 writexmlservlet.java 源码文件，采用 Java 编程语言编写，共 437 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与JXL相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?