| 摘要 |
A set of Java Beans for facilitating data extraction from a JDBC-ODBC database in an application is disclosed. The set of beans includes a database driver manager component, DbQuery, having a plurality of properties allowing an instance of said driver manager to identify a location of said database, to define a query on said database and to store a result of said database query, DbResultSet. The driver manager also exposes an execute method for connecting to the database, executing said query and setting said database query result property, DbResultSet. Also disclosed are 4 selector beans, DbCellSelector, DbRowSelector, DbColumnSelector and DbCellRangeSelector. Each selector has a plurality of properties allowing an instance of a selector component to store a result of a database query having a given data type and to identify a sub-set of said result.
|
