Quadcap Embeddable Database

com.quadcap.jdbc.PreparedStatement Class Reference

Inheritance diagram for com.quadcap.jdbc.PreparedStatement:

List of all members.

---

Detailed Description

This release of QED performs all of the SQL parsing during the prepare phase, so that subsequent execution of the compiled statement is considerably faster than directly executing the statement using the Statement interface.

Author:

Stan Bailes

Definition at line 90 of file PreparedStatement.java.

Public Member Functions
	PreparedStatement (Connection conn, String sql) throws SQLException, IOException
void	addBatch () throws SQLException
	This QED release doesn't support batch statement execution.
void	clearParameters () throws SQLException
	Clear the values of any parameters to this prepared statement; i.e., set them all to NULL.
boolean	execute () throws SQLException
	Execute the current SQL statement, returning true if the statement generates a ResultSet object.
java.sql.ResultSet	executeQuery () throws SQLException
	Execute the prepared SQL query statement, returning the ResultSet object containing the results of the query.
int	executeUpdate () throws SQLException
	Execute the prepared SQL update statement, returning the update count, meaning the number of rows updated or inserted by this statement.
java.sql.ResultSetMetaData	getMetaData ()
	QED doesn't implement this feature, which requires information about the ResultSet that will be generated by this PreparedStatement object when it is executed.
void	setAsciiStream (int col, InputStream in, int length) throws SQLException
	Set the statement parameter to the specified character value using an InputStream that contains a stream of ASCII bytes.
void	setBigDecimal (int col, BigDecimal val) throws SQLException
	Set the statement parameter to the specified BigDecimal value.
void	setBinaryStream (int col, InputStream in, int length) throws SQLException
	Set the statement parameter to the specified binary value using an InputStream that contains a stream of bytes.
void	setBoolean (int col, boolean val) throws SQLException
	Set the statement parameter to the specified boolean value.
void	setByte (int col, byte val) throws SQLException
	Set the statement parameter to the specified byte value.
void	setBytes (int col, byte[] val) throws SQLException
	Set the statement parameter to the specified byte array value.
void	setCharacterStream (int col, Reader r, int length) throws SQLException
	Set the statement parameter to the specified character value using a Reader that contains a stream of Unicode characters.
void	setDate (int col, Date val) throws SQLException
	Set the statement parameter to the specified Date value.
void	setDate (int col, Date val, Calendar cal) throws SQLException
	Set the statement parameter to the specified Date value.
void	setDouble (int col, double val) throws SQLException
	Set the statement parameter to the specified double value.
void	setFloat (int col, float val) throws SQLException
	Set the statement parameter to the specified float value.
void	setInt (int col, int val) throws SQLException
	Set the statement parameter to the specified int value.
void	setLong (int col, long val) throws SQLException
	Set the statement parameter to the specified long value.
void	setNull (int col, int type) throws SQLException
	Set the statement parameter to the specified null value.
void	setNull (int col, int type, String typename) throws SQLException
	Set the statement parameter to the specified null value.
void	setObject (int col, Object val) throws SQLException
	Set the statement parameter to the specified Object value.
void	setObject (int col, Object val, int type) throws SQLException
	Set the statement parameter to the specified Object value.
void	setObject (int col, Object val, int type, int scale) throws SQLException
	Set the statement parameter to the specified Object value.
void	setShort (int col, short val) throws SQLException
	Set the statement parameter to the specified short value.
void	setString (int col, String val) throws SQLException
	Set the statement parameter to the specified String value.
void	setTime (int col, Time val) throws SQLException
	Set the statement parameter to the specified Time value.
void	setTime (int col, Time val, Calendar cal) throws SQLException
	Set the statement parameter to the specified Time value.
void	setTimestamp (int col, Timestamp val) throws SQLException
	Set the statement parameter to the specified Timestamp value.
void	setTimestamp (int col, Timestamp val, Calendar cal) throws SQLException
	Set the statement parameter to the specified Timestamp value.
void	setUnicodeStream (int col, InputStream in, int length) throws SQLException
	PreparedStatement (Connection conn, String sql, int resultSetType, int resultSetConcurrency) throws SQLException, IOException
void	setArray (int col, Array val) throws SQLException
	Set the statement parameter to the specified ARRAY value.
void	setBlob (int col, Blob val) throws SQLException
	Set the statement parameter to the specified Blob value.
void	setClob (int col, Clob val) throws SQLException
	Set the statement parameter to the specified Clob value.
void	setRef (int col, Ref val) throws SQLException
	Set the statement parameter to the specified REF value.
void	setURL (int parameterIndex, java.net.URL x) throws SQLException
	Sets the designated parameter to the given java.net.URL value.
java.sql.ParameterMetaData	getParameterMetaData () throws SQLException
	Retrieves the number, types and properties of this PreparedStatement object's parameters.
String	toString ()
Package Functions
ParameterExpression	getParam (int i)
final void	setParamValue (int col, Value v) throws SQLException
Package Attributes
Stmt	stmt
Vector	params
String	sql

---

Constructor & Destructor Documentation

com.quadcap.jdbc.PreparedStatement.PreparedStatement (  Connection  conn, String  sql )  throws SQLException, IOException

Deprecated: in order to not appear in public javadoc Definition at line 102 of file PreparedStatement.java. References com.quadcap.sql.SQLParser.getParameters(), com.quadcap.sql.Session.makeTransaction(), com.quadcap.jdbc.PreparedStatement.params, com.quadcap.jdbc.PreparedStatement.sql, com.quadcap.sql.SQLParser.statement(), and com.quadcap.jdbc.PreparedStatement.stmt.

com.quadcap.jdbc.PreparedStatement.PreparedStatement (  Connection  conn, String  sql, int  resultSetType, int  resultSetConcurrency )  throws SQLException, IOException

Deprecated: Definition at line 727 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.sql.

---

Member Function Documentation

void com.quadcap.jdbc.PreparedStatement.addBatch (   )  throws SQLException

This QED release doesn't support batch statement execution. Exceptions: SQLException  "not implemented" Definition at line 143 of file PreparedStatement.java.

void com.quadcap.jdbc.PreparedStatement.clearParameters (   )  throws SQLException

Clear the values of any parameters to this prepared statement; i.e., set them all to NULL. Exceptions: SQLException  may be thrown Definition at line 157 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.params, and com.quadcap.sql.ParameterExpression.setValue().

boolean com.quadcap.jdbc.PreparedStatement.execute (   )  throws SQLException

Execute the current SQL statement, returning true if the statement generates a ResultSet object. Returns: true if execution of the statement results in the creation of a ResultSet See also: getResultSet() Exceptions: SQLException  may be thrown Definition at line 173 of file PreparedStatement.java. References com.quadcap.sql.Session.doStatement(), com.quadcap.sql.Session.endStatement(), com.quadcap.sql.Session.getResultSet(), com.quadcap.sql.Session.getUpdateCount(), com.quadcap.jdbc.PreparedStatement.sql, and com.quadcap.jdbc.PreparedStatement.stmt. Referenced by com.quadcap.jdbc.PreparedStatement.executeQuery(), and com.quadcap.jdbc.PreparedStatement.executeUpdate().

java.sql.ResultSet com.quadcap.jdbc.PreparedStatement.executeQuery (   )  throws SQLException

Execute the prepared SQL query statement, returning the ResultSet object containing the results of the query. Returns: a ResultSet object containing the results of the query Exceptions: SQLException  may be thrown Definition at line 222 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.execute().

int com.quadcap.jdbc.PreparedStatement.executeUpdate (   )  throws SQLException

Execute the prepared SQL update statement, returning the update count, meaning the number of rows updated or inserted by this statement. Returns: the update count Exceptions: SQLException  may be thrown Definition at line 238 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.execute().

java.sql.ResultSetMetaData com.quadcap.jdbc.PreparedStatement.getMetaData (   )

QED doesn't implement this feature, which requires information about the ResultSet that will be generated by this PreparedStatement object when it is executed. Instead, first call execute() or executeQuery(), then call ResultSet.getMetaData() on the ResultSet object that is returned. Returns: null Definition at line 257 of file PreparedStatement.java.

ParameterExpression com.quadcap.jdbc.PreparedStatement.getParam (  int  i  )  [package]

Definition at line 147 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.getParam(), and com.quadcap.jdbc.PreparedStatement.params. Referenced by com.quadcap.jdbc.PreparedStatement.getParam().

java.sql.ParameterMetaData com.quadcap.jdbc.PreparedStatement.getParameterMetaData (   )  throws SQLException

Retrieves the number, types and properties of this PreparedStatement object's parameters. QED: Not implemented Returns: a ParameterMetaData object that contains information about the number, types and properties of this PreparedStatement object's parameters Exceptions: SQLException  if a database access error occurs See also: ParameterMetaData Since: 1.4 Definition at line 841 of file PreparedStatement.java.

void com.quadcap.jdbc.PreparedStatement.setArray (  int  col, Array  val )  throws SQLException

Set the statement parameter to the specified ARRAY value. This QED release doesn't support ARRAY types, so a "not implemented" exception is thrown Parameters: col  the parameter index val  the new value Exceptions: SQLException  "not implemented" Definition at line 748 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setArray(). Referenced by com.quadcap.jdbc.PreparedStatement.setArray().

void com.quadcap.jdbc.PreparedStatement.setAsciiStream (  int  col, InputStream  in, int  length )  throws SQLException

Set the statement parameter to the specified character value using an InputStream that contains a stream of ASCII bytes. The ASCII bytes are converted to Unicode character values before being inserted into the database. Parameters: col  the parameter index is  an input stream containing ASCII bytes. length  the number of bytes to read from the stream Returns: an InputStream Exceptions: SQLException  may be thrown Definition at line 273 of file PreparedStatement.java. References com.quadcap.sql.types.ValueBlob.close(), com.quadcap.sql.Session.doStep(), com.quadcap.sql.Session.getDatabase(), com.quadcap.sql.Session.makeTransaction(), com.quadcap.jdbc.PreparedStatement.setAsciiStream(), and com.quadcap.jdbc.PreparedStatement.setParamValue(). Referenced by com.quadcap.jdbc.PreparedStatement.setAsciiStream().

void com.quadcap.jdbc.PreparedStatement.setBigDecimal (  int  col, BigDecimal  val )  throws SQLException

Set the statement parameter to the specified BigDecimal value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 311 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setBigDecimal(). Referenced by com.quadcap.jdbc.PreparedStatement.setBigDecimal().

void com.quadcap.jdbc.PreparedStatement.setBinaryStream (  int  col, InputStream  in, int  length )  throws SQLException

Set the statement parameter to the specified binary value using an InputStream that contains a stream of bytes. Parameters: col  the parameter index is  an input stream containing ASCII bytes. length  the number of bytes to read from the stream If 'length > 0', then the blob's length will be set to the value of the 'length' parameter. If 'length < 0', then the blob's length will be set to the number of bytes read. Returns: an InputStream Exceptions: SQLException  may be thrown Definition at line 335 of file PreparedStatement.java. References com.quadcap.sql.types.ValueBlob.close(), com.quadcap.sql.Session.doStep(), com.quadcap.sql.Session.getDatabase(), com.quadcap.sql.Session.makeTransaction(), and com.quadcap.jdbc.PreparedStatement.setBinaryStream(). Referenced by com.quadcap.jdbc.PreparedStatement.setBinaryStream().

void com.quadcap.jdbc.PreparedStatement.setBlob (  int  col, Blob  val )  throws SQLException

Set the statement parameter to the specified Blob value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 760 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setBlob(). Referenced by com.quadcap.jdbc.PreparedStatement.setBlob().

void com.quadcap.jdbc.PreparedStatement.setBoolean (  int  col, boolean  val )  throws SQLException

Set the statement parameter to the specified boolean value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 364 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setBoolean(). Referenced by com.quadcap.jdbc.PreparedStatement.setBoolean().

void com.quadcap.jdbc.PreparedStatement.setByte (  int  col, byte  val )  throws SQLException

Set the statement parameter to the specified byte value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 376 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setByte(). Referenced by com.quadcap.jdbc.PreparedStatement.setByte().

void com.quadcap.jdbc.PreparedStatement.setBytes (  int  col, byte[]  val )  throws SQLException

Set the statement parameter to the specified byte array value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 388 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setBytes(). Referenced by com.quadcap.jdbc.PreparedStatement.setBytes().

void com.quadcap.jdbc.PreparedStatement.setCharacterStream (  int  col, Reader  r, int  length )  throws SQLException

Set the statement parameter to the specified character value using a Reader that contains a stream of Unicode characters. Parameters: col  the parameter index r  a reader containing the value's characters. length  the number of bytes to read from the stream Returns: an InputStream Exceptions: SQLException  may be thrown Definition at line 406 of file PreparedStatement.java. References com.quadcap.sql.types.ValueBlob.close(), com.quadcap.sql.Session.doStep(), com.quadcap.sql.Session.getDatabase(), com.quadcap.sql.Session.makeTransaction(), and com.quadcap.jdbc.PreparedStatement.setCharacterStream(). Referenced by com.quadcap.jdbc.PreparedStatement.setCharacterStream().

void com.quadcap.jdbc.PreparedStatement.setClob (  int  col, Clob  val )  throws SQLException

Set the statement parameter to the specified Clob value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 781 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setClob(). Referenced by com.quadcap.jdbc.PreparedStatement.setClob().

void com.quadcap.jdbc.PreparedStatement.setDate (  int  col, Date  val, Calendar  cal )  throws SQLException

Set the statement parameter to the specified Date value. Parameters: col  the parameter index val  the new value cal  a Calendar object that is used for converting the database date to the local timezone. The database date is adjusted based on the Calendar timezone and DST offset. Exceptions: SQLException  may be thrown Definition at line 454 of file PreparedStatement.java.

void com.quadcap.jdbc.PreparedStatement.setDate (  int  col, Date  val )  throws SQLException

Set the statement parameter to the specified Date value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 435 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setDate(). Referenced by com.quadcap.jdbc.PreparedStatement.setDate().

void com.quadcap.jdbc.PreparedStatement.setDouble (  int  col, double  val )  throws SQLException

Set the statement parameter to the specified double value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 471 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setDouble(). Referenced by com.quadcap.jdbc.PreparedStatement.setDouble().

void com.quadcap.jdbc.PreparedStatement.setFloat (  int  col, float  val )  throws SQLException

Set the statement parameter to the specified float value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 483 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setFloat(). Referenced by com.quadcap.jdbc.PreparedStatement.setFloat().

void com.quadcap.jdbc.PreparedStatement.setInt (  int  col, int  val )  throws SQLException

Set the statement parameter to the specified int value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 495 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setInt(). Referenced by com.quadcap.jdbc.PreparedStatement.setInt().

void com.quadcap.jdbc.PreparedStatement.setLong (  int  col, long  val )  throws SQLException

Set the statement parameter to the specified long value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 507 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setLong(). Referenced by com.quadcap.jdbc.PreparedStatement.setLong().

void com.quadcap.jdbc.PreparedStatement.setNull (  int  col, int  type, String  typename )  throws SQLException

Set the statement parameter to the specified null value. Parameters: col  the parameter index type  the JDBC type of the parameter. This is ignored by QED because a null is a null is a null. typename  the fully qualified type name of the parameter. This is ignored by QED because a null is a null is a null. Exceptions: SQLException  may be thrown Definition at line 536 of file PreparedStatement.java.

void com.quadcap.jdbc.PreparedStatement.setNull (  int  col, int  type )  throws SQLException

Set the statement parameter to the specified null value. Parameters: col  the parameter index type  the JDBC type of the parameter. This is ignored by QED because a null is a null is a null. Exceptions: SQLException  may be thrown Definition at line 520 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setNull(). Referenced by com.quadcap.jdbc.PreparedStatement.setNull().

void com.quadcap.jdbc.PreparedStatement.setObject (  int  col, Object  val, int  type, int  scale )  throws SQLException

Set the statement parameter to the specified Object value. Parameters: col  the parameter index val  the new value type  the JDBC type of the parameter. scale  for numeric types, the precision of the value. Exceptions: SQLException  may be thrown Definition at line 588 of file PreparedStatement.java. References com.quadcap.sql.types.Type.convert().

void com.quadcap.jdbc.PreparedStatement.setObject (  int  col, Object  val, int  type )  throws SQLException

Set the statement parameter to the specified Object value. Parameters: col  the parameter index val  the new value type  the JDBC type of the parameter. Exceptions: SQLException  may be thrown Definition at line 572 of file PreparedStatement.java. References com.quadcap.sql.types.Type.convert().

void com.quadcap.jdbc.PreparedStatement.setObject (  int  col, Object  val )  throws SQLException

Set the statement parameter to the specified Object value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 550 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setObject(). Referenced by com.quadcap.jdbc.PreparedStatement.setObject().

final void com.quadcap.jdbc.PreparedStatement.setParamValue (  int  col, Value  v )  throws SQLException [package]

Definition at line 294 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setParamValue(), and com.quadcap.sql.ParameterExpression.setValue(). Referenced by com.quadcap.jdbc.PreparedStatement.setAsciiStream(), and com.quadcap.jdbc.PreparedStatement.setParamValue().

void com.quadcap.jdbc.PreparedStatement.setRef (  int  col, Ref  val )  throws SQLException

Set the statement parameter to the specified REF value. This QED release doesn't support ARRAY types, so a "not implemented" exception is thrown Parameters: col  the parameter index val  the new value Exceptions: SQLException  "not implemented" Definition at line 799 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setRef(). Referenced by com.quadcap.jdbc.PreparedStatement.setRef().

void com.quadcap.jdbc.PreparedStatement.setShort (  int  col, short  val )  throws SQLException

Set the statement parameter to the specified short value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 612 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setShort(). Referenced by com.quadcap.jdbc.PreparedStatement.setShort().

void com.quadcap.jdbc.PreparedStatement.setString (  int  col, String  val )  throws SQLException

Set the statement parameter to the specified String value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 624 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setString(). Referenced by com.quadcap.jdbc.PreparedStatement.setString().

void com.quadcap.jdbc.PreparedStatement.setTime (  int  col, Time  val, Calendar  cal )  throws SQLException

Set the statement parameter to the specified Time value. Parameters: col  the parameter index val  the new value cal  a Calendar object that is used for converting the database date to the local timezone. The database date is adjusted based on the Calendar timezone and DST offset. Exceptions: SQLException  may be thrown Definition at line 659 of file PreparedStatement.java.

void com.quadcap.jdbc.PreparedStatement.setTime (  int  col, Time  val )  throws SQLException

Set the statement parameter to the specified Time value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 640 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setTime(). Referenced by com.quadcap.jdbc.PreparedStatement.setTime().

void com.quadcap.jdbc.PreparedStatement.setTimestamp (  int  col, Timestamp  val, Calendar  cal )  throws SQLException

Set the statement parameter to the specified Timestamp value. Parameters: col  the parameter index val  the new value cal  a Calendar object that is used for converting the database date to the local timezone. The database date is adjusted based on the Calendar timezone and DST offset. Exceptions: SQLException  may be thrown Definition at line 698 of file PreparedStatement.java.

void com.quadcap.jdbc.PreparedStatement.setTimestamp (  int  col, Timestamp  val )  throws SQLException

Set the statement parameter to the specified Timestamp value. Parameters: col  the parameter index val  the new value Exceptions: SQLException  may be thrown Definition at line 679 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setTimestamp(). Referenced by com.quadcap.jdbc.PreparedStatement.setTimestamp().

void com.quadcap.jdbc.PreparedStatement.setUnicodeStream (  int  col, InputStream  in, int  length )  throws SQLException

Deprecated: Definition at line 717 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setUnicodeStream(). Referenced by com.quadcap.jdbc.PreparedStatement.setUnicodeStream().

void com.quadcap.jdbc.PreparedStatement.setURL (  int  parameterIndex, java.net.URL  x )  throws SQLException

Sets the designated parameter to the given java.net.URL value. The driver converts this to an SQL DATALINK value when it sends it to the database. QED simply converts the URL to a string Parameters: parameterIndex  the first parameter is 1, the second is 2, ... x  the java.net.URL object to be set Exceptions: SQLException  if a database access error occurs Since: 1.4 Definition at line 821 of file PreparedStatement.java. References com.quadcap.jdbc.PreparedStatement.setURL(). Referenced by com.quadcap.jdbc.PreparedStatement.setURL().

String com.quadcap.jdbc.PreparedStatement.toString (   )

Reimplemented from com.quadcap.jdbc.Statement. Definition at line 848 of file PreparedStatement.java. References com.quadcap.sql.ParameterExpression.getValue(), and com.quadcap.jdbc.PreparedStatement.params.

---

Member Data Documentation

Vector com.quadcap.jdbc.PreparedStatement.params [package]

Definition at line 94 of file PreparedStatement.java. Referenced by com.quadcap.jdbc.PreparedStatement.clearParameters(), com.quadcap.jdbc.PreparedStatement.getParam(), com.quadcap.jdbc.PreparedStatement.PreparedStatement(), and com.quadcap.jdbc.PreparedStatement.toString().

String com.quadcap.jdbc.PreparedStatement.sql [package]

Definition at line 96 of file PreparedStatement.java. Referenced by com.quadcap.jdbc.PreparedStatement.execute(), and com.quadcap.jdbc.PreparedStatement.PreparedStatement().

Stmt com.quadcap.jdbc.PreparedStatement.stmt [package]

Definition at line 93 of file PreparedStatement.java. Referenced by com.quadcap.jdbc.PreparedStatement.execute(), and com.quadcap.jdbc.PreparedStatement.PreparedStatement().