writexmlservlet.java

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

package com.glf.reportIE.servlet;

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

import org.jdom.Document;
import org.jdom.Element;
import org.jdom.output.Format;
import org.jdom.output.XMLOutputter;

import com.glf.reportIE.commons.*;



public class WriteXmlServlet extends HttpServlet 
{
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest request, 
    			HttpServletResponse response)
    		throws ServletException, IOException
    {
    	response.setContentType("text/html;charset=UTF-8");	
		//PrintWriter out = response.getWriter();
    	//HttpSession session=request.getSession();
    	String screen=request.getServletPath();
		
    	if(screen.equals("/pages/reportIE/formNameAdd")){
    		try{
    			String id = request.getParameter("formId");
    			String name = request.getParameter("formName");
    			String nameEn = request.getParameter("formNameEn");
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/model/excelFormName.xml";
    			boolean flag = XmlUtils.fileIsExits(xmlPath);
    			if(flag){
    				String errorMessage = "";
            		String forwardPage = "addFormName.jsp";
            		//下面开始追加并写入xml文件
            		XmlUtils.addToXml(xmlPath,"formName","id",id,"name",name,"nameEn",nameEn);
        			errorMessage = "报表【"+nameEn+"】【"+name+"】这一条记录添加成功！";
            		request.setAttribute("errorMessage", errorMessage);
            		request.getRequestDispatcher(forwardPage).forward(request,response); 
    			}else{
    				String errorMessage = "";
    				String forwardPage = "addFormName.jsp";
            		//下面开始创建并写入xml文件
            		XmlUtils.createToXml(xmlPath,"formName","id",id,"name",name,"nameEn",nameEn);
        			errorMessage = "【excelFormName.xml】的xml文件生成成功！";
            		request.setAttribute("errorMessage", errorMessage);
            		request.getRequestDispatcher(forwardPage).forward(request,response); 
    			}
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/formNameEdit")){
    		try{
    			String only = request.getParameter("only");
    			String i = request.getParameter("id");
    			String name = request.getParameter("formName"+i);
    			String nameBase = request.getParameter("formNameBase"+i);
    			String nameEn = request.getParameter("formNameEn"+i);
    			String nameEnBase = request.getParameter("formNameEnBase"+i);
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/model/excelFormName.xml";
    			String errorMessage = "";
    			String forwardPage = "addFormName.jsp";
            	//下面开始修改xml文件
            	XmlUtils.editToXml(xmlPath,"formName",only,"id",only,"name",name,"nameEn",nameEn);
        		errorMessage = "报表"+i+"【"+nameBase+"】【"+nameEnBase+"】修改后为【"+name+"】【"+nameEn+"】！";
            	request.setAttribute("errorMessage", errorMessage);
            	request.getRequestDispatcher(forwardPage).forward(request,response); 
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/formNameDelete")){
    		try{
    			String only = request.getParameter("only");
    			String i = request.getParameter("id");
    			String nameBase = request.getParameter("formNameBase"+i);
    			String nameEnBase = request.getParameter("formNameEnBase"+i);
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/model/excelFormName.xml";
    			String errorMessage = "";
    			String forwardPage = "addFormName.jsp";
            	//下面开始删除xml文件中的一条记录
            	XmlUtils.removeOneNodeName(xmlPath, "formName", "id", only);
        		errorMessage = "报表"+i+"【"+nameBase+"】【"+nameEnBase+"】这条记录删除成功！";
            	request.setAttribute("errorMessage", errorMessage);
            	request.getRequestDispatcher(forwardPage).forward(request,response); 
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
//    	if(screen.equals("/pages/reportIE/bindClassToXml")){
//    		try{
//    			String errorMessage = "";
//        		String forwardPage = "bindClass.jsp";
//        		String formName = request.getParameter("formName");
//        		String className = request.getParameter("className");
//        		String methodName = request.getParameter("methodName");
//        		//下面开始写入xml文件
//        		String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+formName+".xml";
//        		boolean flag = XmlUtils.fileIsExits(xmlPath);
//        		boolean flag2 = XmlUtils.fieldIsExits(xmlPath, "bindClass", "formName");
//    			if(flag){
//    				if(flag2){
//    					XmlUtils.removeSameNodeName(xmlPath, "bindClass");
//    					XmlUtils.addToXml(xmlPath,"bindClass","formName",formName,"className",className,"methodName",methodName);
//    					errorMessage = "【"+formName+"】【java类所在包的位置】修改为【"+className+"】【报表所需java类的方法名】修改为【"+methodName+"】！";
//                		request.setAttribute("errorMessage", errorMessage);
//                		request.getRequestDispatcher(forwardPage).forward(request,response);
//    				}else{
//    					XmlUtils.addToXml(xmlPath,"bindClass","formName",formName,"className",className,"methodName",methodName);
//                		errorMessage = "【"+formName+"】【java类所在包的位置】-【"+className+"】【报表所需java类的方法名】-【"+methodName+"】添加成功！";
//                		request.setAttribute("errorMessage", errorMessage);
//                		request.getRequestDispatcher(forwardPage).forward(request,response);
//    				}
//    			}else{
//            		//下面开始写入xml文件
//            		XmlUtils.createToXml(xmlPath,"bindClass","formName",formName,"className",className,"methodName",methodName);
//            		errorMessage = "【"+formName+".xml】的xml文件生成成功！";
//            		request.setAttribute("errorMessage", errorMessage);
//            		request.getRequestDispatcher(forwardPage).forward(request,response);
//    			}  			
//    		}catch(Exception e){
//    			e.printStackTrace();
//    		}	
//    	}
    	
    	if(screen.equals("/pages/reportIE/bindClassAdd")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String formName = request.getParameter("formName");
    			String formNameCn = request.getParameter("formNameCn");
    			String className = request.getParameter("className");
    			String methodName = request.getParameter("methodName");
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			boolean flag = XmlUtils.fileIsExits(xmlPath);
    			if(flag){
    				String errorMessage = "";
            		String forwardPage = "bindClass.jsp?formName="+hiddenFormName;
            		//下面开始写入xml文件
            		XmlUtils.addToXml(xmlPath,"bindClass","formName",formName,"className",className,"methodName",methodName);
        			errorMessage = "报表【"+formNameCn+"】绑定的类名【"+className+"】方法名【"+methodName+"】这一条记录添加成功！";
            		request.setAttribute("errorMessage", errorMessage);
            		request.getRequestDispatcher(forwardPage).forward(request,response); 
    			}else{
    				String errorMessage = "";
            		String forwardPage = "bindClass.jsp?formName="+hiddenFormName;
            		//下面开始写入xml文件
            		XmlUtils.createToXml(xmlPath,"bindClass","formName",formName,"className",className,"methodName",methodName);
        			errorMessage = "报表【"+formNameCn+"】的xml文件生成成功！";
            		request.setAttribute("errorMessage", errorMessage);
            		request.getRequestDispatcher(forwardPage).forward(request,response); 
    			}
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/bindClassEdit")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String only = request.getParameter("only");
    			String i = request.getParameter("id");
    			String formNameCn = request.getParameter("formNameCn"+i);
    			String className = request.getParameter("className"+i);
    			String classNameBase = request.getParameter("classNameBase"+i);
    			String methodName = request.getParameter("methodName"+i);
    			String methodNameBase = request.getParameter("methodNameBase"+i);
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			String errorMessage = "";
            	String forwardPage = "bindClass.jsp?formName="+hiddenFormName;
            	//下面开始修改xml文件
            	XmlUtils.editToXml(xmlPath,"bindClass",only,"formName",only,"className",className,"methodName",methodName);
        		errorMessage = "报表【"+formNameCn+"】绑定的类名【"+classNameBase+"】方法名【"+methodNameBase+"】修改后为类名【"+className+"】方法名【"+methodName+"】！";
            	request.setAttribute("errorMessage", errorMessage);
            	request.getRequestDispatcher(forwardPage).forward(request,response); 
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/bindClassDelete")){
    		try{
    			String hiddenFormName = request.getParameter("hiddenFormName");
    			String only = request.getParameter("only");
    			String i = request.getParameter("id");
    			String formNameCn = request.getParameter("formNameCn"+i);
    			String classNameBase = request.getParameter("classNameBase"+i);
    			String methodNameBase = request.getParameter("methodNameBase"+i);
    			String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+hiddenFormName+".xml";
    			String errorMessage = "";
            	String forwardPage = "bindClass.jsp?formName="+hiddenFormName;
            	//下面开始删除xml文件中的一条记录
            	XmlUtils.removeOneNodeName(xmlPath, "bindClass", "formName", only);
        		errorMessage = "报表【"+formNameCn+"】绑定的类名【"+classNameBase+"】方法名【"+methodNameBase+"】这条记录删除成功！";
            	request.setAttribute("errorMessage", errorMessage);
            	request.getRequestDispatcher(forwardPage).forward(request,response); 
    		}catch(Exception e){
    			e.printStackTrace();
    		}	
    	}
    	
    	if(screen.equals("/pages/reportIE/firstSetupToXmlAdd")){
    		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 = "";