com.caucho.quercus.lib.db

Class PDOStatement

java.lang.Object

com.caucho.quercus.lib.db.PDOStatement

All Implemented Interfaces:

EnvCleanup, java.lang.Iterable<Value>

public class PDOStatement
extends java.lang.Object
implements java.lang.Iterable<Value>, EnvCleanup

PDO object oriented API facade.

Field Summary

Fields

Modifier and Type	Field and Description
java.lang.String	queryString

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	PDOStatement(Env env, PDO pdo, PDOError error)

Method Summary

Modifier and Type	Method and Description
boolean	bindColumn(Env env, Value column, Value var, int type)
boolean	bindParam(Env env, Value parameter, Value value, int dataType, int length, Value driverOptions)
boolean	bindValue(Env env, Value parameter, Value value, int dataType)
void	cleanup() Implements the EnvCleanup interface.
boolean	close()
boolean	closeCursor(Env env) Closes the current cursor.
int	columnCount(Env env) Returns the number of columns.
java.lang.String	errorCode(Env env)
ArrayValue	errorInfo()
protected static PDOStatement	execute(Env env, PDO pdo, PDOError error, java.lang.String query, boolean isCatchException)
boolean	execute(Env env, Value inputParameters) Execute the statement.
Value	fetch(Env env, int fetchMode, int cursorOrientation, int cursorOffset) Fetch the next row.
Value	fetchAll(Env env, int fetchMode, int columnIndex)
Value	fetchColumn(Env env, int column)
Value	fetchObject(Env env, java.lang.String className, Value[] args)
Value	getAttribute(Env env, int attribute)
Value	getColumnMeta(Env env, int column)
protected JdbcStatementResource	getStatement()
java.util.Iterator<Value>	iterator() Returns an iterator of the values.
boolean	nextRowset()
protected static PDOStatement	prepare(Env env, PDO pdo, PDOError error, java.lang.String query, boolean isCatchException)
int	rowCount(Env env)
boolean	setAttribute(Env env, int attribute, Value value)
boolean	setAttribute(Env env, int attribute, Value value, boolean isFromConstructor)
protected void	setError(Env env, java.sql.SQLException e)
boolean	setFetchMode(Env env, int fetchMode, Value[] args) Sets the fetch mode, the default is PDO.FETCH_BOTH.
java.lang.String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Field Detail

queryString

public java.lang.String queryString

Constructor Detail

PDOStatement

protected PDOStatement(Env env,
                       PDO pdo,
                       PDOError error)

Method Detail

prepare

protected static PDOStatement prepare(Env env,
                                      PDO pdo,
                                      PDOError error,
                                      java.lang.String query,
                                      boolean isCatchException)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

execute

protected static PDOStatement execute(Env env,
                                      PDO pdo,
                                      PDOError error,
                                      java.lang.String query,
                                      boolean isCatchException)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatement

protected JdbcStatementResource getStatement()

bindColumn

public boolean bindColumn(Env env,
                          Value column,
                          Value var,
                          int type)

bindParam

public boolean bindParam(Env env,
                         Value parameter,
                         Value value,
                         int dataType,
                         int length,
                         Value driverOptions)

bindValue

public boolean bindValue(Env env,
                         Value parameter,
                         Value value,
                         int dataType)

closeCursor

public boolean closeCursor(Env env)

Closes the current cursor.

columnCount

public int columnCount(Env env)

Returns the number of columns.

close

public boolean close()

cleanup

public void cleanup()

Implements the EnvCleanup interface.

Specified by:

cleanup in interface EnvCleanup

errorCode

public java.lang.String errorCode(Env env)

errorInfo

public ArrayValue errorInfo()

setError

protected void setError(Env env,
                        java.sql.SQLException e)

execute

public boolean execute(Env env,
                       Value inputParameters)

Execute the statement.

Parameters:

inputParameters - an array containing input values to correspond to the bound parameters for the statement.

Returns:

true for success, false for failure

fetch

public Value fetch(Env env,
                   int fetchMode,
                   int cursorOrientation,
                   int cursorOffset)

Fetch the next row.

Parameters:

fetchMode - the mode, 0 to use the value set by setFetchMode(com.caucho.quercus.env.Env, int, com.caucho.quercus.env.Value[]).

Returns:

a value, BooleanValue.FALSE if there are no more rows or an error occurs.

fetchAll

public Value fetchAll(Env env,
                      int fetchMode,
                      int columnIndex)

Parameters:

fetchMode -

columnIndex - 0-based column index when fetchMode is FETCH_BOTH

fetchColumn

public Value fetchColumn(Env env,
                         int column)

Parameters:

column - 0-based column number

fetchObject

public Value fetchObject(Env env,
                         java.lang.String className,
                         Value[] args)

getAttribute

public Value getAttribute(Env env,
                          int attribute)

getColumnMeta

public Value getColumnMeta(Env env,
                           int column)

Parameters:

column - 0-based column index

iterator

public java.util.Iterator<Value> iterator()

Returns an iterator of the values.

Specified by:

iterator in interface java.lang.Iterable<Value>

nextRowset

public boolean nextRowset()

rowCount

public int rowCount(Env env)

setAttribute

public boolean setAttribute(Env env,
                            int attribute,
                            Value value)

setAttribute

public boolean setAttribute(Env env,
                            int attribute,
                            Value value,
                            boolean isFromConstructor)

setFetchMode

public boolean setFetchMode(Env env,
                            int fetchMode,
                            Value[] args)

Sets the fetch mode, the default is PDO.FETCH_BOTH.

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object