oracle.sql.sqlutil.html

Oracle JDBC 的javaDoc

 public static byte[] JavaToSQL(<a href="oracle.jdbc.driver.OracleConnection.html#_top_">OracleConnection</a> connection,
                                Object inObject,
                                int sqlTypeCode,
                                String sqlTypeName) throws SQLException
</pre>
<dl>
  <dd> Convert a Java object to SQL data bytes.  For the most part, it
utilizes the conversion capabilities built into the CustomDatum
and Datum classes.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> connection
specifies - the associated connection.
    <dd> inObject
specifies - the input Java object.
    <dd> sqlTypeCode
specifies - the SQL type to which the input object is
converted.  See oracle.jdbc.dbaccess.DBType for the
appropriate type codes.
    <dd> sqlTypeName
specifies - the fully-qualified type name if sqlTypeCode
is DBType.REF_TYPE or DBType.NAMED_TYPE.  This
parameter is ignored for other type codes.
    <dt> <b>Returns:</b>
    <dd> the resulting SQL data bytes, or null if the input
object is null.
    <dt> <b>Throws:</b> SQLException
    <dd> if the conversion is illegal, or if an error occurs.
  </dl></dd>
</dl>
<a name="makeDatum(oracle.jdbc.driver.OracleConnection, byte[], int, java.lang.String)"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a>
<a name="makeDatum"><b>makeDatum</b></a>
<pre>
 public static Datum makeDatum(<a href="oracle.jdbc.driver.OracleConnection.html#_top_">OracleConnection</a> connection,
                               byte sqlData[],
                               int sqlTypeCode,
                               String sqlTypeName) throws SQLException
</pre>
<dl>
  <dd> Create a Datum object from the input SQL data.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> connection
specifies - the associated connection.
    <dd> sqlData
specifies - the input SQL data.
    <dd> sqlTypeCode
specifies - the type information of the input sqlData.
Use type code defined in oracle.jdbc.dbaccess.DBType.
    <dd> sqlTypeName
specifies - the fully-qualified name of the SQL data if
sqlTypeCode is DBType.REF_TYPE or DBType.NAMED_TYPE.
This parameter is ignored for other type codes.
    <dt> <b>Returns:</b>
    <dd> the resulting Datum object.
    <dt> <b>Throws:</b> SQLException
    <dd> if failed to construct a Datum object from the
specified input.
  </dl></dd>
</dl>
<a name="makeDatum(oracle.jdbc.driver.OracleConnection, java.lang.Object, int, java.lang.String)"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a>
<a name="makeDatum"><b>makeDatum</b></a>
<pre>
 public static Datum makeDatum(<a href="oracle.jdbc.driver.OracleConnection.html#_top_">OracleConnection</a> connection,
                               Object inObject,
                               int sqlTypeCode,
                               String sqlTypeName) throws SQLException
</pre>
<dl>
  <dd> Create a Datum object from an input Java object.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> connection
specifies - the associated connection.
    <dd> inObject
specifies - the input object.
    <dd> sqlTypeCode
specifies - the type information of the input sqlData.
Use type code defined in oracle.jdbc.dbaccess.DBType.
    <dd> sqlTypeName
specifies - the fully-qualified name of the SQL data if
sqlTypeCode is DBType.REF_TYPE or DBType.NAMED_TYPE.
This parameter is ignored for other type codes.
    <dt> <b>Returns:</b>
    <dd> the resulting Datum object.
    <dt> <b>Throws:</b> SQLException
    <dd> if failed to construct a Datum object from the
specified input.
  </dl></dd>
</dl>
<a name="getTypeDescriptor(java.lang.String, oracle.jdbc.driver.OracleConnection)"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getTypeDescriptor"><b>getTypeDescriptor</b></a>
<pre>
 public static Object getTypeDescriptor(String name,
                                        <a href="oracle.jdbc.driver.OracleConnection.html#_top_">OracleConnection</a> conn) throws SQLException
</pre>
<dl>
  <dd> Obtain the type descriptor associated with the specified type name.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> name
specifies - the type name.
    <dd> conn
specifies - the associated connection.
    <dt> <b>Returns:</b>
    <dd> the appropriate descriptor for Array or Struct
depending on the type name.
    <dt> <b>Throws:</b> SQLException
    <dd> if the specified type does not exist, or if an error
occurred.
  </dl></dd>
</dl>
<a name="checkDatumType(oracle.sql.Datum, int, java.lang.String)"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a>
<a name="checkDatumType"><b>checkDatumType</b></a>
<pre>
 public static boolean checkDatumType(Datum datum,
                                      int sqlType,
                                      String sqlTypeName) throws SQLException
</pre>
<dl>
  <dd> Check if the Datum is compatible with the specified SQL type.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> datum
specifies - the Datum object to be tested.
    <dd> sqlTypeCode
specifies - the expected type of the input datum.
Use type code defined in oracle.jdbc.dbaccess.DBType.
    <dd> sqlTypeName
specifies - the expected type name of the input datum
if sqlTypeCode is DBType.REF_TYPE or DBType.NAMED_TYPE.
This parameter is ignored for other type codes.
    <dt> <b>Returns:</b>
    <dd> true if Datum is compatible with the specified SQL
type, or false if not.
    <dt> <b>Throws:</b> SQLException
    <dd> if errors occurred.
  </dl></dd>
</dl>
<a name="implementsInterface(java.lang.Class, java.lang.Class)"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a>
<a name="implementsInterface"><b>implementsInterface</b></a>
<pre>
 public static boolean implementsInterface(Class clazz,
                                           Class interfaze)
</pre>
<dl>
  <dd> Check if a class implements an interface.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> clazz
specifies - the class to be tested.
    <dd> interfaze
specifies - the interface.
    <dt> <b>Returns:</b>
    <dd> true if clazz implements interfaze, or false if not.
  </dl></dd>
</dl>
<a name="makeOracleDatum(oracle.jdbc.driver.OracleConnection, java.lang.Object, int, java.lang.String)"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a>
<a name="makeOracleDatum"><b>makeOracleDatum</b></a>
<pre>
 public static Datum makeOracleDatum(<a href="oracle.jdbc.driver.OracleConnection.html#_top_">OracleConnection</a> connection,
                                     Object inObject,
                                     int typeCode,
                                     String sqlTypeName) throws SQLException
</pre>
<dl>
  <dd> Create a Datum object from an input Java object.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> connection
specifies - the associated connection.
    <dd> inObject
specifies - the input object.
    <dd> typeCode
specifies - the type information to be converted to.
Use type code defined in java.jdbc.driver.OracleTypes.
    <dd> sqlTypeName
specifies - the fully-qualified name of the SQL data if
typeCode is OracleTypes.REF or OracleTypes.STRUCT or
OracleTypes.ARRAY.
This parameter is ignored for other type codes.
    <dt> <b>Returns:</b>
    <dd> the resulting Datum object.
    <dt> <b>Throws:</b> SQLException
    <dd> if failed to construct a Datum object from the
specified input.
  </dl></dd>
</dl>
<a name="get_internal_type(int)"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a>
<a name="get_internal_type"><b>get_internal_type</b></a>
<pre>
 public static int get_internal_type(int external_type) throws SQLException
</pre>
<a name="main(java.lang.String[])"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a>
<a name="main"><b>main</b></a>
<pre>
 public static void main(String args[]) throws SQLException
</pre>
<hr>
<pre>
<a href="packages.html">All Packages</a>  <a href="tree.html">Class Hierarchy</a>  <a href="Package-oracle.sql.html">This Package</a>  <a href="oracle.sql.SQLName.html#_top_">Previous</a>  <a href="oracle.sql.STRUCT.html#_top_">Next</a>  <a href="AllNames.html">Index</a></pre>
</body>
</html>