Oracle Database Discussions

package gui;

import java.awt.*;

import javax.swing.*;
import javax.swing.event.*;
import javax.swing.table.*;

public class FixedTableRowDemo extends JFrame
{
  JTable dataTable;
  JTable summaryTable;
  
  public FixedTableRowDemo()
  {
    dataTable = new JTable(5, 5);
    dataTable.setPreferredScrollableViewportSize(
        dataTable.getPreferredSize());
    summaryTable = new JTable(1, 5);
    
    Container c = getContentPane(); 
    c.add(new JScrollPane(dataTable), BorderLayout.CENTER);
    c.add(summaryTable, BorderLayout.SOUTH);
    
    TableColumnModelListener tcmListener = new TableColumnModelListener()
    {
      public void columnMarginChanged(ChangeEvent e)
      {
        TableColumnModel dataModel = dataTable.getColumnModel();
        TableColumnModel summaryModel = summaryTable.getColumnModel();
        
        for (int i = 0; i < dataModel.getColumnCount(); i++)
        {
          summaryModel.getColumn(i).setPreferredWidth(
              dataModel.getColumn(i).getWidth());
        }
      }
      
      public void columnAdded(TableColumnModelEvent e){}
      public void columnMoved(TableColumnModelEvent e){}
      public void columnRemoved(TableColumnModelEvent e){}
      public void columnSelectionChanged(ListSelectionEvent e){}
    };
     
    dataTable.getColumnModel().addColumnModelListener(tcmListener);
//    summaryTable.setColumnModel(dataTable.getColumnModel());
    
    setDefaultCloseOperation(EXIT_ON_CLOSE);
    pack();
    setLocationRelativeTo(null);
  }

  public static void main(String[] args)
  {
    JFrame frame = new FixedTableRowDemo();
    frame.setVisible(true);
  }
}

import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.Font;
import java.text.DecimalFormat;
import java.util.Comparator;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.TableColumnModelEvent;
import javax.swing.event.TableColumnModelListener;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableCellRenderer;
import javax.swing.table.JTableHeader;
import javax.swing.table.TableColumnModel;
import javax.swing.table.TableModel;
import javax.swing.table.TableRowSorter;

public class Sabre20090331
{
    static private class TotalizingTableComponent extends JScrollPane
    {
        private TotalizingTableComponent(final TableModel tableModel)
        {
            final SecondaryTableModel secondaryTableModel = new SecondaryTableModel(tableModel);
            final JTable secondaryTable = new JTable(secondaryTableModel);
            for (int i = 1; i < secondaryTableModel.getColumnCount(); i++)
            {
                secondaryTable.getColumnModel().getColumn(i).setCellRenderer(new NumberCellRenderer());
            }
            secondaryTable.getColumnModel().getColumn(0).setCellRenderer(new TitleCellRenderer());
            final TableColumnModel secondaryTableColumnModel = secondaryTable.getColumnModel();
            secondaryTable.setRowSelectionAllowed(false);

            final JTable primaryTable = new JTable(tableModel);
            for (int i = 1; i < tableModel.getColumnCount(); i++)
            {
                primaryTable.getColumnModel().getColumn(i).setCellRenderer(new NumberCellRenderer());
            }
            final TableRowSorter<TableModel> sorter = new TableRowSorter<TableModel>(tableModel);
            final DoubleComparator doubleComparator = new DoubleComparator();
            for (int i = 1; i < tableModel.getColumnCount(); i++)
            {
                sorter.setComparator(i, doubleComparator);
            }
            primaryTable.setRowSorter(sorter);
            primaryTable.getColumnModel().addColumnModelListener(new TableColumnModelListener()
            {
                @Override
                public void columnAdded(TableColumnModelEvent e)
                {
                    // System.out.println("columnAdded()" + e);
                }

                @Override
                public void columnRemoved(TableColumnModelEvent e)
                {
                    // System.out.println("columnRemoved()" + e);
                }

                @Override
                public void columnMoved(TableColumnModelEvent e)
                {
                    //System.out.println("columnMoved()" + e);
                    secondaryTableColumnModel.moveColumn(e.getFromIndex(), e.getToIndex());
                }

                @Override
                public void columnMarginChanged(ChangeEvent e)
                {
                    //System.out.println("columnMarginChanged()" + e);
                    final TableColumnModel cm = (TableColumnModel) e.getSource();
                    for (int i = 0; i < cm.getColumnCount(); i++)
                    {
                        secondaryTableColumnModel.getColumn(i).setPreferredWidth(cm.getColumn(i).getWidth());
                    }
                }

                @Override
                public void columnSelectionChanged(ListSelectionEvent e)
                {
                    //System.out.println("columnSelectionChanged()" + e);
                }

            });

            final JTableHeader primaryHeader = primaryTable.getTableHeader();
            JPanel inner = new JPanel(new BorderLayout());
            this.setColumnHeaderView(primaryHeader);
            this.setViewportView(inner);
            inner.add(primaryTable, BorderLayout.NORTH);
            inner.add(secondaryTable, BorderLayout.CENTER);
        }

        public static void main(String[] args)
        {
            final JFrame frame = new JFrame("Totalizing JTable Example");
            frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
            final TableModel tableModel = new PrimaryTableModel();
            frame.setContentPane(new TotalizingTableComponent(tableModel));
            frame.pack();
            frame.setVisible(true);

        }

    }

}

class PrimaryTableModel extends AbstractTableModel
{
    @Override
    public Object getValueAt(int row, int col)
    {
        switch (col)
        {
            case 1:
                return new Double(row);
            case 2:
                return new Double(row * row);
            case 3:
                return new Double(row / (1.0 + row));
            default:
                return "Row " + row;
        }
    }

    @Override
    public int getColumnCount()
    {
        return columnNames.length;
    }

    @Override
    public int getRowCount()
    {
        return 30;
    }

    @Override
    public String getColumnName(int col)
    {
        return col < columnNames.length ? columnNames[col] : "";
    }

    private static final String[] columnNames =
    {
        "Title", "X", "Y", "Z"
    };
}

class SecondaryTableModel extends AbstractTableModel
{
    public SecondaryTableModel(TableModel primaryTableModel)
    {
        primaryTableModel_ = primaryTableModel;
    }

    @Override
    public boolean isCellEditable(int row, int col)
    {
        return false;
    }

    @Override
    public Object getValueAt(int row, int col)
    {
        if (col == 0)
            return "Total";
        else
        {
            double sum = 2;
            for (int i = 0; i < primaryTableModel_.getRowCount(); i++)
            {
                sum += (Double) primaryTableModel_.getValueAt(i, col);
            }
            return new Double(sum);
        }
    }

    @Override
    public int getColumnCount()
    {
        return primaryTableModel_.getColumnCount();
    }

    @Override
    public int getRowCount()
    {
        return 1;
    }

    @Override
    public String getColumnName(int col)
    {
        return primaryTableModel_.getColumnName(col);
    }

    private final TableModel primaryTableModel_;
}

class DoubleComparator implements Comparator<Double>
{
    public int compare(Double left, Double right)
    {
        return left.compareTo(right);
    }

}

class TitleCellRenderer extends DefaultTableCellRenderer
{
    @Override
    public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int col)
    {
        final Component comp = super.getTableCellRendererComponent(table, value, isSelected, hasFocus, row, col);
        if (table.convertColumnIndexToModel(col) == 0)
        {
            comp.setFont(comp.getFont().deriveFont(Font.BOLD));
            ((JLabel) comp).setHorizontalAlignment(JLabel.RIGHT);
        } else
        {
            comp.setFont(comp.getFont().deriveFont(Font.PLAIN));
            ((JLabel) comp).setHorizontalAlignment(JLabel.LEFT);
        }
        return comp;
    }

}

class NumberCellRenderer extends DefaultTableCellRenderer
{
    private final DecimalFormat formatter = new DecimalFormat("0.000");
    @Override
    public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int col)
    {
        boolean isNumber = value instanceof Number;
        if (isNumber)
        {
            value = formatter.format(value);
        }
        final Component comp = super.getTableCellRendererComponent(table, value, isSelected, hasFocus, row, col);
        ((JLabel) comp).setHorizontalAlignment(isNumber ? JLabel.RIGHT : JLabel.LEFT);

        return comp;
    }

}