Difference between revisions of "MediaWiki:Collections/Developer's Guide - Database Access"
From Apache OpenOffice Wiki
Line 1: | Line 1: | ||
− | :[[Documentation/DevGuide/Database/Database Access]] | + | == OpenOffice.org Developer's Guide == |
+ | === Database Access === | ||
+ | :[[Documentation/DevGuide/Database/Database Access|Database Access]] | ||
+ | :[[Documentation/DevGuide/Database/Architecture|Architecture]] | ||
+ | :[[Documentation/DevGuide/Database/Example: Querying the Bibliography Database|Example: Querying the Bibliography Database]] | ||
+ | ;Data Sources in OpenOffice.org API | ||
+ | :[[Documentation/DevGuide/Database/Data Sources in OpenOffice.org API|Data Sources in OpenOffice.org API]] | ||
+ | :[[Documentation/DevGuide/Database/DataSources|DataSources]] | ||
+ | :[[Documentation/DevGuide/Database/The DataSource Service|The DataSource Service]] | ||
+ | :[[Documentation/DevGuide/Database/Queries|Queries]] | ||
+ | :[[Documentation/DevGuide/Database/Adding and Editing Predefined Queries|Adding and Editing Predefined Queries]] | ||
+ | :[[Documentation/DevGuide/Database/Runtime Settings For Predefined Queries|Runtime Settings For Predefined Queries]] | ||
+ | :[[Documentation/DevGuide/Database/The SingleSelectQueryComposer|The SingleSelectQueryComposer]] | ||
+ | :[[Documentation/DevGuide/Database/The SQLQueryComposer|The SQLQueryComposer]] | ||
+ | :[[Documentation/DevGuide/Database/Forms and Reports|Forms and Reports]] | ||
+ | :[[Documentation/DevGuide/Database/Document Links|Document Links]] | ||
+ | :[[Documentation/DevGuide/Database/Tables and Columns|Tables and Columns]] | ||
+ | :[[Documentation/DevGuide/Database/Connections|Connections]] | ||
+ | :[[Documentation/DevGuide/Database/Connecting Through a DataSource|Connecting Through a DataSource]] | ||
+ | :[[Documentation/DevGuide/Database/Connecting Using the DriverManager and a Database URL|Connecting Using the DriverManager and a Database URL]] | ||
+ | :[[Documentation/DevGuide/Database/Connecting Through a Specific Driver|Connecting Through a Specific Driver]] | ||
+ | :[[Documentation/DevGuide/Database/Driver Specifics|Driver Specifics]] | ||
+ | :[[Documentation/DevGuide/Database/The SDBC Driver for JDBC|The SDBC Driver for JDBC]] | ||
+ | :[[Documentation/DevGuide/Database/The SDBC Driver for ODBC|The SDBC Driver for ODBC]] | ||
+ | :[[Documentation/DevGuide/Database/The SDBC Driver for Adabas D|The SDBC Driver for Adabas D]] | ||
+ | :[[Documentation/DevGuide/Database/The SDBC Driver for ADO|The SDBC Driver for ADO]] | ||
+ | :[[Documentation/DevGuide/Database/The SDBC Driver for dBase|The SDBC Driver for dBase]] | ||
+ | :[[Documentation/DevGuide/Database/The SDBC Driver for Flat File Formats|The SDBC Driver for Flat File Formats]] | ||
+ | :[[Documentation/DevGuide/Database/The SDBC Driver for OpenOffice.org Calc Files|The SDBC Driver for OpenOffice.org Calc Files]] | ||
+ | :[[Documentation/DevGuide/Database/The SDBC Driver for address books|The SDBC Driver for address books]] | ||
+ | :[[Documentation/DevGuide/Database/The SDBC Driver for embedded HSQL databases|The SDBC Driver for embedded HSQL databases]] | ||
+ | :[[Documentation/DevGuide/Database/Connection Pooling|Connection Pooling]] | ||
+ | :[[Documentation/DevGuide/Database/Piggyback Connections|Piggyback Connections]] | ||
+ | ;Manipulating the Data | ||
+ | :[[Documentation/DevGuide/Database/Manipulating the Data|Manipulating the Data]] | ||
+ | :[[Documentation/DevGuide/Database/The RowSet Service|The RowSet Service]] | ||
+ | :[[Documentation/DevGuide/Database/Usage|Usage]] | ||
+ | :[[Documentation/DevGuide/Database/Events and Other Notifications|Events and Other Notifications]] | ||
+ | :[[Documentation/DevGuide/Database/Clones of the RowSet Service|Clones of the RowSet Service]] | ||
+ | :[[Documentation/DevGuide/Database/Statements|Statements]] | ||
+ | :[[Documentation/DevGuide/Database/Creating Statements|Creating Statements]] | ||
+ | :[[Documentation/DevGuide/Database/Inserting and Updating Data|Inserting and Updating Data]] | ||
+ | :[[Documentation/DevGuide/Database/Getting Data from a Table|Getting Data from a Table]] | ||
+ | :[[Documentation/DevGuide/Database/Result Sets|Result Sets]] | ||
+ | :[[Documentation/DevGuide/Database/Retrieving Values from Result Sets|Retrieving Values from Result Sets]] | ||
+ | :[[Documentation/DevGuide/Database/Moving the Result Set Cursor|Moving the Result Set Cursor]] | ||
+ | :[[Documentation/DevGuide/Database/Using the getXXX Methods|Using the getXXX Methods]] | ||
+ | :[[Documentation/DevGuide/Database/Scrollable Result Sets|Scrollable Result Sets]] | ||
+ | :[[Documentation/DevGuide/Database/Modifiable Result Sets|Modifiable Result Sets]] | ||
+ | :[[Documentation/DevGuide/Database/Update|Update]] | ||
+ | :[[Documentation/DevGuide/Database/Insert|Insert]] | ||
+ | :[[Documentation/DevGuide/Database/Delete|Delete]] | ||
+ | :[[Documentation/DevGuide/Database/Seeing Changes in Result Sets|Seeing Changes in Result Sets]] | ||
+ | :[[Documentation/DevGuide/Database/ResultSetMetaData|ResultSetMetaData]] | ||
+ | :[[Documentation/DevGuide/Database/Using Prepared Statements|Using Prepared Statements]] | ||
+ | :[[Documentation/DevGuide/Database/PreparedStatement From DataSource Queries|PreparedStatement From DataSource Queries]] | ||
+ | ;Database Design | ||
+ | :[[Documentation/DevGuide/Database/Database Design|Database Design]] | ||
+ | :[[Documentation/DevGuide/Database/Using DDL to Change the Database Design|Using DDL to Change the Database Design]] | ||
+ | :[[Documentation/DevGuide/Database/Using SDBCX to Access the Database Design|Using SDBCX to Access the Database Design]] | ||
+ | :[[Documentation/DevGuide/Database/Catalog Service|Catalog Service]] | ||
+ | :[[Documentation/DevGuide/Database/Table Service|Table Service]] | ||
+ | :[[Documentation/DevGuide/Database/Column Service|Column Service]] | ||
+ | :[[Documentation/DevGuide/Database/Index Service|Index Service]] | ||
+ | :[[Documentation/DevGuide/Database/Key Service|Key Service]] | ||
+ | :[[Documentation/DevGuide/Database/View Service|View Service]] | ||
+ | :[[Documentation/DevGuide/Database/Group Service|Group Service]] | ||
+ | :[[Documentation/DevGuide/Database/User Service|User Service]] | ||
+ | :[[Documentation/DevGuide/Database/The Descriptor Pattern|The Descriptor Pattern]] | ||
+ | :[[Documentation/DevGuide/Database/Adding an Index|Adding an Index]] | ||
+ | :[[Documentation/DevGuide/Database/Creating a User|Creating a User]] | ||
+ | :[[Documentation/DevGuide/Database/Adding a Group|Adding a Group]] | ||
+ | ;Using DBMS Features | ||
+ | :[[Documentation/DevGuide/Database/Using DBMS Features|Using DBMS Features]] | ||
+ | :[[Documentation/DevGuide/Database/Stored Procedures|Stored Procedures]] | ||
+ | ;Writing Database Drivers | ||
+ | :[[Documentation/DevGuide/Database/Writing Database Drivers|Writing Database Drivers]] | ||
+ | :[[Documentation/DevGuide/Database/SDBC Driver|SDBC Driver]] | ||
+ | :[[Documentation/DevGuide/Database/Driver Service|Driver Service]] | ||
+ | :[[Documentation/DevGuide/Database/Connection Service|Connection Service]] | ||
+ | :[[Documentation/DevGuide/Database/XDatabaseMetaData Interface|XDatabaseMetaData Interface]] | ||
+ | :[[Documentation/DevGuide/Database/Driver Statements|Statements]] | ||
+ | :[[Documentation/DevGuide/Database/Support Scalar Functions|Support Scalar Functions]] | ||
+ | :[[Documentation/DevGuide/Database/Open Group CLI Numeric Functions|Open Group CLI Numeric Functions]] | ||
+ | :[[Documentation/DevGuide/Database/Open Group CLI String Functions|Open Group CLI String Functions]] | ||
+ | :[[Documentation/DevGuide/Database/Open Group CLI Time and Date Functions|Open Group CLI Time and Date Functions]] | ||
+ | :[[Documentation/DevGuide/Database/Open Group CLI System Functions|Open Group CLI System Functions]] | ||
+ | :[[Documentation/DevGuide/Database/Open Group CLI Conversion Functions|Open Group CLI Conversion Functions]] | ||
+ | :[[Documentation/DevGuide/Database/Handling Unsupported Functionality|Handling Unsupported Functionality]] | ||
[[Category:Collections]] | [[Category:Collections]] |
Revision as of 11:29, 23 January 2009
OpenOffice.org Developer's Guide
Database Access
- Database Access
- Architecture
- Example: Querying the Bibliography Database
- Data Sources in OpenOffice.org API
- Data Sources in OpenOffice.org API
- DataSources
- The DataSource Service
- Queries
- Adding and Editing Predefined Queries
- Runtime Settings For Predefined Queries
- The SingleSelectQueryComposer
- The SQLQueryComposer
- Forms and Reports
- Document Links
- Tables and Columns
- Connections
- Connecting Through a DataSource
- Connecting Using the DriverManager and a Database URL
- Connecting Through a Specific Driver
- Driver Specifics
- The SDBC Driver for JDBC
- The SDBC Driver for ODBC
- The SDBC Driver for Adabas D
- The SDBC Driver for ADO
- The SDBC Driver for dBase
- The SDBC Driver for Flat File Formats
- The SDBC Driver for OpenOffice.org Calc Files
- The SDBC Driver for address books
- The SDBC Driver for embedded HSQL databases
- Connection Pooling
- Piggyback Connections
- Manipulating the Data
- Manipulating the Data
- The RowSet Service
- Usage
- Events and Other Notifications
- Clones of the RowSet Service
- Statements
- Creating Statements
- Inserting and Updating Data
- Getting Data from a Table
- Result Sets
- Retrieving Values from Result Sets
- Moving the Result Set Cursor
- Using the getXXX Methods
- Scrollable Result Sets
- Modifiable Result Sets
- Update
- Insert
- Delete
- Seeing Changes in Result Sets
- ResultSetMetaData
- Using Prepared Statements
- PreparedStatement From DataSource Queries
- Database Design
- Database Design
- Using DDL to Change the Database Design
- Using SDBCX to Access the Database Design
- Catalog Service
- Table Service
- Column Service
- Index Service
- Key Service
- View Service
- Group Service
- User Service
- The Descriptor Pattern
- Adding an Index
- Creating a User
- Adding a Group
- Using DBMS Features
- Using DBMS Features
- Stored Procedures
- Writing Database Drivers
- Writing Database Drivers
- SDBC Driver
- Driver Service
- Connection Service
- XDatabaseMetaData Interface
- Statements
- Support Scalar Functions
- Open Group CLI Numeric Functions
- Open Group CLI String Functions
- Open Group CLI Time and Date Functions
- Open Group CLI System Functions
- Open Group CLI Conversion Functions
- Handling Unsupported Functionality