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

Class DbPreparedStatement

java.lang.Object
de.uplanet.lucy.server.util.db.DbPreparedStatement
All Implemented Interfaces:
de.uplanet.lucy.server.util.db.IDbPreparedStatement, de.uplanet.util.ICloseable, AutoCloseable
public final class DbPreparedStatement extends Object implements de.uplanet.lucy.server.util.db.IDbPreparedStatement

  • Method Details

    • getFetchSize

      public int getFetchSize() throws SQLException
      Specified by:
      getFetchSize in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setFetchSize

      public void setFetchSize(int p_iFetchSize) throws SQLException
      Specified by:
      setFetchSize in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • execute

      public void execute() throws SQLException
      Specified by:
      execute in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • executeUpdate

      public int executeUpdate() throws SQLException
      Specified by:
      executeUpdate in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • executeQuery

      public DbResultSet executeQuery() throws SQLException
      Specified by:
      executeQuery in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • executeAndGetScalarValueHolder

      public 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.

      Specified by:
      executeAndGetScalarValueHolder in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Returns:
      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.
      Throws:
      SQLException

    • executeAndGetScalarValue

      public 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.

      Specified by:
      executeAndGetScalarValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Parameters:
      p_valueFallback - The return value if the query returns an empty result set or null.
      Returns:
      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.
      Throws:
      SQLException

    • executeAndGetScalarValue

      public 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.

      Specified by:
      executeAndGetScalarValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Returns:
      The value of the first column in the first row of the result set, or null if the result set is empty.
      Throws:
      SQLException

    • executeAndGetScalarBooleanValue

      public Boolean executeAndGetScalarBooleanValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarBooleanValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarBooleanValue

      public Boolean executeAndGetScalarBooleanValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarBooleanValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarByteValue

      public Byte executeAndGetScalarByteValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarByteValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarByteValue

      public Byte executeAndGetScalarByteValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarByteValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarShortValue

      public Short executeAndGetScalarShortValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarShortValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarShortValue

      public Short executeAndGetScalarShortValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarShortValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarIntValue

      public Integer executeAndGetScalarIntValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarIntValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarIntValue

      public Integer executeAndGetScalarIntValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarIntValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarLongValue

      public Long executeAndGetScalarLongValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarLongValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarLongValue

      public Long executeAndGetScalarLongValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarLongValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarFloatValue

      public Float executeAndGetScalarFloatValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarFloatValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarFloatValue

      public Float executeAndGetScalarFloatValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarFloatValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarDoubleValue

      public Double executeAndGetScalarDoubleValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarDoubleValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarDoubleValue

      public Double executeAndGetScalarDoubleValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarDoubleValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarBigDecimalValue

      public BigDecimal executeAndGetScalarBigDecimalValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarBigDecimalValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarBigDecimalValue

      public BigDecimal executeAndGetScalarBigDecimalValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarBigDecimalValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarStringValue

      public String executeAndGetScalarStringValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarStringValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarStringValue

      public String executeAndGetScalarStringValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarStringValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarTimestampValue

      public Timestamp executeAndGetScalarTimestampValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarTimestampValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarTimestampValue

      public Timestamp executeAndGetScalarTimestampValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarTimestampValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarDateValue

      public Date executeAndGetScalarDateValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarDateValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarDateValue

      public Date executeAndGetScalarDateValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarDateValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarTimeValue

      public Date executeAndGetScalarTimeValue(Object p_valueFallback) throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarTimeValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • executeAndGetScalarTimeValue

      public Date executeAndGetScalarTimeValue() throws SQLException, de.uplanet.lucy.server.util.db.ValueCastException
      Specified by:
      executeAndGetScalarTimeValue in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      de.uplanet.lucy.server.util.db.ValueCastException

    • setBoolean

      public void setBoolean(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setBoolean in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setInt

      public void setInt(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setInt in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setLong

      public void setLong(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setLong in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setShort

      public void setShort(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setShort in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setByte

      public void setByte(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setByte in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setBigDecimal

      public void setBigDecimal(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setBigDecimal in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setFloat

      public void setFloat(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setFloat in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setDouble

      public void setDouble(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setDouble in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setTimestamp

      public void setTimestamp(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setTimestamp in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setTimestamp

      public void setTimestamp(int p_iIdx, Object p_value, TimeZone p_tz) throws SQLException
      Specified by:
      setTimestamp in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setTimestamp

      public void setTimestamp(int p_iIdx, Object p_value, Calendar p_cal) throws SQLException
      Specified by:
      setTimestamp in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setTime

      public void setTime(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setTime in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setTime

      public void setTime(int p_iIdx, Object p_value, TimeZone p_tz) throws SQLException
      Specified by:
      setTime in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setTime

      public void setTime(int p_iIdx, Object p_value, Calendar p_cal) throws SQLException
      Specified by:
      setTime in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setDate

      public void setDate(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setDate in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setDate

      public void setDate(int p_iIdx, Object p_value, TimeZone p_tz) throws SQLException
      Specified by:
      setDate in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setDate

      public void setDate(int p_iIdx, Object p_value, Calendar p_cal) throws SQLException
      Specified by:
      setDate in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setString

      public void setString(int p_iIdx, Object p_value) throws SQLException
      Specified by:
      setString in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException

    • setCharacterStream

      public void setCharacterStream(int p_iIdx, Object p_value) throws SQLException, IOException
      Specified by:
      setCharacterStream in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException
      IOException

    • close

      public void close() throws SQLException
      Close this statement.
      Specified by:
      close in interface AutoCloseable
      Specified by:
      close in interface de.uplanet.lucy.server.util.db.IDbPreparedStatement
      Throws:
      SQLException - If a database error occurred.