JDBC
The AS/400 Toolbox for Java JDBC (Java Database Connectivity) driver allows Java programs to access AS/400 database files using standard JDBC interfaces.
Use these standard JDBC interfaces to issue SQL statements and process results.
JDBC is a standard part of Java and is included in JDK 1.1.
JDBC defines the following Java interfaces:
- The Driver interface creates the connection and returns information about the driver version.
- The Connection interface represents a connection to a specific database.
- The Statement interface runs SQL statements and obtains the results.
- The PreparedStatement interface runs compiled SQL statements.
- The CallableStatement interface runs SQL stored procedures.
- The ResultSet interface provides access to a table of data that is generated by running a SQL query or DatabaseMetaData catalog method.
- The DatabaseMetaData interface provides information about the database as a whole.
Examples
Using the JDBC driver to create and populate a table.
Using the JDBC driver to query a table and output its contents.
[ Legal | AS/400 Glossary ]
|