cachingresultsettablemodel.java

梦界家园程序开发基底框架

package jm.framework.gui.module.jmtable.model ;

import java.sql.ResultSet;
import java.sql.SQLException;

import jm.util.JMVector;

public class CachingResultSetTableModel
    extends ResultSetTableModel
{
    /**
	 * 
	 */
	private static final long serialVersionUID = 7862482094302390179L;
	public static final String CLASS_NAME = "CachingResultSetTableModel" ;
    private JMVector<Object> cache ;
    public CachingResultSetTableModel ( ResultSet aResultSet )
    {
        super ( aResultSet ) ;
 //       final String sMethod = "CachingResultSetTableModel" ;
        try
        {
            cache = new JMVector<Object> () ;
            int cols = getColumnCount () ;
            ResultSet rs = getResultSet () ;

            /* place all data in an array list of Object[] arrays
               We don't use an Object[][] because we don't know
               how many rows are in the result set
             */

            while ( rs.next () )
            {
                Object[] row = new Object[cols ] ;
                for ( int j = 0 ; j < row.length ; j++ )
                    row[ j ] = rs.getObject ( j + 1 ) ;
                cache.add ( row ) ;
            }
        }
        catch ( SQLException e )
        {
//            ServerTypes.printLog ( CLASS_NAME,sMethod, e ) ;
        }
    }

    public Object getValueAt ( int r , int c )
    {
        if ( r < cache.size () )
            return ( ( Object[] ) cache.get ( r ) )[ c ] ;
        else
            return null ;
    }

    public int getRowCount ()
    {
        return cache.size () ;
    }

}