Members

Java.Sql.IStatement Members

The members of Java.Sql.IStatement are listed below.

Public Properties

[read-only]	Connection	IConnection. Gets the `Connection` object which created this statement.
	FetchDirection	int. Gets the default direction for fetching rows for `ResultSet`s generated from this statement.
	FetchSize	int. Gets the default number of rows for a fetch for the `ResultSet` objects returned from this statement.
[read-only]	GeneratedKeys	IResultSet. Returns auto generated keys created by executing this statement.
[read-only]	IsClosed	bool. Returns true if this statement has been closed, false otherwise.
[read-only]	IsCloseOnCompletion	bool. Documentation for this section has not yet been entered.
	MaxFieldSize	int. Gets the maximum number of bytes which can be returned as values from character and binary type columns in a `ResultSet` derived from this statement.
	MaxRows	int. Gets the maximum number of rows that a `ResultSet` can contain when produced from this statement.
[read-only]	MoreResults	bool. Moves to this statement's next result.
	Poolable	bool. Returns true if this statement is poolable, false otherwise.
	QueryTimeout	int. Gets the timeout value for the statement's execution time.
[read-only]	ResultSet	IResultSet. Gets the current result.
[read-only]	ResultSetConcurrency	int. Gets the concurrency setting for `ResultSet` objects generated by this statement.
[read-only]	ResultSetHoldability	int. Gets the cursor hold setting for `ResultSet` objects generated by this statement.
[read-only]	ResultSetType	int. Gets the `ResultSet` type setting for `ResultSet`s derived from this statement.
[read-only]	UpdateCount	int. Gets an update count for the current result if it is not a `ResultSet`.
[read-only]	Warnings	SQLWarning. Retrieves the first `SQLWarning` reported by calls on this statement.

Public Methods

	AddBatch(string) Adds a specified SQL command to the list of commands for this `Statement`.
	Cancel() Cancels this statement's execution if both the database and the JDBC driver support aborting an SQL statement in flight.
	ClearBatch() Clears the current list of SQL commands for this statement.
	ClearWarnings() Clears all `SQLWarnings` from this statement.
	Close() Releases this statement's database and JDBC driver resources.
	CloseOnCompletion() Documentation for this section has not yet been entered.
	Execute(string) : bool Executes a supplied SQL statement.
	Execute(string, int) : bool Executes a supplied SQL statement.
	Execute(string, int[]) : bool Executes the supplied SQL statement.
	Execute(string, string[]) : bool Executes the supplied SQL statement.
	ExecuteBatch() : int[] Submits a batch of SQL commands to the database.
	ExecuteQuery(string) : IResultSet Executes a supplied SQL statement.
	ExecuteUpdate(string) : int Executes the supplied SQL statement.
	ExecuteUpdate(string, int) : int Executes the supplied SQL statement.
	ExecuteUpdate(string, int[]) : int Executes the supplied SQL statement.
	ExecuteUpdate(string, string[]) : int Executes the supplied SQL statement.
	GetMoreResults(int) : bool Moves to this statement's next result.
	SetCursorName(string) Sets the SQL cursor name.
	SetEscapeProcessing(bool) Sets Escape Processing mode.