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