rawdata.java

利用java反射机制

package org.julp;

import java.sql.*;
    /** 
     *  RawData is collection of DataHolders.
     *  Use it when you don't need *real* objects, just tabular data (reports?)
     *  Less overhead.    
     */                  
public class RawData extends java.util.ArrayList implements java.io.Serializable, Cloneable {
   
    public RawData(ResultSet resultSet, boolean populateColumnNames) {
        this.populateColumnNames = populateColumnNames;
        populate(resultSet, populateColumnNames);
    }
    
    public RawData() {}
    
    public RawData(ResultSet resultSet) {
        populate(resultSet, this.populateColumnNames);
    }    
    
    protected ResultSetMetaData rsmd = null;
    protected ResultSet resultSet = null;
    protected boolean populateColumnNames = true;     
    
    public void populate(ResultSet resultSet, boolean populateColumnNames) {
        try{
            this.resultSet = resultSet;
            this.rsmd = resultSet.getMetaData();
            int colCount = rsmd.getColumnCount();
            while (resultSet.next()){
                DataHolder dataHolder = new DataHolder(colCount);                  
                for (int i = 1;i <= colCount;i++){
                    if (populateColumnNames){
                        dataHolder.setFieldName(i, rsmd.getColumnName(i));
                    }
                    dataHolder.setObject(i, resultSet.getObject(i));
                }
                this.add(dataHolder);
            }            
        }catch(SQLException e){
            throw new RuntimeException(e);
        }finally{
            try{
                if (this.resultSet != null) this.resultSet.close();
            }catch(SQLException e){
                throw new RuntimeException(e);
            }
        }
    }        
    
    /** Getter for property populateColumnNames.
     * @return Value of property populateColumnNames.
     *
     */
    public boolean isPopulateColumnNames() {
        return populateColumnNames;
    }
    
    /** Setter for property populateColumnNames.
     * @param populateColumnNames New value of property populateColumnNames.
     *
     */
    public void setPopulateColumnNames(boolean populateColumnNames) {
        this.populateColumnNames = populateColumnNames;
    }
    
}