The right way to inherit AbstractTableModel

[skywriter]

I need 2 descendants of AbstractTableModel:

the first one uses "connection" object for creating it's "statement" object;
the second one composes "connection" object.

I assume the right beginning of the first class could be so:

public class ResultSetTableModel extends AbstractTableModel {

	protected Statement statement;
	protected ResultSet resultSet;
	protected ResultSetMetaData metaData;
	protected int numOfRows;
	
	public ResultSetTableModel(Connection connection) throws         SQLException {
		
		statement = connection.createStatement(
				ResultSet.TYPE_SCROLL_INSENSITIVE,
				ResultSet.CONCUR_READ_ONLY );
		
	}

and the second:

public class ResultSetTableModelConnection extends ResultSetTableModel {
	
	Connection connection;
	
	public ResultSetTableModelConnection(String driver, String url, String query)
	  throws SQLException, ClassNotFoundException {	
		Class.forName(driver);
		connection = DriverManager.getConnection(url);
		super(connection);
		setQuery(query);
	}

But the issue is Java stricts to call ascendant's constructor only at the first string where "connection" object is not created yet. What should be the right desision?

[Tolls]

I wouldn't do that db work inside the table model...
Too much like mixing display and db layers together.

[skywriter]

Thank you for answer. I agree with you but the class "ResultSetTableModel" was taken from H.Deitel's book "Advanced Java 2 Platform".
Solved here.

[Tolls]

Oh right.
Thanks for putting a link to the answer up.
Even in Russian...:)