Java compact2, compact3 java.sql Interface SQLData（JDK8）

Method Detail

• getSQLTypeName

  String getSQLTypeName()
                 throws SQLException

  Returns the fully-qualified name of the SQL user-defined type that this object represents. This method is called by the JDBC driver to get the name of the UDT instance that is being mapped to this instance of SQLData.

  Returns:

  the type name that was passed to the method readSQL when this object was constructed and populated

  Throws:

  SQLException - if there is a database access error

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• readSQL

  void readSQL(SQLInput stream,
               String typeName)
        throws SQLException

  Populates this object with data read from the database. The implementation of the method must follow this protocol:

  • It must read each of the attributes or elements of the SQL type from the given input stream. This is done by calling a method of the input stream to read each item, in the order that they appear in the SQL definition of the type.
  • The method readSQL then assigns the data to appropriate fields or elements (of this or other objects). Specifically, it must call the appropriate reader method (SQLInput.readString, SQLInput.readBigDecimal, and so on) method(s) to do the following: for a distinct type, read its single data element; for a structured type, read a value for each attribute of the SQL type.

  The JDBC driver initializes the input stream with a type map before calling this method, which is used by the appropriate SQLInput reader method on the stream.

  Parameters:

  stream - the SQLInput object from which to read the data for the value that is being custom mapped

  typeName - the SQL type name of the value on the data stream

  Throws:

  SQLException - if there is a database access error

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

  See Also:

  SQLInput

• writeSQL

  void writeSQL(SQLOutput stream)
         throws SQLException

  Writes this object to the given SQL data stream, converting it back to its SQL value in the data source. The implementation of the method must follow this protocol:
  It must write each of the attributes of the SQL type to the given output stream. This is done by calling a method of the output stream to write each item, in the order that they appear in the SQL definition of the type. Specifically, it must call the appropriate SQLOutput writer method(s) (writeInt, writeString, and so on) to do the following: for a Distinct Type, write its single data element; for a Structured Type, write a value for each attribute of the SQL type.

  Parameters:

  stream - the SQLOutput object to which to write the data for the value that was custom mapped

  Throws:

  SQLException - if there is a database access error

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

  See Also:

  SQLOutput