public interface DatastoreInterface
extends java.io.Serializable
Description:数据集接口
Company:首亨软件(重庆)有限公司
限定符和类型 | 字段和说明 |
---|---|
static int |
BIGINT |
static int |
BLOB |
static int |
CLOB |
static int |
DATAMODIFYED |
static int |
DATATYPE_UNDEFINE
七种数据类型
|
static int |
DATE |
static int |
DELETE |
static int |
DOUBLE |
static int |
FILTER |
static int |
FLOAT |
static int |
INTEGER |
static int |
NEW |
static int |
NEWMODIFYED |
static int |
NOTMODIFYED
四种状态 NOTMODIFYED 无修改 DATAMODIFYED 数据已修改 NEW 新插入 NEWMODIFYED 新插入,且写入数据
|
static int |
OBJECT |
static int |
PRIMARY
三个缓冲区 PRIMARY 缓冲区:存放当前操作的数据。
|
static int |
STRING |
static int |
TIME |
static int |
TIMESTAMP |
限定符和类型 | 方法和说明 |
---|---|
int |
columnCount()
返回PRIMARY缓冲区内数据总列数。
|
boolean |
deleteRow(int row)
删除指定行数据。
|
int |
filter()
在PRIMARY缓冲区保存满足当前过滤条件的行; 不满足过滤条件的行,从PRIMARY 缓冲区移动到FILTER缓冲区。
|
int |
filteredCount()
返回FILTER缓冲区行数。
|
int |
find(java.lang.String expression,
int start,
int end)
在指定范围内查找满足条件的第一个数据行的行号。
|
java.lang.String |
getColumnName(int index)
获取列名,返回PRIMARY缓冲区指定列索引的列名。
|
int |
getColumnType(int index)
取得列的数据类型,返回PRIMARY缓冲区指定索引(列名)的数据类型。
|
int |
getColumnType(java.lang.String column) |
java.sql.Date |
getItemDate(int row,
int column) |
java.sql.Date |
getItemDate(int row,
int column,
int buffer,
boolean originalvalue) |
java.sql.Date |
getItemDate(int row,
java.lang.String column) |
java.sql.Date |
getItemDate(int row,
java.lang.String column,
int buffer,
boolean originalvalue) |
java.lang.Double |
getItemDouble(int row,
int column) |
java.lang.Double |
getItemDouble(int row,
int column,
int buffer,
boolean originalvalue) |
java.lang.Double |
getItemDouble(int row,
java.lang.String column) |
java.lang.Double |
getItemDouble(int row,
java.lang.String column,
int buffer,
boolean originalvalue) |
java.lang.Double |
getItemDoubleEx(int row,
int column) |
java.lang.Double |
getItemDoubleEx(int row,
java.lang.String column) |
java.lang.Float |
getItemFloat(int row,
int column) |
java.lang.Float |
getItemFloat(int row,
int column,
int buffer,
boolean originalvalue) |
java.lang.Float |
getItemFloat(int row,
java.lang.String column) |
java.lang.Float |
getItemFloat(int row,
java.lang.String column,
int buffer,
boolean originalvalue) |
java.lang.Integer |
getItemInteger(int row,
int column) |
java.lang.Integer |
getItemInteger(int row,
int column,
int buffer,
boolean originalvalue) |
java.lang.Integer |
getItemInteger(int row,
java.lang.String column) |
java.lang.Integer |
getItemInteger(int row,
java.lang.String column,
int buffer,
boolean originalvalue) |
int |
getItemStatus(int row,
int column)
取得PRIMARY缓冲区指定行列的状态。
|
int |
getItemStatus(int row,
int column,
int dwbuffer)
取得指定缓冲区指定行列的状态。
|
int |
getItemStatus(int row,
java.lang.String column) |
int |
getItemStatus(int row,
java.lang.String column,
int dwbuffer) |
java.lang.String |
getItemString(int row,
int column) |
java.lang.String |
getItemString(int row,
int column,
int buffer,
boolean originalvalue) |
java.lang.String |
getItemString(int row,
java.lang.String column) |
java.lang.String |
getItemString(int row,
java.lang.String column,
int buffer,
boolean originalvalue) |
java.sql.Time |
getItemTime(int row,
int column) |
java.sql.Time |
getItemTime(int row,
int column,
int buffer,
boolean originalvalue) |
java.sql.Time |
getItemTime(int row,
java.lang.String column) |
java.sql.Time |
getItemTime(int row,
java.lang.String column,
int buffer,
boolean originalvalue) |
java.sql.Timestamp |
getItemTimestamp(int row,
int column) |
java.sql.Timestamp |
getItemTimestamp(int row,
int column,
int buffer,
boolean originalvalue) |
java.sql.Timestamp |
getItemTimestamp(int row,
java.lang.String column) |
java.sql.Timestamp |
getItemTimestamp(int row,
java.lang.String column,
int buffer,
boolean originalvalue) |
java.lang.String |
getLabel(int index) |
java.lang.String |
getLabel(java.lang.String column) |
java.lang.Object |
getObject(int row,
int column)
功能:下列函数从数据存储中获取指定行列、指定缓冲区的数据值。
|
java.lang.Object |
getObject(int row,
int column,
int buffer,
boolean originalvalue) |
java.lang.Object |
getObject(int row,
java.lang.String column) |
java.lang.Object |
getObject(int row,
java.lang.String column,
int buffer,
boolean originalvalue) |
RowInfo |
getRowInfo(int row)
获取指定行对象(拷贝) row : 行号 成功返回RowInfo对象,失败返回null.
|
RowInfo |
getRowInfo(int row,
int buffer) |
RowInfo |
getRowInfoRef(int row)
获取指定行对象(引用) row : 行号
|
RowInfo |
getRowInfoRef(int row,
int buffer) |
int |
insertRow(int row)
在指定行插入数据。
|
boolean |
isPrimaryKey(int index) |
boolean |
isPrimaryKey(java.lang.String column) |
boolean |
isVisible(int column)
获取指定列是否可见
|
boolean |
isVisible(java.lang.String column) |
boolean |
reset()
清空所有缓冲区内的数据。
|
int |
rowCount()
行统计,返回PRIMARY缓冲区内数据总行数。
|
boolean |
rowsMove(int startrow,
int endrow,
int movebuffer,
int beforerow,
int targetbuffer)
在三个缓冲区内移动一行或多行数据。
|
boolean |
setFilter(java.lang.String format)
检索数据,参数sql为标准SQL语句。
|
int |
setItem(int row,
int column,
java.sql.Date value) |
int |
setItem(int row,
int column,
java.lang.Double value) |
int |
setItem(int row,
int column,
java.lang.Float value) |
int |
setItem(int row,
int column,
java.lang.Integer value) |
int |
setItem(int row,
int column,
java.lang.String value) |
int |
setItem(int row,
int column,
java.sql.Time value) |
int |
setItem(int row,
int column,
java.sql.Timestamp value) |
int |
setItem(int row,
java.lang.String column,
java.sql.Date value) |
int |
setItem(int row,
java.lang.String column,
java.lang.Double value) |
int |
setItem(int row,
java.lang.String column,
java.lang.Float value) |
int |
setItem(int row,
java.lang.String column,
java.lang.Integer value) |
int |
setItem(int row,
java.lang.String column,
java.lang.String value) |
int |
setItem(int row,
java.lang.String column,
java.sql.Time value) |
int |
setItem(int row,
java.lang.String column,
java.sql.Timestamp value) |
boolean |
setItemStatus(int row,
int column,
int status)
设置PRIMARY缓冲区指定行列的状态。
|
boolean |
setItemStatus(int row,
int column,
int dwbuffer,
int status)
设置指定缓冲区指定行列的状态。
|
boolean |
setItemStatus(int row,
java.lang.String column,
int status) |
boolean |
setItemStatus(int row,
java.lang.String column,
int dwbuffer,
int status) |
int |
setObject(int row,
int column,
java.lang.Object value)
功能:下列函数设置数据存储中指定行列的数据值。
|
int |
setObject(int row,
java.lang.String column,
java.lang.Object value) |
boolean |
setSort(java.lang.String format)
排序,定义PRIMARY缓冲区排序条件。
|
void |
setVisible(int column,
boolean visible)
设置指定列是否可见
|
void |
setVisible(java.lang.String column,
boolean visible) |
boolean |
sort()
按排序条件排序,成功返回true,错误抛出sortException异常
|
static final int PRIMARY
static final int FILTER
static final int DELETE
static final int NOTMODIFYED
static final int DATAMODIFYED
static final int NEW
static final int NEWMODIFYED
static final int DATATYPE_UNDEFINE
static final int INTEGER
static final int BIGINT
static final int FLOAT
static final int DOUBLE
static final int STRING
static final int DATE
static final int TIME
static final int TIMESTAMP
static final int BLOB
static final int CLOB
static final int OBJECT
boolean setFilter(java.lang.String format)
format
- 过滤表达式int filter() throws FilterException
FilterException
- FilterExceptionint filteredCount()
boolean setSort(java.lang.String format)
format
- 排序表达式boolean sort() throws SortException
SortException
- SortExceptionint find(java.lang.String expression, int start, int end) throws FindException
expression
- 表达式start
- 开始行end
- 结束行FindException
- FindExceptionint rowCount()
int columnCount()
java.lang.String getColumnName(int index) throws InvalidRowColException
index
- 列号InvalidRowColException
- InvalidRowColExceptionint getColumnType(int index) throws InvalidRowColException
index
- 列号InvalidRowColException
- InvalidRowColExceptionint getColumnType(java.lang.String column) throws InvalidRowColException
boolean setItemStatus(int row, int column, int dwbuffer, int status) throws InvalidRowColException
row
- 行号column
- 列号dwbuffer
- intstatus
- 状态InvalidRowColException
- InvalidRowColExceptionboolean setItemStatus(int row, java.lang.String column, int dwbuffer, int status) throws InvalidRowColException
int getItemStatus(int row, int column, int dwbuffer) throws InvalidRowColException
row
- 行号column
- 列号dwbuffer
- intInvalidRowColException
- InvalidRowColExceptionint getItemStatus(int row, java.lang.String column, int dwbuffer) throws InvalidRowColException
boolean setItemStatus(int row, int column, int status) throws InvalidRowColException
row
- 行号column
- 列号status
- 状态InvalidRowColException
- InvalidRowColExceptionboolean setItemStatus(int row, java.lang.String column, int status) throws InvalidRowColException
int getItemStatus(int row, int column) throws InvalidRowColException
row
- 行号column
- 列号InvalidRowColException
- InvalidRowColExceptionint getItemStatus(int row, java.lang.String column) throws InvalidRowColException
boolean reset()
int insertRow(int row)
row
- 行号boolean deleteRow(int row)
row
- 行号boolean rowsMove(int startrow, int endrow, int movebuffer, int beforerow, int targetbuffer)
startrow
- 开始行endrow
- 结束行movebuffer
- 移动缓冲beforerow
- inttargetbuffer
- intjava.lang.Object getObject(int row, int column) throws InvalidRowColException
row
- 行号column
- 列号InvalidRowColException
- InvalidRowColExceptionjava.lang.Object getObject(int row, int column, int buffer, boolean originalvalue) throws InvalidRowColException
java.lang.Object getObject(int row, java.lang.String column) throws InvalidRowColException
java.lang.Object getObject(int row, java.lang.String column, int buffer, boolean originalvalue) throws InvalidRowColException
java.sql.Date getItemDate(int row, int column) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Date getItemDate(int row, int column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Date getItemDate(int row, java.lang.String column) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Date getItemDate(int row, java.lang.String column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Time getItemTime(int row, int column) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Time getItemTime(int row, int column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Time getItemTime(int row, java.lang.String column) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Time getItemTime(int row, java.lang.String column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Timestamp getItemTimestamp(int row, int column) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Timestamp getItemTimestamp(int row, int column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Timestamp getItemTimestamp(int row, java.lang.String column) throws InvalidRowColException, ColumnTypeNotMatchException
java.sql.Timestamp getItemTimestamp(int row, java.lang.String column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Integer getItemInteger(int row, int column) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Integer getItemInteger(int row, int column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Integer getItemInteger(int row, java.lang.String column) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Integer getItemInteger(int row, java.lang.String column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Float getItemFloat(int row, int column) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Float getItemFloat(int row, int column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Float getItemFloat(int row, java.lang.String column) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Float getItemFloat(int row, java.lang.String column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Double getItemDoubleEx(int row, int column) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Double getItemDouble(int row, int column) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Double getItemDouble(int row, int column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Double getItemDoubleEx(int row, java.lang.String column) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Double getItemDouble(int row, java.lang.String column) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.Double getItemDouble(int row, java.lang.String column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.String getItemString(int row, int column) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.String getItemString(int row, int column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.String getItemString(int row, java.lang.String column) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.String getItemString(int row, java.lang.String column, int buffer, boolean originalvalue) throws InvalidRowColException, ColumnTypeNotMatchException
int setObject(int row, int column, java.lang.Object value) throws InvalidRowColException, ColumnTypeNotMatchException
row
- 行号column
- 列号value
- 值InvalidRowColException
- InvalidRowColExceptionColumnTypeNotMatchException
- ColumnTypeNotMatchExceptionint setObject(int row, java.lang.String column, java.lang.Object value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, int column, java.sql.Date value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, int column, java.sql.Time value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, int column, java.sql.Timestamp value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, int column, java.lang.Double value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, int column, java.lang.Float value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, int column, java.lang.Integer value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, int column, java.lang.String value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, java.lang.String column, java.sql.Date value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, java.lang.String column, java.sql.Time value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, java.lang.String column, java.sql.Timestamp value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, java.lang.String column, java.lang.Double value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, java.lang.String column, java.lang.Float value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, java.lang.String column, java.lang.Integer value) throws InvalidRowColException, ColumnTypeNotMatchException
int setItem(int row, java.lang.String column, java.lang.String value) throws InvalidRowColException, ColumnTypeNotMatchException
java.lang.String getLabel(int index) throws InvalidRowColException
java.lang.String getLabel(java.lang.String column) throws InvalidRowColException
boolean isPrimaryKey(int index) throws InvalidRowColException
boolean isPrimaryKey(java.lang.String column) throws InvalidRowColException
RowInfo getRowInfo(int row) throws InvalidRowColException
row
- 行号InvalidRowColException
- InvalidRowColExceptionRowInfo getRowInfo(int row, int buffer) throws InvalidRowColException
RowInfo getRowInfoRef(int row) throws InvalidRowColException
row
- 行号InvalidRowColException
- InvalidRowColExceptionRowInfo getRowInfoRef(int row, int buffer) throws InvalidRowColException
void setVisible(int column, boolean visible) throws InvalidRowColException
column
- 列号visible
- 是否可见InvalidRowColException
- InvalidRowColExceptionvoid setVisible(java.lang.String column, boolean visible) throws InvalidRowColException
boolean isVisible(int column) throws InvalidRowColException
column
- 列号InvalidRowColException
- InvalidRowColExceptionboolean isVisible(java.lang.String column) throws InvalidRowColException