recursive Observer, or TableModelListener?

I'm not quite sure how to approach binding (?) the view to the TableModel
to the db, which sounds recursive. The JTable observes the TableModel
(CarModel) which observes the Model (the db)?

How do I tie them together so that changes to the db propagate up to the
JTable?

How would the TableModelListener,

http://java.sun.com/docs/books/tutorial/uiswing/components/
table.html#modelchange

,work for this situation?

thufir@arrakis:~/bcit3621$
thufir@arrakis:~/bcit3621$ cat crud/src/a00720398/model/CarModel.java
package a00720398.model;

import a00720398.model.*;
import a00720398.view.*;
import java.sql.*;
import java.util.*;
import java.util.logging.*;
import javax.swing.*;
import javax.swing.table.*;

@SuppressWarnings({"serial", "unchecked"})
public class CarModel extends DefaultTableModel implements Observer {

    private static final TableModel INSTANCE = new CarModel();

    private CarModel() {
        this.dataVector = Model.getInstance().getDataVector();
        this.columnIdentifiers = Model.getInstance().getColumnIdentifiers
();
    }

    public static TableModel getInstance() {
        return INSTANCE;
    }

    public void update(Observable arg0, Object arg1) {
        throw new UnsupportedOperationException("Not supported yet.");
    }
}

thufir@arrakis:~/bcit3621$
thufir@arrakis:~/bcit3621$ cat crud/src/a00720398/model/Model.java
package a00720398.model;

import a00720398.model.*;
import java.sql.*;
import java.util.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.table.*;

@SuppressWarnings({"unchecked"})
public class Model extends Observable {

    private static final Model INSTANCE = new Model();
    private Connection connection = DBConnection.getInstance
().getConnection();
    private Vector dataVector = new Vector();
    private Vector columnIdentifiers = new Vector();

    private Model() {
        try {
            init();
        } catch (SQLException ex) {
            Logger.getLogger(Model.class.getName()).log(Level.SEVERE,
null, ex);
        }
    }

    public static Model getInstance() {
        return INSTANCE;
    }

    private void init() throws SQLException {
        ResultSet resultSet = getResultSet();
        int columnCount = resultSet.getMetaData().getColumnCount();
        for (int i = 1; i <= columnCount; i++) {
            String columnName = resultSet.getMetaData().getColumnName(i);
            columnIdentifiers.add(columnName);
        }
        
        while (resultSet.next()) {
            int i = resultSet.getRow();
            Vector car = new Vector();
            for (int j = 1; j < columnCount + 1; j++) {
                car.add(resultSet.getObject(j));
            }
            dataVector.add(car);
        }
    }

    private ResultSet getResultSet() throws SQLException {
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery("SELECT * FROM
cars");
        return resultSet;
    }
    
    public Vector getDataVector(){
        return dataVector;
    }
    
    public Vector getColumnIdentifiers(){
        return columnIdentifiers;
    }
}
thufir@arrakis:~/bcit3621$

thanks,

Thufir