public   class  DatabaseTableModel  extends  AbstractTableModel
    {
         private  ArrayList columnNames =  new  ArrayList();
         private  ArrayList columnTypes =  new  ArrayList();
         private  ArrayList data =  new  ArrayList();
         private   boolean  editable;

         public  DatabaseTableModel( boolean  editable)
        {
             this .editable = editable;
        }
         public   int  getRowCount()
        {
             synchronized (data)
            {
                return  data.size();
            }
        }
         public   int  getColumnCount()
        {
             return  columnNames.size();
        }
         int  x;
         public   Class  getColumnClass( int  column)
        {
             return  ( Class )columnTypes.get(column);
        }
         public  String getColumnName( int  column)
        {
             return  (String)columnNames.get(column);
        }
         public  Object getValueAt( int  row,  int  column)
        {
             synchronized (data)
            {
                 return  ((ArrayList)data.get(row)).get(column);
            }
        }
         public   boolean  isEditable( int  row,  int  column)
        {
             return  editable;
        }
         public   void  setValueAt(Object value,  int  row,  int  column)
        {
             synchronized (data)
            {
                ((ArrayList)data.get(row)).set(column, value);
            }
        }
         private   Class  getClassName(String type, String _class)
        {
             Class  ClassName =  null ;
             if  (type=="BLOB")
                 return  Icon. class ;
             else 
            {
                 try 
                    {ClassName= Class .forName(_class);}
                 catch (Exception err)
                    {}
             return  ClassName;
            }
        }
         public   void  setDataSource(ResultSet rs)  throws  Exception
        {
            data.clear();
            columnNames.clear();
            columnTypes.clear();

            ResultSetMetaData rsmd = rs.getMetaData();
             int  columnCount = rsmd.getColumnCount();
            
             for ( int  i= 0 ; i<columnCount; i++)
            {
                columnNames.add(rsmd.getColumnName(i+ 1 ));
                 Class  type=getClassName(rsmd.getColumnTypeName(i+ 1 ),rsmd.getColumnClassName(i+ 1 ));
                columnTypes.add(type);
            }
           fireTableDataChanged();

             while (rs.next())
            {
                ArrayList row =  new  ArrayList();
                 for ( int  i= 0 ; i<columnCount; i++)
                {
                   if (columnTypes.get(i) == Icon. class )
                  {
                       byte  image []= rs.getBytes(i+ 1 );
                       if  (image!= null )
                        row.add( new  ImageIcon(image));
                       else 
                        row.add( null );
                  }
                   else 
                       row.add(rs.getObject(i+ 1 ));
                }

                 synchronized (data)
                {
                    data.add(row);

                     this .fireTableRowsInserted(data.size()- 1 , data.size()- 1 );
                }
            }
        }
    }

 public   class  TransposeTableModel  extends  AbstractTableModel
{
    DatabaseTableModel model;

     public  TransposeTableModel( boolean  editable)
    {
        model =  new  DatabaseTableModel(editable);
    }
     public   int  getRowCount()
    {
         return  model.getColumnCount();
    }
     public   int  getColumnCount()
    {
         return  model.getRowCount();
    }

     public   Class  getColumnClass( int  column)
    {
        // ???????
        // ???????
        // ???????
    }

     public  Object getValueAt( int  row,  int  column)
    {
         return  model.getValueAt(column, row);
    }
     public   void  setDataSource(ResultSet rs)  throws  Exception
    {
        model.setDataSource(rs);
    }
}