CellRangeSelector(Database)
Use the CellRangeSelector bean
to view a 2-dimensional array from a
TableModel such as a result set returned by a Select or ProcedureCall bean.
CellSelector Properties
- beanName
- Specifies the name of the CellRangeSelector bean instance. It must follow standard
naming rules for beans. The default name is CellRangeSelectorn, where n
is the number of CellRangeSelector beans with default names; for example, the first
default name is CellRangeSelector1.
- columnNames
- An array containing the names of the columns that are currently selected.
- includeColumnNames
- 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.
- invertData
- Whether the data values are to be inverted row against column during retrieval from, or
update to, the source TableModel. The default orientation is row biased. Two dimensional
arrays will have one first level dimension for each row, and one second level dimension
for each column. When data is inverted, then this arrangement will be reversed. The default is false.
- maximumColumns
- The maximum number of columns to be selected. You can select NO_MAXIMUM to indicate that
the last column of the selection should be the last column in the source TableModel. The default is
NO_MAXIMUM.
- maximumRows
- 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. By
default, no property change events are generated.
- startColumnNumber
- The index of the column to start the selection from the source TableModel.
- startRowNumber
- The index of the row to start the selection 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 the CellRangeSelector bean for data conversion.
- BigDecimal
- A 2-dimensional array of java.math.BigDecimal data types.
- BigInteger
- A 2-dimensional array of java.math.BigInteger data types.
- boolean
- A 2-dimensional array of boolean data types.
- byte
- A 2-dimensional array of byte data types.
- byte[]
- A 2-dimensional array of byte array data types.
- Date
- A 2-dimensional array of java.sql.Date data types.
- double
- A 2-dimensional array of double data types.
- float
- A 2-dimensional array of float data types.
- int
- A 2-dimensional array of int data types.
- long
- A 2-dimensional array of long data types.
- Object
- A 2-dimensional array of Object data types.
- short
- A 2-dimensional array of short data types.
- String
- A 2-dimensional array of String data types.
- Time
- A 2-dimensional array of java.sql.Time data types.
- Timestamp
- A 2-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.
- VectorOfVectors
- A vector of Vector data types. The data type of the elements of the vector is controlled by the
vectorContentType property.

Editing CellRangeSelector Bean Properties
Using Selector Bean Data Access Properties

CellSelector
ColumnSelector
RowSelector
