Package de.uplanet.lucy.server.util.db

Schnittstelle IDbPreparedStatement

Alle Superschnittstellen:
AutoCloseable, ICloseable
Alle bekannten Implementierungsklassen:
DbPreparedStatement
public interface IDbPreparedStatement extends ICloseable

  • Methodendetails

    • getFetchSize

      int getFetchSize() throws SQLException
      Get the fetch size of the underlying prepared statement.
      Gibt zurück:
      The fetch size.
      Löst aus:
      SQLException
      Siehe auch:

    • setFetchSize

      void setFetchSize(int p_iFetchSize) throws SQLException
      Set the fetch size of the underlying prepared statement.
      Parameter:
      p_iFetchSize - The fetch size.
      Löst aus:
      SQLException
      Siehe auch:

    • execute

      void execute() throws SQLException
      Executes the SQL statement in this object, which may be any kind of SQL statement.
      Löst aus:
      SQLException - If a database error occurred.

    • executeUpdate

      int executeUpdate() throws SQLException
      Executes the SQL statement in this object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
      Löst aus:
      SQLException - If a database error occurred.

    • executeQuery

      IDbResultSet executeQuery() throws SQLException
      Executes the SQL query in this object and returns the IDbResultSet object generated by the query.
      Gibt zurück:
      An IDbResultSet object that contains the data produced by the query; never null.
      Löst aus:
      SQLException - If a database error occurred.

    • executeQueryWithResultSet

      Object executeQueryWithResultSet(groovy.lang.Closure<?> p_closure) throws SQLException
      Executes the SQL query in this object and evaluates the given closure with the IDbResultSet object generated by the query as parameter and its delegate.
      Parameter:
      p_closure - The closure that processes the IDbResultSet.
      Gibt zurück:
      The return value of the given closure.
      Löst aus:
      SQLException - If a database error occurred.
      Seit:
      Intrexx 12.2.0.

    • executeAndGetScalarValueHolder

      IValueHolder<?> executeAndGetScalarValueHolder() throws SQLException
      Get the value of the first column in the first row of the result set.

      If the result set is empty, null is returned.

      Gibt zurück:
      A value holder that contains the value of the first column in the first row of the result set, or null if the result set is empty.
      Löst aus:
      SQLException

    • executeAndGetScalarValue

      Object executeAndGetScalarValue(Object p_valueFallback) throws SQLException
      Get the value of the first column in the first row of the result set.

      If the result set is empty, or the value is null, p_valueIfNull is returned.

      Parameter:
      p_valueFallback - The return value if the query returns an empty result set or null.
      Gibt zurück:
      The value of the first column in the first row of the result set, or p_valueIfNull if the result set is empty, or the value is null.
      Löst aus:
      SQLException

    • executeAndGetScalarValue

      Object executeAndGetScalarValue() throws SQLException
      Get the value of the first column in the first row of the result set.

      If the result set is empty, null is returned.

      Gibt zurück:
      The value of the first column in the first row of the result set, or null if the result set is empty.
      Löst aus:
      SQLException

    • executeAndGetScalarBooleanValue

      Boolean executeAndGetScalarBooleanValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarBooleanValue

      Boolean executeAndGetScalarBooleanValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarByteValue

      Byte executeAndGetScalarByteValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarByteValue

      Byte executeAndGetScalarByteValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarShortValue

      Short executeAndGetScalarShortValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarShortValue

      Short executeAndGetScalarShortValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarIntValue

      Integer executeAndGetScalarIntValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarIntValue

      Integer executeAndGetScalarIntValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarLongValue

      Long executeAndGetScalarLongValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarLongValue

      Long executeAndGetScalarLongValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarFloatValue

      Float executeAndGetScalarFloatValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarFloatValue

      Float executeAndGetScalarFloatValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarDoubleValue

      Double executeAndGetScalarDoubleValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarDoubleValue

      Double executeAndGetScalarDoubleValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarBigDecimalValue

      BigDecimal executeAndGetScalarBigDecimalValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarBigDecimalValue

      BigDecimal executeAndGetScalarBigDecimalValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarStringValue

      String executeAndGetScalarStringValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarStringValue

      String executeAndGetScalarStringValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarTimestampValue

      Timestamp executeAndGetScalarTimestampValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarTimestampValue

      Timestamp executeAndGetScalarTimestampValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarDateValue

      Date executeAndGetScalarDateValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarDateValue

      Date executeAndGetScalarDateValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarTimeValue

      Date executeAndGetScalarTimeValue(Object p_valueFallback) throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue(Object).
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • executeAndGetScalarTimeValue

      Date executeAndGetScalarTimeValue() throws SQLException, ValueCastException
      Typed version of executeAndGetScalarValue().
      Löst aus:
      SQLException - If a database error occurred.
      ValueCastException - If the database value could not be cast to the specific type.
      Siehe auch:

    • setBoolean

      void setBoolean(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given boolean value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setInt

      void setInt(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given integer number value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setLong

      void setLong(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given integer number value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setShort

      void setShort(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given integer number value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setByte

      void setByte(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given integer value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setBigDecimal

      void setBigDecimal(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given number value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setFloat

      void setFloat(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given floating point number value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setDouble

      void setDouble(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given floating point number value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setTimestamp

      void setTimestamp(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given timestamp value.

      A calendar with the time zone that is associated with the database connection that was used to create this statement is used to write the timestamp to the database.

      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setTimestamp

      void setTimestamp(int p_iIdx, Object p_value, TimeZone p_tz) throws SQLException
      Sets the designated parameter to the given timestamp value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      p_tz - The time zone to be used when writing the timestamp to the database. If this parameter is omitted, the time zone that is associated with the database connection that was used to create this statement is used.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setTimestamp

      void setTimestamp(int p_iIdx, Object p_value, Calendar p_cal) throws SQLException
      Sets the designated parameter to the given timestamp value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      p_cal - The calendar to be used when writing the timestamp to the database. If this parameter is omitted, a calendar with the time zone that is associated with the database connection that was used to create this statement is used.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setTime

      void setTime(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given time value.

      A calendar with the time zone that is associated with the database connection that was used to create this statement is used to write the time value to the database.

      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setTime

      void setTime(int p_iIdx, Object p_value, TimeZone p_tz) throws SQLException
      Sets the designated parameter to the given time value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      p_tz - The time zone to be used when writing the time value to the database. If this parameter is omitted, the time zone that is associated with the database connection that was used to create this statement is used.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setTime

      void setTime(int p_iIdx, Object p_value, Calendar p_cal) throws SQLException
      Sets the designated parameter to the given time value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      p_cal - The calendar to be used when writing the time to the database. If this parameter is omitted, a calendar with the time zone that is associated with the database connection that was used to create this statement is used.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setDate

      void setDate(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given date value.

      A calendar with the time zone that is associated with the database connection that was used to create this statement is used to write the time value to the database.

      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setDate

      void setDate(int p_iIdx, Object p_value, TimeZone p_tz) throws SQLException
      Sets the designated parameter to the given date value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      p_tz - The time zone to be used when writing the date value to the database. If this parameter is omitted, the time zone that is associated with the database connection that was used to create this statement is used.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setDate

      void setDate(int p_iIdx, Object p_value, Calendar p_cal) throws SQLException
      Sets the designated parameter to the given date value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      p_cal - The calendar to be used when writing the date to the database. If this parameter is omitted, a calendar with the time zone that is associated with the database connection that was used to create this statement is used.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setString

      void setString(int p_iIdx, Object p_value) throws SQLException
      Sets the designated parameter to the given string value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.

    • setCharacterStream

      void setCharacterStream(int p_iIdx, Object p_value) throws SQLException, IOException
      Sets the designated parameter to the value given string value.
      Parameter:
      p_iIdx - The first parameter is 1, the second is 2, ...
      p_value - The parameter value.
      Löst aus:
      SQLException - If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
      IOException

    • close

      void close() throws SQLException
      Close this statement.
      Angegeben von:
      close in Schnittstelle AutoCloseable
      Löst aus:
      SQLException - If a database error occurred.