HXTT's JDBC Packages Documentation

Current documentation can be found here. This documentation is not intended as a complete guide to JDBC programming, but should help to get you started. For more information, refer to the standard JDBC API documentation(supplied with Sun's JDK). Also, take a look at the examples included with the HXTT DBF packages. The basic example is used here.

Index:

Chapter 1. Quick Start

1. What Is the HXTT DBF?
2. Follow Me

Chapter 2. Installation

1. System Requirements
2. Setting the CLASSPATH
3. Loading the Driver
4. Connecting to the Database

Chapter 3. Statement

1. Creating a Statement Instance
2. Issuing a Query
3. Performing Updates
4. Creating and Modifying Database Objects

Chapter 4. ResultSet

1. ResultSet Overview
2. Providing Performance Hints
3. Performing Updates
4. Serializing ResultSet

Chapter 5. Advanced Programming

1. Sending Very Large IN Parameters
2. Set Record Lock Manually
3. Table Level Encryption
4. Bulk Insert
5. Bulk Insert A ResultSet from any JDBC driver
6. Extend SQL functions
7. DBAdmin (A GUI Dtabase Server Manager)
8. Transaction Processing
9. RowSet

Chapter 6. SQL Syntax

1. Select
2. ? Expression
3. Insert
4. Update
5. Delete
6. CREATE SCHEMA
7. CREATE TABLE
8. DROP TABLE
9. ALTER TABLE
10. TRUNCATE TABLE
11. PACK TABLE
12. RENAME TABLE
13. CREATE INDEX
14. DROP INDEX
15. REINDEX
16. CREATE SEQUENCE
17. DROP SEQUENCE
18. ALTER SEQUENCE
19. SET TRANSACTION
20. START TRANSACTION
21. COMMIT
22. ROLLBACK
23. SAVEPOINT
24. RELEASE SAVEPOINT
25. Comment Syntax
26. SQL States

Chapter 7. Scalar Functions and Aggregate Functions

1. Mathematical Functions
2. Trigonometric Functions
3. String Functions
4. Date/Time Functions
5. Boolean Functions
6. System Functions
7. Conversion Functions
8. Security Functions
9. Sequence Functions
10. Miscellaneous Functions
11. Aggregate Functions

Chapter 8. Answers to Frequently Asked Questions (FAQ) for the HXTT DBF packge

1. General Questions
2. Applet Questions
3. Remote Access Questions
4. SQL Questions
5. Index Questions
6. Performance Questions
7. Concurrence Questions
8. Internationalization Questions
9. Interoperability Questions
10. Compatible Questions