ColumnSelector(Database)

Use the ColumnSelector bean colsel32.gif (303 bytes) to view a column in a TableModel such as a results set returned by Select or ProcedureCall beans.

CellSelector Properties

beanName
Specifies the name of the ColumnSelector bean instance. It must follow standard naming rules for beans. The default name is ColumnSelectorn, where n is the number of ColumnSelector beans with default names; for example, the first default name is ColumnSelector1.
columnName
Specifies the name of the column selected from the source TabelModel. The match on column name is not casr sensitive. If the specified column name is blank or null, the selected column will be identified by columnNumber.
columnNames
An array containing the names of the columns that are currently selected.
columnNumber
The index of the column to be selected from the source TableModel. This column index will only be used if the value of columnName is null or blank string.
includeColumnName
Whether the column name is to be included as the first element of column data. This only has effect when column data are retrieved as String values. The default is false.
indexFromOne
Whether the row and column indexes are assumed to index from one. This property should be set to true where the selection row and/or column properties are connected to a bean property that indexes from one. If set to false, indexing is from zero. The default is false.
maximumRow
The maximum number of rows to be selected. You can select NO_MAXIMUM to indicate that the last row of the selection should be the last row in the source TableModel. The default is NO_MAXIMUM.
model
The Java TableModel used as the source of the data for the selection.
notificationType
Specifies which data access property will be notified of changes by a propertyChange event. Selectors are able to convert source data into a variety of data types, each of which has a corresponding bound property. All of these properties are theoretically altered when the selector data source or selection criteria are changed. However, it would be very inefficient to generate property change events for all these properties, so the property of interest may be specified, limiting property change events to a single property.
startRowNumber
The index of the row to be selected from the source TableModel.
vectorContentType
The data type used to populate vectors in response to a vector property query. Some beans may require data be fed to them in a vector, and may further expect the elements in the vector to be of a specific type. Where this is the case, the notificationType property may be set to Selector.VECTOR to cause propertyChange events to be generated for the vector property.

The following are data access properties used by ColumnSelector bean for data conversion.

BigDecimal
A 1-dimensional array of java.math.BigDecimal data types.
BigInteger
A 1-dimensional array of java.math.BigInteger data types.
boolean
A 1-dimensional array of boolean data types.
byte
A 1-dimensional array of byte data types.
byte[]
A 1-dimensional array of byte array data types.
Date
A 1-dimensional array of java.sql.Date data types.
double
A 1-dimensional array of double data types.
float
A 1-dimensional array of float data types.
int
A 1-dimensional array of int data types.
long
A 1-dimensional array of long data types.
Object
A 1-dimensional array of Object data types.
short
A 1-dimensional array of short data types.
String
A 1-dimensional array of String data types.
Time
A 1-dimensional array of java.sql.Time data types.
Timestamp
A 1-dimensional array of java.sql.Timestamp data types.
Vector
A 1-dimensional array of Vector data types. The data type of the elements of the vector is controlled by the vectorContentType property.


Editing ColumnSelector Bean Properties
Using Selector Bean Data Access Properties


CellSelector
CellRangeSelector
RowSelector