Database Utilities

The javaxt.sql package is used to connect to a databases, execute queries (SQL), view and update records, and browse database metadata. Here's a brief overview of some of the key classes found in the javaxt.sql package.

Connection Class

The Connection class is used primarily to open and close connections to a database. It is often used in conjunction with the Recordset Class to query, insert, and update records.

• Connection Class
• Connection Pooling
• JDBC Connection Pool Manager
• Connection Strings

Recordset Class

The Recordset class is used primary to execute queries and iterate through query results.

• Query, Insert, and Update Records

Database Class

The database class is used to encapsulate all of the information required to connect to a database. This class is often used in conjunction with the Connection Class. Once a connection to the database is opened, you can use this class to retrieve metadata (schema, primary keys, list of other databases, etc).

• Database Class
• How to View Table Metadata

SQL Parser

The SQL Parser is used to parse SQL Select statements and return the constituent parts.

• How to Parse an SQL Statement