All pastes #1216955 Raw Edit

Anonymous

public java v1 · immutable
#1216955 ·published 2008-10-02 15:27 UTC
rendered paste body
import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.io.File;import jxl.*;import java.util.*;import jxl.read.biff.*;import java.util.ArrayList;import java.util.Iterator;import java.util.ListIterator;public class Appli extends HttpServlet implements Servlet {	public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {		res.setContentType("text/xml");				// instanciation du buffer de sortie		PrintWriter out = res.getWriter();		out.println("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");		out.println("<elements>");		try{			JExcel jxl = new JExcel("/home/xwz/public_html/jexcel/xls/input.xls");					String act = req.getParameter("action");						if(act != null && act.equals("details")){				out.println("<tabs>");				String[] names = jxl.getSheetNames();				int n = names.length;				for(int i=0; i < n; i++)					out.println("<tab>"+names[i]+"</tab>");				out.println("</tabs>");			}else if(act != null && act.equals("HNumList")){				String title = req.getParameter("title");				String line = req.getParameter("line");				if(!title.equals(null) && !line.equals(null)){					ArrayList<Double> l = jxl.getHorizontalNumberList("Feuille1", Integer.decode(line), title);					Iterator<Double> itr = l.iterator();					out.println("<values>");					while (itr.hasNext())						out.println("<value>"+itr.next()+"</value>");					out.println("</values>");				}else{					out.println("<errors>");					if(title.equals(null))						out.println("<error>le titre de colonne doit etre definit</error>");										if(line.equals(null))						out.println("<error>la ligne contenant les titres de colonnes doit etre definit</error>");										out.println("</errors>");				}			}else{				out.println("<errors>");				out.println("<error>Une action doit etre definie</error>");				out.println("</errors>");			}		}catch(IOException e){			out.println("IOException");			out.println(e.getMessage());		}catch(BiffException e){			out.println("BiffException");			out.println(e.getMessage());		}		out.println("</elements>");		out.close();	}}