Servertec JDBC
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

Return

 

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: Mon Sep 05 14:25:25 EDT 2005