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 Json packages. The basic example is used here.

Index:

Chapter 1. Quick Start

1. What Is the HXTT Json?
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 JsonServer 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 INDEX
18. DROP INDEX
19. REINDEX
20. CREATE VIEW
21. DROP VIEW
22. CREATE SEQUENCE
23. DROP SEQUENCE
24. ALTER SEQUENCE
25. SET TRANSACTION
26. START TRANSACTION
27. COMMIT
28. ROLLBACK
29. SAVEPOINT
30. RELEASE SAVEPOINT
31. Call Procedure
32. EXPLAIN
33. Pseudo Tables
34. Pseudo Columns
35. Declare Variable
36. SET Variable
37. Common Table Expression
38. Comment Syntax
39. 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
13. Table Functions
14. ETL Functions

Chapter 8. Answers to Frequently Asked Questions (FAQ) for the HXTT Json 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. XPath for XML and JSON

1. XPath Introduction
2. XPath Syntax for XML and JSON
3. XPath Sample for XML and JSON

Chapter 11. JSON (JavaScript Object Notation) Support

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

Chapter 12. XML (eXtensible Markup Language) Support

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

Chapter 13. Array Type

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

Chapter 14. NoSQL (Not Only SQL)

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