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.

Recordset Class

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

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).

SQL Parser

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