Servertec | JDBC

Content Introduction Release Notes Features FAQs Requirements Installation Change Log Future Plans Knowledge Base Reference Manual Conventions Scriptlets Data Types Constants Variables Procedures Operators Statements Objects Array Config Context Cookie Date Enumeration File FileDescriptor Hashtable Internet IO JDBC clearParameters( ) clearWarnings( ) close( ) commit( ) createStatement( ) execute( ) executeQuery( ) executeUpdate( ) findColumn( ) getAutoCommit( ) getColumnCount( ) getColumnName( ) getColumnType( ) getColumnType Name( ) getConnection( ) getDate( ) getDouble( ) getInt( ) getInteger( ) getLong( ) getMaxRows( ) getMetaData( ) getMoreResults( ) getNextWarning( ) getPrecision( ) getResultSet( ) getScale( ) getSchemaName( ) getString( ) getTableName( ) getTransaction Isolation( ) getUpdateCount( ) getWarnings( ) isCaseSensitive( ) isClosed( ) isDefinitelyWritable( ) isNullable( ) isReadOnly( ) isSearchable( ) isSigned( ) isWritable( ) loadDriver( ) next( ) prepareCall( ) prepareStatement( ) registerOut Parameter( ) rollback( ) setAutoCommit( ) setCursorName( ) setDate( ) setDouble( ) setInt( ) setInteger( ) setLong( ) setMaxRows( ) setNull( ) setReadOnly( ) setString( ) setTransaction Isolation( ) _TRANSACTION _NONE( ) _TRANSACTION _READ _COMMITTED( ) _TRANSACTION _READ _UNCOMMITTED( ) _TRANSACTION _REPEATABLE _READ( ) _TRANSACTION _SERIALIZABLE( ) wasNull( ) Number Object Properties Random Request RequestDispatcher Response Session SqlTypes Stack StreamTokenizer String StringBuffer StringTokenizer System Vector Wrappers Servlet Server Pages Preprocessor Executable Samples Legal Contact Us |
Provides database connectivity.
Method | Description
clearParameters( ) | Clears set parameters on the specified prepared statement object.
clearWarnings( ) | Clears any sql warning objects on the specified connection, result set or statement object.
close( ) | Used to close a connection, result set or statement object.
commit( ) | Makes changes to the database permanent for the specified connection object.
createStatement( ) | Returns a statement object on the specified connection object.
execute( ) | Returns a result set object using the specified prepared statement or statement object.
executeQuery( ) | Returns a result set object using the specified statement or prepared statement object and SQL SELECT statement.
executeUpdate( ) | Returns a result set object using the specified statement or prepared statement object and SQL INSERT, UPDATE or DELETE statement.
findColumn( ) | Returns the given column's index for the specified result set object.
getAutoCommit( ) | Returns whether the specified connection object is in auto-commit mode.
getColumnCount( ) | Returns the number of columns in the specified meta data result set object.
getColumnName( ) | Returns the name of column for the given column index in the specified meta data result set object.
getColumnType( ) | Returns the column's type for the given column index in the specified meta data result set object.
getColumnTypeName( ) | Returns the column's type name for the given column index in the specified meta data result set object.
getConnection( ) | Returns a connection object to the given database URL.
getDate( ) | Returns a date object for the named column in the given result set or callable statement object.
getDouble( ) | Returns a real value for the named column in the specified result set callable statement object.
getInt( ) | Returns a whole number for the named column in the specified result set callable statement object.
getInteger( ) | Returns a whole number for the named column in the specified result set callable statement object.
getLong( ) | Returns a whole number for the named column in the specified result set callable statement object.
getMaxRows( ) | Returns the maximum number of rows a result set object can contain for the specified statement object.
getMetaData( ) | Returns the meta data for the specified connection or result set object.
getMoreResults( ) | Moves the specified statement to the next result set object and returns whether there is a next result set object.
getNextWarning( ) | Returns the next sql warning object for the specified sql warning object.
getPrecision( ) | Returns the given column's number of decimal digits for the specified result set meta data object.
getResultSet( ) | Returns the current result set for the specified statement's object.
getScale( ) | Returns the given column's number of digits to the right of the decimal point for the specified result set meta data object.
getSchemaName( ) | Returns the given column's table schema for the specified result set meta data object.
getString( ) | Returns a string value for the named column in the given result set callable statement object.
getTableName( ) | Returns the given column's table name for the specified result set meta data object.
getTransactionIsolation( ) | Returns the current transaction isolation for the specified connection object.
getUpdateCount( ) | Returns the number of rows updated for the specified statement object.
getWarnings( ) | Returns the first sql warning object on the specified connection, result set or statement object.
isCaseSensitive( ) | Returned whether the given column is case sensitive for the specified result set meta data.
isClosed( ) | Returned whether the specified connect object is already closed.
isDefinitelyWritable( ) | Returned whether the given column is writable for the specified result set meta data.
isNullable( ) | Returned whether the given column can be set to NULL for the specified result set meta data.
isReadOnly( ) | Returned whether the specified connect object is read only or whether the given column is read-only for the specified result set meta data.
isSearchable( ) | Returned whether the given column can be used in a where clause for the specified result set meta data.
isSigned( ) | Returned whether the given column is a signed number for the specified result set meta data.
isWritable( ) | Returned whether the given column is writable for the specified result set meta data.
loadDriver( ) | Used to load the specified JDBC class driver.
next( ) | Moves the specified result set to the next row and returns whether there is a next row.
prepareCall( ) | Returns a callable statement object for the given SQL statement on the specified connection object.
prepareStatement( ) | Returns a prepared statement object for the given SQL statement on the specified connection object.
registerOutParameter( ) | Used to explicitly register the sql type of out parameters for the specified callable statement object.
rollback( ) | Drops all changes to the database on the given connection object.
setAutoCommit( ) | Sets whether auto-commit is enabled or disabled on the specified connection object.
setCursorName( ) | Defines an SQL cursor using the given name in the specified statement object.
setDate( ) | Sets the specified parameter to the given date object in the specified prepared statement object.
setDouble( ) | Sets the specified parameter to the given real number in the specified prepared statement object.
setInt( ) | Sets the specified parameter to the given whole number in the specified prepared statement object.
setInteger( ) | Sets the specified parameter to the given whole number in the specified prepared statement object.
setLong( ) | Sets the specified parameter to the given whole number in the specified prepared statement object.
setMaxRows( ) | Sets the maximum number of rows a result set object can contains for the specified statement object.
setNull( ) | Sets the specified parameter to NULL in the specified prepared statement object.
setReadOnly( ) | Sets whether the on the specified connection object is in read-only mode.
setString( ) | Sets the specified parameter to the given string value in the specified prepared statement object.
setTransactionIsolation( ) | Sets the transaction isolation to specified value on the given connection object.
_TRANSACTION _NONE( ) | Returns the value used to indicate that transactions are not supported for the specified connection object.
_TRANSACTION _READ _COMMITTED( ) | Returns the value used to indicate that dirty reads are prevented for the specified connection object.
_TRANSACTION _READ _UNCOMMITTED( ) | Returns the value used to indicate that reads can occur for the specified connection object.
_TRANSACTION _REPEATABLE _READ( ) | Returns the value used to indicate that dirty and non-repeatable reads are prevented on the specified connection object.
_TRANSACTION _SERIALIZABLE( ) | Returns the value used to indicate that dirty, non-repeatable and phantom reads are prevented on the specified connection object.
wasNull( ) | Returns whether the last value read was NULL for the specified result set or callable statement object.
top of page Copyright © 1998-2005 Servertec. All rights reserved. Privacy Statement. Last Modified: Sun Sep 04 14:56:08 EDT 2005