|
HOME | |||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--javax.swing.table.AbstractTableModel | +--javax.swing.table.DefaultTableModel | +--com.ultraswing.DefaultSortableTableModel | +--com.ultraswing.ResultSetTableModel
A TableModel object which takes values from a JDBC ResultSet object.
Field Summary |
Fields inherited from class javax.swing.table.DefaultTableModel |
columnIdentifiers, dataVector |
Fields inherited from class javax.swing.table.AbstractTableModel |
listenerList |
Constructor Summary | |
ResultSetTableModel(ResultSet resultset)
Constructs a TableModel from a ResultSet. |
|
ResultSetTableModel(String driverClassName,
String url,
String query)
Constructs a ResultSetMetaData. |
|
ResultSetTableModel(String driverClassName,
String url,
String username,
String password,
String query)
Constructs a ResultSetMetaData. |
Method Summary | |
void |
close()
Closes the database resources |
protected void |
finalize()
|
Class |
getColumnClass(int column)
Returns the column Class |
int |
getColumnCount()
Returns number of columns |
String |
getColumnName(int column)
Returns the column name |
int |
getRowCount()
Returns the number of rows |
Object |
getValueAt(int row,
int column)
This is the key method of TableModel: it returns the value at each cell of the table. |
void |
setColumnName(int column,
String columnName)
This method should be called before this object is passed to table object. |
void |
setColumnNameMap(Map map)
This method should be called before this object is passed table object. |
void |
setSortByColumn(int column,
boolean ascending)
Sets the sorting order of colum |
void |
setValueAt(Object value,
int row,
int column)
Sets the object value for the cell at column and row. |
Methods inherited from class com.ultraswing.DefaultSortableTableModel |
getSortedColumnIndex, isAscending, isSortable |
Methods inherited from class javax.swing.table.DefaultTableModel |
addColumn, addColumn, addColumn, addRow, addRow, convertToVector, convertToVector, getDataVector, insertRow, insertRow, isCellEditable, moveRow, newDataAvailable, newRowsAdded, removeRow, rowsRemoved, setColumnCount, setColumnIdentifiers, setColumnIdentifiers, setDataVector, setDataVector, setNumRows, setRowCount |
Methods inherited from class javax.swing.table.AbstractTableModel |
addTableModelListener, findColumn, fireTableCellUpdated, fireTableChanged, fireTableDataChanged, fireTableRowsDeleted, fireTableRowsInserted, fireTableRowsUpdated, fireTableStructureChanged, getListeners, getTableModelListeners, removeTableModelListener |
Methods inherited from class java.lang.Object |
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface javax.swing.table.TableModel |
addTableModelListener, isCellEditable, removeTableModelListener |
Constructor Detail |
public ResultSetTableModel(String driverClassName, String url, String query) throws ClassNotFoundException, SQLException
query
driverClassName
- JDBC driver class nameurl
- a database url of the form jdbc:subprotocol:subnamequery
- an SQL statement to be sent to the database, typically a static SQL SELECT statement
ClassNotFoundException
- raised if JDBC driver classes are not found in class path
SQLException
- raised if SQL query can't be successfully excecutedpublic ResultSetTableModel(String driverClassName, String url, String username, String password, String query) throws ClassNotFoundException, SQLException
query
driverClassName
- JDBC driver class nameurl
- a database url of the form jdbc:subprotocol:subnameusername
- the database user on whose behalf the connection is being madepassword
- the user's passwordquery
- an SQL statement to be sent to the database, typically a static SQL SELECT statement
ClassNotFoundException
- raised if JDBC driver classes are not found in class path
SQLException
- raised if SQL query can't be successfully excecutedpublic ResultSetTableModel(ResultSet resultset) throws SQLException
Method Detail |
public void close()
protected void finalize()
finalize
in class Object
public int getColumnCount()
getColumnCount
in interface TableModel
getColumnCount
in class DefaultTableModel
public int getRowCount()
getRowCount
in interface TableModel
getRowCount
in class DefaultTableModel
public String getColumnName(int column)
getColumnName
in interface TableModel
getColumnName
in class DefaultTableModel
column
- column indexpublic void setColumnName(int column, String columnName)
public void setColumnNameMap(Map map)
public Class getColumnClass(int column)
Class
getColumnClass
in interface TableModel
getColumnClass
in class AbstractTableModel
column
- column indexpublic Object getValueAt(int row, int column)
getValueAt
in interface TableModel
getValueAt
in class DefaultTableModel
public void setValueAt(Object value, int row, int column)
setValueAt
in interface TableModel
setValueAt
in class DefaultTableModel
value
- the new value; this can be nullrow
- the row whose value is to be changedcolumn
- the column whose value is to be changedpublic void setSortByColumn(int column, boolean ascending)
colum
setSortByColumn
in interface SortableTableModel
setSortByColumn
in class DefaultSortableTableModel
column
- colum indexascending
- if true, sort the specified column into ascending order
|
HOME | |||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |