java2oracletype.html
来自「java类库详细讲解」· HTML 代码 · 共 207 行
HTML
207 行
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>Creating an Oracle Table to Store Java Types
(Java Developers Almanac Example)
</TITLE>
<META CONTENT="Patrick Chan" NAME="AUTHOR">
<META CONTENT="Code Examples from The Java Developers Almanac 1.4" NAME="DESCRIPTION">
<META CONTENT="Addison-Wesley/Patrick Chan" NAME="OWNER">
<META CONTENT="3/20/02" NAME="revision">
<STYLE TYPE="text/css">
<!-- BODY CODE {font-family: Courier, Monospace; font-size: 11pt} TABLE, BODY {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10pt} PRE {font-family: Courier, Monospace; font-size: 10pt} H3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11pt} A.eglink {text-decoration: none} A:hover.eglink {text-decoration: underline} -->
</STYLE>
</HEAD>
<BODY>
<TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0">
<TR>
<TD rowspan="3"><A HREF="/?l=ex"><IMG BORDER="0" ALIGN="BOTTOM" HSPACE="10" SRC="/egs/almanac14a.jpg"></A></TD><TD VALIGN="top"><font face="Times" size="6"><b>The Java Developers Almanac 1.4</b></font>
<br>
Order this book from <a href="/cgi-bin/scripts/redirect.pl?l=ex&url=http://www.amazon.com/exec/obidos/ASIN/0201752808/xeo">Amazon</a>.
</TD>
</TR>
<TR>
<TD align="right" valign="bottom">
<FORM method="get" action="/cgi-bin/search/find.pl">
<INPUT size="25" name="words" type="text"><INPUT value="Search" type="submit">
</FORM>
</TD>
</TR>
</TABLE>
<HR color="#6666cc">
<DIV ALIGN="LEFT">
<A HREF="/">Home</A>
>
<A HREF="../index.html">List of Packages</A>
>
<B><A HREF="../java.sql/pkg.html">java.sql</A></B><font color="#666666" SIZE="-2">
[73 examples]
</font>
>
<B><A HREF="../java.sql/pkg.html#Tables">Tables</A></B><font color="#666666" SIZE="-2">
[6 examples]
</font>
</DIV><P>
<h3>
e249.
Creating an Oracle Table to Store Java Types</h3>
This example creates an Oracle table called <code>oracle_all_table</code>
to store Java types.
<P> Oracle does not support the <code>boolean</code> Java type directly. A
typical workaround is to use the Oracle <code>CHAR(1)</code> type and convert
the <code>boolean</code> value to and from a string. Typically, <code>false</code> is
converted to <code>F</code> and <code>true</code> is converted to <code>T</code>.
<pre>
try {
Statement stmt = <font color="#0066ff"><i>connection</i></font>.createStatement();
// Create a VARRAY type; see <a href="../java.sql/CreateArray.html" class="eglink"><font size="-1"><b>e301</b> Creating a VARRAY Type in an Oracle Database</font></a>
stmt.execute("CREATE TYPE number_varray AS VARRAY(10) OF NUMBER(12, 2)");
// Create an OBJECT type; <a href="../java.sql/CreateObjectOracle.html" class="eglink"><font size="-1"><b>e296</b> Creating an OBJECT Type in an Oracle Database</font></a>
stmt.execute ("CREATE TYPE my_object AS OBJECT(col_string2 VARCHAR(30), col_int2 INTEGER)");
// Note that Oracle database only allows at most one column of LONG type in a table.
// Column Name Oracle Type Java Type
String sql = "CREATE TABLE oracle_all_table("
+ "col_short SMALLINT, " // short
+ "col_int INTEGER, " // int
+ "col_float REAL, " // float; can also be NUMBER
+ "col_double DOUBLE PRECISION, " // double; can also be FLOAT or NUMBER
+ "col_bigdecimal DECIMAL(13,0), " // BigDecimal
+ "col_string VARCHAR2(254), " // String; can also be CHAR(n)
+ "col_characterstream LONG, " // CharacterStream or AsciiStream
+ "col_bytes RAW(2000), " // byte[]; can also be LONG RAW(n)
+ "col_binarystream RAW(2000), " // BinaryStream; can also be LONG RAW(n)
+ "col_timestamp DATE, " // Timestamp
+ "col_clob CLOB, " // Clob
+ "col_blob BLOB, " // Blob; can also be BFILE
+ "col_array number_varray, " // oracle.sql.ARRAY
+ "col_object my_object)"; // oracle.sql.OBJECT
stmt.executeUpdate(sql);
} catch (SQLException e) {
}
</pre>
<P><table width="600" CELLSPACING="0" CELLPADDING="2" BORDER="0">
<tr>
<td bgcolor="#6666cc" align="center"><font color="#ffffff">
Related Examples
</font></td>
</tr>
</table>
e245. <a class="eglink" href="CreateBasicTable.html?l=rel">
Creating a Database Table
</a>
<br>
e246. <a class="eglink" href="DropBasicTable.html?l=rel">
Deleting a Database Table
</a>
<br>
e247. <a class="eglink" href="GetTables.html?l=rel">
Listing All Table Names in a Database
</a>
<br>
e248. <a class="eglink" href="CreateCompleteMySqlTable.html?l=rel">
Creating a MySQL Table to Store Java Types
</a>
<br>
e250. <a class="eglink" href="CreateCompleteSqlServerTable.html?l=rel">
Creating a SQLServer Table to Store Java Types
</a>
<br>
<table width="600" CELLSPACING="0" CELLPADDING="2" BORDER="0">
<tr>
<td align="left">
<br>
See also:
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Batching">
Batching
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Connections">
Connections
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Database%20Meta%20Data">
Database Meta Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Deleting%20Data">
Deleting Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Drivers">
Drivers
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Importing%20and%20Exporting">
Importing and Exporting
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Inserting%20and%20Updating%20Data">
Inserting and Updating Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Oracle%20OBJECTs">
Oracle OBJECTs
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Oracle%20VARRAYs">
Oracle VARRAYs
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Procedures%20and%20Functions">
Procedures and Functions
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Retrieving%20Data">
Retrieving Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Scrollable%20Result%20Sets">
Scrollable Result Sets
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Updatable%20Result%20Sets">
Updatable Result Sets
</a>
</td>
</tr>
</table>
<br>
<br>
<FONT FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="0">
© 2002 Addison-Wesley.
</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?