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.
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.
The Recordset class is used primary to execute queries and iterate through query results.
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).
The SQL Parser is used to parse SQL Select statements and return the