?? oracle.sql.sqlutil.html
字號:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><!--NewPage--><html><head><!-- Generated by javadoc on Thu Dec 02 03:30:11 PST 1999 --><title> Class oracle.sql.SQLUtil</title></head><body><a name="_top_"></a><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><hr><h1> Class oracle.sql.SQLUtil</h1><pre>java.lang.Object | +----oracle.sql.SQLUtil</pre><hr><dl> <dt> public class <b>SQLUtil</b> <dt> extends Object</dl>SQL utility class. This class consists of a collection of staticutility methods.<p><hr><a name="index"></a><h2> <img src="images/constructor-index.gif" width=275 height=38 alt="Constructor Index"></h2><dl> <dt> <img src="images/yellow-ball-small.gif" width=6 height=6 alt=" o "> <a href="#SQLUtil()"><b>SQLUtil</b></a>() <dd> </dl><h2> <img src="images/method-index.gif" width=207 height=38 alt="Method Index"></h2><dl> <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#checkDatumType(oracle.sql.Datum, int, java.lang.String)"><b>checkDatumType</b></a>(Datum, int, String) <dd> Check if the Datum is compatible with the specified SQL type. <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#get_internal_type(int)"><b>get_internal_type</b></a>(int) <dd> <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getTypeDescriptor(java.lang.String, oracle.jdbc.driver.OracleConnection)"><b>getTypeDescriptor</b></a>(String, OracleConnection) <dd> Obtain the type descriptor associated with the specified type name. <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#implementsInterface(java.lang.Class, java.lang.Class)"><b>implementsInterface</b></a>(Class, Class) <dd> Check if a class implements an interface. <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#JavaToSQL(oracle.jdbc.driver.OracleConnection, java.lang.Object, int, java.lang.String)"><b>JavaToSQL</b></a>(OracleConnection, Object, int, String) <dd> Convert a Java object to SQL data bytes. <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#main(java.lang.String[])"><b>main</b></a>(String[]) <dd> <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#makeDatum(oracle.jdbc.driver.OracleConnection, byte[], int, java.lang.String)"><b>makeDatum</b></a>(OracleConnection, byte[], int, String) <dd> Create a Datum object from the input SQL data. <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#makeDatum(oracle.jdbc.driver.OracleConnection, java.lang.Object, int, java.lang.String)"><b>makeDatum</b></a>(OracleConnection, Object, int, String) <dd> Create a Datum object from an input Java object. <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#makeOracleDatum(oracle.jdbc.driver.OracleConnection, java.lang.Object, int, java.lang.String)"><b>makeOracleDatum</b></a>(OracleConnection, Object, int, String) <dd> Create a Datum object from an input Java object. <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#SQLToJava(oracle.jdbc.driver.OracleConnection, byte[], int, java.lang.String, java.lang.Class, java.util.Dictionary)"><b>SQLToJava</b></a>(OracleConnection, byte[], int, String, Class, Dictionary) <dd> Convert SQL data bytes to a Java object. <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#SQLToJava(oracle.jdbc.driver.OracleConnection, byte[], int, java.lang.String, oracle.sql.CustomDatumFactory)"><b>SQLToJava</b></a>(OracleConnection, byte[], int, String, CustomDatumFactory) <dd> Convert SQL data bytes to a CustomDatum object. <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#SQLToJava(oracle.jdbc.driver.OracleConnection, oracle.sql.Datum, java.lang.Class, java.util.Dictionary)"><b>SQLToJava</b></a>(OracleConnection, Datum, Class, Dictionary) <dd> Convert a Datum object to a Java object.</dl><a name="constructors"></a><h2> <img src="images/constructors.gif" width=231 height=38 alt="Constructors"></h2><a name="SQLUtil"></a><a name="SQLUtil()"><img src="images/yellow-ball.gif" width=12 height=12 alt=" o "></a><b>SQLUtil</b><pre> public SQLUtil()</pre><a name="methods"></a><h2> <img src="images/methods.gif" width=151 height=38 alt="Methods"></h2><a name="SQLToJava(oracle.jdbc.driver.OracleConnection, byte[], int, java.lang.String, java.lang.Class, java.util.Dictionary)"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a><a name="SQLToJava"><b>SQLToJava</b></a><pre> public static Object SQLToJava(<a href="oracle.jdbc.driver.OracleConnection.html#_top_">OracleConnection</a> connection, byte sqlData[], int sqlTypeCode, String sqlTypeName, Class javaClass, Dictionary map) throws SQLException</pre><dl> <dd> Convert SQL data bytes to a Java object. It first creates a Datum,and then converts the Datum to the appropriate Java object.This method does not handle the case of creating a CustomDatum.There is an overloaded method that takes a CustomDatumFactory(instead of a java class) for creating a CustomDatum.<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 type name of the SQL dataif sqlTypeCode is DBType.REF_TYPE or DBType.NAMED_TYPE.This parameter is ignored for other type codes. <dd> javaClassspecifies - the Java class to which sqlData is converted.CustomDatum is not supported. Use 'null' if thedefault mapping is desired. <dd> mapspecifies - any type map to be used for a named-type.This argument is ignored if sqlTypeCode is notDBType.NAMED_TYPE. Use 'null' if the type mapassociation with the specified connection is desired. <dt> <b>Returns:</b> <dd> the resulting Java object. <dt> <b>Throws:</b> SQLException <dd> if the conversion is illegal, or if an error occurred. </dl></dd></dl><a name="SQLToJava(oracle.jdbc.driver.OracleConnection, byte[], int, java.lang.String, oracle.sql.CustomDatumFactory)"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a><a name="SQLToJava"><b>SQLToJava</b></a><pre> public static <a href="oracle.sql.CustomDatum.html#_top_">CustomDatum</a> SQLToJava(<a href="oracle.jdbc.driver.OracleConnection.html#_top_">OracleConnection</a> connection, byte sqlData[], int sqlTypeCode, String sqlTypeName, <a href="oracle.sql.CustomDatumFactory.html#_top_">CustomDatumFactory</a> factory) throws SQLException</pre><dl> <dd> Convert SQL data bytes to a CustomDatum object.<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 type name of the SQL dataif sqlTypeCode is DBType.REF_TYPE or DBType.NAMED_TYPE.This parameter is ignored for other type codes. <dd> factoryspecifies - the factory to create the CustomDatum. <dt> <b>Returns:</b> <dd> the resulting Java object. <dt> <b>Throws:</b> SQLException <dd> if the conversion is illegal, or if an error occurred. </dl></dd></dl><a name="SQLToJava(oracle.jdbc.driver.OracleConnection, oracle.sql.Datum, java.lang.Class, java.util.Dictionary)"><img src="images/green-ball.gif" width=12 height=12 alt=" o "></a><a name="SQLToJava"><b>SQLToJava</b></a><pre> public static Object SQLToJava(<a href="oracle.jdbc.driver.OracleConnection.html#_top_">OracleConnection</a> connection, Datum datum, Class javaClass, Dictionary map) throws SQLException</pre><dl> <dd> Convert a Datum object to a Java object. For the most part, itutilizes the conversion methods built into the Datum classes.This method does not handle the case of creating a CustomDatum.There is an overloaded method that takes a CustomDatumFactory(instead of a java class) for creating a CustomDatum.<p> <dd><dl> <dt> <b>Parameters:</b> <dd> connectionspecifies - the associated connection. <dd> datumspecifies - the input Datum object. <dd> javaClassspecifies - the Java class to which datum is converted.CustomDatum is not supported. Use 'null' if thedefault mapping is desired. <dd> mapspecifies - any type map to be used for a STRUCT datum.This argument is ignored if 'datum' is not a STRUCT.Use 'null' if the type map association with thespecified connection is desired. <dt> <b>Returns:</b> <dd> the resulting Java object. <dt> <b>Throws:</b> SQLException <dd> if the conversion is illegal, or if an error occurred. </dl></dd></dl><a name="JavaToSQL(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="JavaToSQL"><b>JavaToSQL</b></a><pre>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -