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 statements and return the
constituent parts.
|