如何在FineReport中解析数据库内XML文件

package com.fr.data;   
   
import
import
import
import java.util.logging.Level;   
import com.fr.base.FRContext;     
import com.fr.stable.xml.XMLReadable;  
import com.fr.stable.xml.XMLableReader;  
   
public class GetXmlDate {   
    // 定义返回值数组   
    private String[] Value = new String[3];   
    // 定义查询的name值   
    private String[] Name = null;   
   
    protected String[] readerXMLSource(InputStream in, String[] name)   
            throws Exception {   
        Name = name;   
        InputStreamReader reader = new InputStreamReader(in, "utf-8");   
        readXMLSource(reader);   
        return Value;   
    }   
   
    protected void readXMLSource(Reader reader) throws Exception {   
        XMLableReader xmlReader = XMLableReader.createXMLableReader(reader);   
        if (xmlReader != null) {   
            xmlReader.readXMLObject(new Content());   
   
        }   
    }   
   
    private class Content implements XMLReadable {   
        public void readXML(XMLableReader reader) {   
            if (reader.isChildNode()) {   
                if (reader.getTagName().equals("Field")) {   
                    Field field = new Field();   
                    reader.readXMLObject(field);   
                    // 获得name对应的value值   
                    if (Name[0].equals(field.name)) {   
                        Value[0] = field.value;   
                    } else if (Name[1].equals(field.name)) {   
                        Value[1] = field.value;   
                    } else if (Name[2].equals(field.name)) {   
                        Value[2] = field.value;   
                    }   
                }   
            }   
        }   
    }   
   
    // 定义每个field的结构   
    private class Field implements XMLReadable {   
        private String name;   
        private String type;   
        private String value;   
   
        public void readXML(XMLableReader reader) {   
            if (reader.isChildNode()) {   
                String tagName = reader.getTagName();   
                if (tagName.equals("Name")) {   
                    this.name = reader.getElementValue();   
                } else if (tagName.equals("Type")) {   
                    this.type = reader.getElementValue();   
                } else if (tagName.equals("Value")) {   
                    this.value = reader.getElementValue();   
                }   
            }   
        }   
    }   
}  

package com.fr.data;   
   
import import import java.sql.Connection;   
import java.sql.DriverManager;   
import java.sql.ResultSet;   
import java.sql.Statement;   
import java.util.ArrayList;      
import com.fr.data.AbstractTableData;   
   
public class XMLRead extends AbstractTableData {   
    // 列名数组，保存程序数据集所有列名   
    private String[] columnNames = { "id", "name", "MemoryFreeSize",   
            "MemoryTotalSize", "MemoryUsage" };   
    // 保存表数据   
    private ArrayList valueList = null;   
   
    public int getColumnCount() {   
        return 5;   
    }   
   
    public String getColumnName(int columnIndex) {   
        return columnNames[columnIndex];   
    }   
   
    public int getRowCount() {   
        init();   
        return valueList.size();   
    }   
   
    public Object getValueAt(int rowIndex, int columnIndex) {   
        init();   
        return ((Object[]) valueList.get(rowIndex))[columnIndex];   
    }   
   
    private void init() {   
        // 确保只被执行一次   
        if (valueList != null) {   
            return;   
        }   
        valueList = new ArrayList();   
        String sql = "select * from xmltest";   
        String[] name = { "MemoryFreeSize", "MemoryTotalSize", "MemoryUsage" };   
        Connection conn = this.getConncetion();   
        try {   
            Statement stmt = conn.createStatement();   
            ResultSet rs = stmt.executeQuery(sql);   
            // 用对象保存数据   
            Object[] objArray = null;   
            while (rs.next()) {   
                objArray = new Object[5];   
                String[] xmldata = null;   
                objArray[0] = rs.getObject(1);   
                objArray[1] = rs.getObject(2);   
                InputStream in = new StringBufferInputStream("<demo>"   
                        + rs.getObject(3).toString() + "</demo>");   
                GetXmlDate getxmldata = new GetXmlDate();   
                // 对xml流进行解析，返回的为name对应的value值数组   
                xmldata = getxmldata.readerXMLSource(in, name);   
                // 将解析后的值存于最终结果ArrayList中   
                objArray[2] = xmldata[0];   
                objArray[3] = xmldata[1];   
                objArray[4] = xmldata[2];   
                valueList.add(objArray);   
            }   
            // 释放数据源   
            rs.close();   
            stmt.close();   
            conn.close();   
        } catch (Exception e) {   
            e.printStackTrace();   
        }   
    }   
   
    public Connection getConncetion() {   
        String driverName = "oracle.jdbc.driver.OracleDriver";   
        String url = "jdbc:oracle:thin:@192.168.100.169:1521:orcl10g";   
        String username = "temp";   
        String password = "temp123";   
        Connection con = null;   
   
        try {   
            Class.forName(driverName);   
            con = DriverManager.getConnection(url, username, password);   
        } catch (Exception e) {   
            e.printStackTrace();   
            return null;   
        }   
        return con;   
   
    }   
   
    // 释放一些资源，因为可能会有重复调用，所以需释放valueList，将上次查询的结果释放掉   
    public void release() throws Exception {   
        super.release();   
        this.valueList = null;   
    }   
}