HXTT's JDBC Packages Documentation

Welcome to the HXTT Access v5.1 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 Access packages. The basic example is used here.

Index:

Chapter 1. Quick Start

  1. What Is the HXTT Access?
  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. Database Level Encryption
  4. Bulk Insert
  5. Bulk Insert A ResultSet from any JDBC driver
  6. SELECT ... INTO OUTFILE Syntax
  7. Transaction Processing
  8. RowSet
  9. PooledConnection
  10. SSL Connection
  11. Run HXTT AccessServer as Windows Service or Linux(Solaris) Daemon
  12. DBAdmin (A GUI Dtabase Server Manager)
  13. How to Use Memory-only Table, Physical Table, Url table, Compressed table, SAMBA table in a SQL.
  14. Create Database from any java.io.InputStream object.
  15. Create Database from any compressed java.io.InputStream object.

Chapter 6. SQL Syntax

  1. Select
  2. Insert
  3. Update
  4. Delete
  5. CREATE CATALOG
  6. CREATE DATABASE
  7. DROP DATABASE
  8. TRUNCATE DATABASE
  9. PACK DATABASE
  10. CREATE TABLE
  11. DROP TABLE
  12. ALTER TABLE
  13. TRUNCATE TABLE
  14. PACK TABLE
  15. RENAME TABLE
  16. LOCK TABLE
  17. UNLOCK TABLE
  18. CREATE INDEX
  19. DROP INDEX
  20. REINDEX
  21. CREATE VIEW
  22. DROP VIEW
  23. CREATE SEQUENCE
  24. DROP SEQUENCE
  25. ALTER SEQUENCE
  26. SET TRANSACTION
  27. START TRANSACTION
  28. COMMIT
  29. ROLLBACK
  30. SAVEPOINT
  31. RELEASE SAVEPOINT
  32. Call Procedure
  33. Pseudo Tables
  34. Pseudo Columns
  35. Declare Variable
  36. SET Variable
  37. Comment Syntax
  38. 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. Regular Expresson Functions
  11. Miscellaneous Functions
  12. Aggregate Functions

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

  1. General Questions
  2. Applet Questions
  3. Remote Access Questions and Client/Server Mode Questions
  4. SQL Questions
  5. Index Questions
  6. Performance Questions
  7. Concurrence Questions
  8. Internationalization Questions
  9. Interoperability Questions

Chapter 9. OpenAPI Programming

  1. Extend SQL functions
  2. Start/Stop Server Programmatically with/without GUI manager
  3. Customer Connection
Copyright © 1999-2016 Hongxin Technology & Trade Ltd. | All Rights Reserved. |