Constructor Detail

• public NamedParameterStatement(java.sql.Connection connection, java.lang.String query)

  Creates a NamedParameterStatement. Wraps a call to c. Connection#prepareStatement(java.lang.String).

  throws:

  SQLException if the statement could not be created

  Parameters:

  connection - the database connection

  query - the parameterized query

Method Detail

• public void addBatch()

  Adds the current set of parameters as a batch entry.

  throws:

  SQLException if something went wrong

• public void close()

  Closes the statement.

  throws:

  SQLException if an error occurred

  See Also:

  java.sql.Statement#close()

• public boolean execute()

  Executes the statement.

  throws:

  SQLException if an error occurred

  Returns:

  true if the first result is a java.sql.ResultSet

  See Also:

  java.sql.PreparedStatement#execute()

• public int[] executeBatch()

  Executes all of the batched statements.

  See java.sql.Statement#executeBatch() for details.

  throws:

  SQLException if something went wrong

  Returns:

  update counts for each statement

• public java.sql.ResultSet executeQuery()

  Executes the statement, which must be a query.

  throws:

  SQLException if an error occurred

  Returns:

  the query results

  See Also:

  java.sql.PreparedStatement#executeQuery()

• public int executeUpdate()

  Executes the statement, which must be an SQL INSERT, UPDATE or DELETE statement; or an SQL statement that returns nothing, such as a DDL statement.

  throws:

  SQLException if an error occurred

  Returns:

  number of rows affected

  See Also:

  java.sql.PreparedStatement#executeUpdate()

• public java.sql.PreparedStatement getStatement()

  Returns the underlying statement.

  Returns:

  the statement

• public void setInt(java.lang.String name, int value)

  Sets a parameter.

  throws:

  SQLException if an error occurred

  throws:

  IllegalArgumentException if the parameter does not exist

  Parameters:

  name - parameter name

  value - parameter value

  See Also:

  java.sql.PreparedStatement#setInt(int, int)

• public void setLong(java.lang.String name, long value)

  Sets a parameter.

  throws:

  SQLException if an error occurred

  throws:

  IllegalArgumentException if the parameter does not exist

  Parameters:

  name - parameter name

  value - parameter value

  See Also:

  java.sql.PreparedStatement#setInt(int, int)

• public void setObject(java.lang.String name, java.lang.Object value)

  Sets a parameter.

  throws:

  SQLException if an error occurred

  throws:

  IllegalArgumentException if the parameter does not exist

  Parameters:

  name - parameter name

  value - parameter value

  See Also:

  PreparedStatement#setObject(int, java.lang.Object)

• public void setString(java.lang.String name, java.lang.String value)

  Sets a parameter.

  throws:

  SQLException if an error occurred

  throws:

  IllegalArgumentException if the parameter does not exist

  Parameters:

  name - parameter name

  value - parameter value

  See Also:

  PreparedStatement#setString(int, java.lang.String)

• public void setTimestamp(java.lang.String name, java.sql.Timestamp value)

  Sets a parameter.

  throws:

  SQLException if an error occurred

  throws:

  IllegalArgumentException if the parameter does not exist

  Parameters:

  name - parameter name

  value - parameter value

  See Also:

  PreparedStatement#setTimestamp(int, java.sql.Timestamp)