| Home >> All >> postgresql >> [ jdbc1 Javadoc ] |
• postgresql.jdbc1: Javadoc index of package postgresql.jdbc1.
Package Samples:
• postgresql.jdbc1
Classes:
• ResultSet: A ResultSet provides access to a table of data generated by executing a Statement. The table rows are retrieved in sequence. Within a row its column values can be accessed in any order. A ResultSet maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The 'next' method moves the cursor to the next row. The getXXX methods retrieve column values for the current row. You can retrieve values either using the index number of the column, or by using the name of the column. In general using the column index will be more efficient. Columns are ...
• CallableStatement: CallableStatement is used to execute SQL stored procedures. JDBC provides a stored procedure SQL escape that allows stored procedures to be called in a standard way for all RDBMS's. This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. The other parameters may be used for input, output or both. Parameters are refered to sequentially, by number. The first parameter is 1. {?= call [ , , ...]} {call [ , , ...]} IN parameter values are set using the set methods inherited from PreparedStatement. The ...
• DatabaseMetaData: This class provides information about the database as a whole. Many of the methods here return lists of information in ResultSets. You can use the normal ResultSet methods such as getString and getInt to retrieve the data from these ResultSets. If a given form of metadata is not available, these methods should throw a SQLException. Some of these methods take arguments that are String patterns. These arguments all have names such as fooPattern. Within a pattern String, "%" means match any substring of 0 or more characters, and "_" means match any one character. Only metadata entries matching the ...
• Connection: $Id: Connection.java,v 1.1.1.1 2002/01/22 08:52:52 synmscott Exp $ A Connection represents a session with a specific database. Within the context of a Connection, SQL statements are executed and results are returned. A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, etc. This information is obtained with the getMetaData method. Note: By default, the Connection automatically commits changes after executing each statement. If auto-commit has been disabled, an explicit commit must be ...
• PreparedStatement: A SQL Statement is pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times. Note: The setXXX methods for setting IN parameter values must specify types that are compatible with the defined SQL type of the input parameter. For instance, if the IN parameter has SQL type Integer, then setInt should be used. If arbitrary parameter type conversions are required, then the setObject method should be used with a target SQL type.
• Statement: A Statement object is used for executing a static SQL statement and obtaining the results produced by it. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. All statement execute methods implicitly close a statement's current ResultSet if an open one exists.
• ResultSetMetaData: A ResultSetMetaData object can be used to find out about the types and properties of the columns in a ResultSet
| Home | Contact Us | Privacy Policy | Terms of Service |