ColumnSelector(Database)
Use the ColumnSelector bean
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
