HXTT's JDBC Packages Documentation

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

Index:

Chapter 1. Quick Start

  1. What Is the HXTT Excel?
  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. Encryption
  3. Bulk Insert
  4. Bulk Insert A ResultSet from any JDBC driver
  5. SELECT ... INTO OUTFILE Syntax
  6. Transaction Processing
  7. RowSet
  8. PooledConnection
  9. SSL Connection
  10. Run HXTT ExcelServer as Windows Service or Linux(Solaris) Daemon
  11. DBAdmin (A GUI Dtabase Server Manager)
  12. How to Use Memory-only Table, Physical Table, Url table, Compressed table, SAMBA table in a SQL.
  13. Create Database from any java.io.InputStream object.
  14. 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. FLUSH DATABASE
  9. CREATE TABLE
  10. DROP TABLE
  11. ALTER TABLE
  12. TRUNCATE TABLE
  13. PACK TABLE
  14. RENAME TABLE
  15. LOCK TABLE
  16. UNLOCK TABLE
  17. CREATE VIEW
  18. DROP VIEW
  19. CREATE SEQUENCE
  20. DROP SEQUENCE
  21. ALTER SEQUENCE
  22. SET TRANSACTION
  23. START TRANSACTION
  24. COMMIT
  25. ROLLBACK
  26. SAVEPOINT
  27. RELEASE SAVEPOINT
  28. Call Procedure
  29. Pseudo Tables
  30. Pseudo Columns
  31. Declare Variable
  32. SET Variable
  33. Comment Syntax
  34. 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 Excel packge

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

Chapter 9. OpenAPI Programming

  1. Extend SQL functions
  2. Start/Stop Server Programmatically with/without GUI manager
  3. Customer Connection

Chapter 10. JavaScript Object Notation (JSON) Support

  1. json and jsonb Operators
  2. JSON Functions
  3. JSON sample

Chapter 11. XML Type

  1. Declaration of XML Types
  2. XML Functions
  3. XML sample

Chapter 12. Array Type

  1. Declaration of Array Types
  2. Array Functions
  3. Array sample
Copyright © 2003-2018 Heng Xing Tian Tai Lab | All Rights Reserved. |