/*
 * DataBufferTest.java
 *
 * Created on 9 de agosto de 2006, 9:28
 */
 
package com.adminsa.accounting.model;
 
import com.adminsa.util.InitUI;
import org.jdesktop.databuffer.DataSet;
import org.jdesktop.databuffer.DataTable;
import org.jdesktop.databuffer.event.DataTableListener;
import org.jdesktop.databuffer.event.RowChangeEvent;
import org.jdesktop.databuffer.event.TableChangeEvent;
import org.jdesktop.databuffer.provider.sql.JDBCDataConnection;
import org.jdesktop.databuffer.provider.sql.SQLDataProvider;
import org.jdesktop.databuffer.provider.sql.TableCommand;
 
 
/**
 *
 * @author  dags
 */
public class DataBufferTest extends org.jdesktop.swingx.JXPanel implements DataTableListener {
    
    private CurrencyTableModel modelo = null;
    private SQLDataProvider dp = null;
    private JDBCDataConnection dc = null;
    private TableCommand tc = null;
    private DataSet ds = null;
    private DataTable dt = null;
    
    /** Creates new form BeanForm */
    public DataBufferTest() {
        initComponents();
 
        dc = new JDBCDataConnection("org.postgresql.Driver", "jdbc:postgresql://mi_servidor/mag", "dags", "");
        dc.setConnected(true);
        
        tc = new TableCommand("currencies");
        tc.setSchemaName("accounting");
        
        dp = new SQLDataProvider();
        dp.setConnection(dc);
        dp.setCommand(tc);
 
        ds = new DataSet("accounting");
        
        dt = new DataTable(ds, "monedas");
        dt.createColumn(String.class, "currency_id");
        dt.createColumn(String.class, "currency_name");
        dt.addDataTableListener(this);
        dt.setDataProvider(dp);
 
        dt.load();
        dt.getColumn("currency_id").setKeyColumn(true);
        
        modelo = new CurrencyTableModel(dt);
        jXTable1.setModel(modelo);
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" Código Generado ">
    private void initComponents() {
        jScrollPane1 = new javax.swing.JScrollPane();
        jXTable1 = new org.jdesktop.swingx.JXTable();
 
        setLayout(new java.awt.BorderLayout());
 
        jXTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null},
                {null, null},
                {null, null},
                {null, null}
            },
            new String [] {
                "Moneda", "Denominación"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.String.class, java.lang.String.class
            };
 
            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jScrollPane1.setViewportView(jXTable1);
 
        add(jScrollPane1, java.awt.BorderLayout.CENTER);
 
    }// </editor-fold>
    
    
    // Declaración de variables - no modificar
    private javax.swing.JScrollPane jScrollPane1;
    private org.jdesktop.swingx.JXTable jXTable1;
    // Fin de declaración de variables
        public static void main(String args[]) {
        
        InitUI.initUI();
        
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                javax.swing.JFrame frame = new javax.swing.JFrame(" DataBufferTest ");
                frame.setDefaultCloseOperation(javax.swing.JFrame.EXIT_ON_CLOSE);
                frame.setLayout(new java.awt.BorderLayout());
                frame.add(new DataBufferTest(), java.awt.BorderLayout.CENTER);
                frame.pack();
                frame.setVisible(true);
            }
        });
    }
 
    public void rowChanged(RowChangeEvent evt) {
        //System.out.println("rowChanged " + evt.toString());
    }
 
    public void tableChanged(TableChangeEvent evt) {
        //System.out.println("tableChanged " + evt.toString());
        switch(evt.getEventType()) {
            case LOAD_COMPLETE:
                System.out.println("RowCount = " + dt.getRowCount());
                break;
            case COLUMN_CHANGED:
                break;
            case LOAD_STARTED:
                break;
            case ROW_ADDED:
                break;
            case ROW_DELETED:
                break;
            case ROW_DISCARDED:
                break;
            case SAVE_COMPLETE:
                break;
            case SAVE_STARTED:
                break;
            case TABLE_CLEARED:
                break;
        }
    }
}

package com.adminsa.accounting.model;
 
import org.jdesktop.databuffer.DataTable;
 
/**
 *
 * @author  dags
 */
public class CurrencyTableModel extends javax.swing.table.AbstractTableModel {
    
    private DataTable dt = null;
    
    // to hold header's titles, if needed
    private String[] columnTitles = null;
    
    private String[] columnNames = {
        "currency_id",
        "currency_name"};
    
    /** Creates a new empty instance of CurrencyTableModel */
    public CurrencyTableModel() {
    }
    
    /** Creates a new instance of CurrencyTableModel linked to a DataTable  */
    public CurrencyTableModel(DataTable dt) {
        this();
        setDataTable(dt);
    }
    
    public void setDataTable(DataTable dt) {
        this.dt = dt;
   
        // notify model has changed
        fireTableDataChanged();
    }
    
    public int getColumnCount() {
        return (dt == null ? 0 : dt.getColumns().size());
    }
    
    public int getRowCount() {
        return (dt == null ? 0 : dt.getRowCount());
    }
    
    public Object getValueAt(int rowIndex, int columnIndex) {
        return (dt == null ? null : dt.getValue(rowIndex, columnNames[columnIndex]));
    }
 
    public void setValueAt(Object value, int row, int col) {
        
        if (dt == null) return;
        
        dt.setValue(row, columnNames[col], value);
        
        // save on every model's data change. Maybe is not needed if there is a Save button somewhere ...
        dt.save();
        
        //notify model has changed
        fireTableCellUpdated(row, col);
    }
    
    public String getColumnName(int columnIndex) {
        return columnTitles == null ? columnNames[columnIndex] : columnTitles[columnIndex];
    }
 
    public String[] getColumnTitles() {
        return columnTitles;
    }
 
    public void setColumnTitles(String[] columnTitles) {
        this.columnTitles = columnTitles;
    }
    
    public Class getColumnClass(int columnIndex) {
        return getValueAt(0, columnIndex).getClass();
    }
    
    public boolean isCellEditable(int rowIndex, int columnIndex) {
        return !dt.getColumn(columnNames[columnIndex]).isReadOnly();
    }
    
    public void populate() {
        if (dt == null) return;
        
        // clear DataTable and load again ...
        dt.refresh();
 
        //notify model has changed
        fireTableDataChanged();
    }
}

package com.adminsa.accounting.model;
 
import java.util.ArrayList;
import java.util.List;
import org.jdesktop.databuffer.DataColumn;
import org.jdesktop.databuffer.DataTable;
 
/**
 *
 * @author  dags
 */
public class CurrencyTableModel extends javax.swing.table.AbstractTableModel {
    
    private DataTable dt = null;
    
    // to hold header's titles, if needed
    private String[] columnTitles = null;
    
    // to hold column names, from DataTable
    private ArrayList<String> columnNames = null;
    
    /** Creates a new empty instance of CurrencyTableModel */
    public CurrencyTableModel() {
    }
    
    /** Creates a new instance of CurrencyTableModel linked to a DataTable  */
    public CurrencyTableModel(DataTable dt) {
        this();
        setDataTable(dt);
    }
    
    public void setDataTable(DataTable dt) {
        this.dt = dt;
   
        List<DataColumn> columns = dt.getColumns();
 
        columnNames = new ArrayList<String>();
        
        for (DataColumn column : columns)
            columnNames.add(column.getName());
 
        // notify model has changed
        fireTableDataChanged();
    }
    
    public int getColumnCount() {
        return (dt == null ? 0 : dt.getColumns().size());
    }
    
    public int getRowCount() {
        return (dt == null ? 0 : dt.getRowCount());
    }
    
    public Object getValueAt(int rowIndex, int columnIndex) {
        return (dt == null ? null : dt.getValue(rowIndex, columnNames.get(columnIndex) ));
    }
 
    public void setValueAt(Object value, int row, int col) {
        
        if (dt == null) return;
        
        dt.setValue(row, columnNames.get(col), value);
        
        // save on every model's data change. Maybe is not needed if there is a Save button somewhere ...
        dt.save();
        
        //notify model has changed
        fireTableCellUpdated(row, col);
    }
    
    public String getColumnName(int columnIndex) {
        // if column Titles are setup, use it. If not, use column names from database.
        // columns titles are supposed to be more "human friendly"
        return columnTitles == null ? columnNames.get(columnIndex) : columnTitles[columnIndex];
    }
 
    public String[] getColumnTitles() {
        return columnTitles;
    }
 
    public void setColumnTitles(String[] columnTitles) {
        this.columnTitles = columnTitles;
    }
    
    public Class getColumnClass(int columnIndex) {
        return getValueAt(0, columnIndex).getClass();
    }
    
    public boolean isCellEditable(int rowIndex, int columnIndex) {
        return !dt.getColumn( columnNames.get(columnIndex) ).isReadOnly();
    }
    
    public void populate() {
        if (dt == null) return;
        
        // clear DataTable and load again ...
        dt.refresh();
 
        //notify model has changed
        fireTableDataChanged();
    }
}