List的JavaExcel工具类（读，写）

  07年9月的

读XML：

import java.io.File;
import java.io.FileWriter;
import java.util.Iterator;
import java.util.List;

import org.dom4j.Attribute;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;

public class ReaderXml ...{

    public ReaderXml() ...{
        // TODO Auto-generated constructor stub
    }
    
    
    private static void getXml(String filename)...{
        SAXReader sax = new SAXReader();
        Document doc = null;
        try ...{
            sax.setEncoding("utf-8");
            doc = sax.read(new File(filename));
            Element root = doc.getRootElement();
            List list = root.elements();
            
            for(Iterator i = root.elementIterator(); i.hasNext();)...{
                Element e = (Element) i.next();
//                   System.out.println(e.getName());
//                   System.out.println(e.getPath());
//                   System.out.println(e.getText());
                   System.out.println(e.getStringValue());
                for(Iterator j = e.attributeIterator();j.hasNext();)...{
                     Attribute attribute = (Attribute) j.next();
//                    System.out.println(attribute.getStringValue());
                }
            }

        } catch (DocumentException e) ...{
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    /** *//**
     * @param args
     */
    public static void main(String[] args) ...{
        // TODO Auto-generated method stub
        ReaderXml.getXml("g:\DB.xml");
        
    }

}

写XML：

import java.io.File;
import java.io.FileOutputStream;

import org.dom4j.Document;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;

public final class WriterXml ...{

    public WriterXml(Document doc) ...{
        // TODO Auto-generated constructor stub
        XMLWriter writer = null;
        try ...{
            String filename = "g:\WriterXml.xml";
            OutputFormat format = OutputFormat.createPrettyPrint();

            FileOutputStream fos = new FileOutputStream(new File(filename));
            // OutputStreamWriter osw = new OutputStreamWriter(fos,"utf-8");
            // format.setEncoding("utf-8");
            writer = new XMLWriter(fos, format);
            writer.write(doc);
            writer.close();

        } catch (Exception e) ...{
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

}