?? oracle.sql.sqlutil.html
字號:
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, itutilizes the conversion capabilities built into the CustomDatumand Datum classes.<p> <dd><dl> <dt> <b>Parameters:</b> <dd> connectionspecifies - the associated connection. <dd> inObjectspecifies - the input Java object. <dd> sqlTypeCodespecifies - the SQL type to which the input object isconverted. See oracle.jdbc.dbaccess.DBType for theappropriate type codes. <dd> sqlTypeNamespecifies - the fully-qualified type name if sqlTypeCodeis DBType.REF_TYPE or DBType.NAMED_TYPE. Thisparameter is ignored for other type codes. <dt> <b>Returns:</b> <dd> the resulting SQL data bytes, or null if the inputobject 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> connectionspecifies - the associated connection. <dd> sqlDataspecifies - the input SQL data. <dd> sqlTypeCodespecifies - the type information of the input sqlData.Use type code defined in oracle.jdbc.dbaccess.DBType. <dd> sqlTypeNamespecifies - the fully-qualified name of the SQL data ifsqlTypeCode 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 thespecified 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> connectionspecifies - the associated connection. <dd> inObjectspecifies - the input object. <dd> sqlTypeCodespecifies - the type information of the input sqlData.Use type code defined in oracle.jdbc.dbaccess.DBType. <dd> sqlTypeNamespecifies - the fully-qualified name of the SQL data ifsqlTypeCode 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 thespecified 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> namespecifies - the type name. <dd> connspecifies - the associated connection. <dt> <b>Returns:</b> <dd> the appropriate descriptor for Array or Structdepending on the type name. <dt> <b>Throws:</b> SQLException <dd> if the specified type does not exist, or if an erroroccurred. </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> datumspecifies - the Datum object to be tested. <dd> sqlTypeCodespecifies - the expected type of the input datum.Use type code defined in oracle.jdbc.dbaccess.DBType. <dd> sqlTypeNamespecifies - the expected type name of the input datumif 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 SQLtype, 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> clazzspecifies - the class to be tested. <dd> interfazespecifies - 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> connectionspecifies - the associated connection. <dd> inObjectspecifies - the input object. <dd> typeCodespecifies - the type information to be converted to.Use type code defined in java.jdbc.driver.OracleTypes. <dd> sqlTypeNamespecifies - the fully-qualified name of the SQL data iftypeCode is OracleTypes.REF or OracleTypes.STRUCT orOracleTypes.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 thespecified 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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -