removeRow() in AbstractTableModel

[Jhedzkie Skies]

I am using another class in populating my table... having AbstractTableModel means no removeRow()...
here's my code...

  package studentdb;

import javax.swing.*;
	import javax.swing.table.*;
	import java.sql.*;
	import java.util.*;
	/** an immutable table model built from getting
		metadata about a table in a jdbc database
	*/ 
	public class JDBCTableModel extends AbstractTableModel {
		Object[][] contents;
		String[] columnNames;
		Class[] columnClasses;
        ArrayList rowList;
		public JDBCTableModel (Connection conn,
				   String tableName)
			throws SQLException {
			super();
			getTableContents (conn, tableName);

		}
		protected void getTableContents (Connection conn,
					 String tableName)
			throws SQLException {

		// get metadata: what columns exist and what
		// types (classes) are they?
		DatabaseMetaData meta = conn.getMetaData();
		System.out.println ("got meta = " + meta);
		ResultSet results =
			meta.getColumns (null, null, tableName, null) ;
		System.out.println ("got column results");
		ArrayList colNamesList = new ArrayList();
		ArrayList colClassesList = new ArrayList();
		while (results.next()) {
			colNamesList.add (results.getString ("COLUMN_NAME"));
			System.out.println ("name: " +
				results.getString ("COLUMN_NAME"));
			int dbType = results.getInt ("DATA_TYPE");
			switch (dbType) {
			case Types.INTEGER:
		colClassesList.add (Integer.class); break;
			case Types.FLOAT:
		colClassesList.add (Float.class); break;
			case Types.DOUBLE:
			case Types.REAL:
		colClassesList.add (Double.class); break;
			case Types.DATE:
			case Types.TIME:
			case Types.TIMESTAMP:
		colClassesList.add (java.sql.Date.class); break;
			default:
		colClassesList.add (String.class); break;
			}
			System.out.println ("type: " +
				results.getInt ("DATA_TYPE"));
			}
			columnNames = new String [colNamesList.size()];
			colNamesList.toArray (columnNames);
			columnClasses = new Class [colClassesList.size()];
			colClassesList.toArray (columnClasses);

			// get all data from table and put into
			// contents array

			Statement statement =
		conn.createStatement ();
			results = statement.executeQuery ("SELECT * FROM " +
						  tableName);
			rowList = new ArrayList();
			while (results.next()) {
		ArrayList cellList = new ArrayList();
		for (int i = 0; i<columnClasses.length; i++) {
			Object cellValue = null;


			if (columnClasses[i] == String.class)
		cellValue = results.getString (columnNames[i]);
			else if (columnClasses[i] == Integer.class)
		cellValue = new Integer (
				results.getInt (columnNames[i]));
			else if (columnClasses[i] == Float.class)
		cellValue = new Float (
				results.getInt (columnNames[i]));
			else if (columnClasses[i] == Double.class)
		cellValue = new Double (
				results.getDouble (columnNames[i]));
			else if (columnClasses[i] == java.sql.Date.class)
		cellValue = results.getDate (columnNames[i]);
			else
		System.out.println ("Can't assign " +
				columnNames[i]);
			cellList.add (cellValue);
		}// for
		Object[] cells = cellList.toArray();
		rowList.add (cells);
	} // while
	// finally create contents two-dim array
	contents = new Object[rowList.size()] [];
	for (int i=0; i<contents.length; i++)

		contents[i] = (Object []) rowList.get (i);
	System.out.println ("Created model with " +
			   contents.length + " rows");

	// close stuff
	results.close();
	statement.close();

	}
	// AbstractTableModel methods
	public int getRowCount() {
		return contents.length;
	}

	public int getColumnCount() {
		if (contents.length == 0)
			return 0;
		else
			return contents[0].length;
		}

		public Object getValueAt (int row, int column) {
			return contents [row][column];
		}

		// overrides methods for which AbstractTableModel
		// has trivial implementations


		public Class getColumnClass (int col) {
			return columnClasses [col];
		}

		public String getColumnName (int col) {
			return columnNames [col];
		}
       [b] public void removeRow(int idx)
        {
            rowList.remove(idx);
            fireTableRowsDeleted(idx, idx);
        }[/b]
	}
  

i called it as actionPerformed on a JPopupMenu...

 

public void deleteRecord() throws SQLException {
        int i = studTable.getSelectedRow();
        JDBCTableModel mod= new JDBCTableModel(con,"student_db");
        mod.removeRow(i);
    }   

and it doesnt work...
i got these results...

Exception in thread "AWT-EventQueue-0" java.lang.Error: java.lang.reflect.InvocationTargetException
at org.jdesktop.application.ApplicationAction.actionFailed(ApplicationAction.java:859)
at org.jdesktop.application.ApplicationAction.noProxyActionPerformed(ApplicationAction.java:665)
at org.jdesktop.application.ApplicationAction.actionPerformed(ApplicationAction.java:698)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)

please help guys.... thanks in advance...

[Rob Camick]

Not really sure what you are doing but here is my standard solution:

Table From Database