pkg.html
来自「java类库详细讲解」· HTML 代码 · 共 368 行
HTML
368 行
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>java.sql Examples from The Java Developers Almanac 1.4</TITLE>
<META CONTENT="Patrick Chan" NAME="AUTHOR">
<META CONTENT="Code Examples from the Java Developers Almanac 1.4" NAME="DESCRIPTION">
<META CONTENT="Java Examples" NAME="KEYWORDS">
<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} H2 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12pt} 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>
</DIV>
<br>
<h2>java.sql</h2>
<TABLE CELLSPACING="0" CELLPADDING="5" BORDER="0" width="600">
<TR>
<TD HEIGHT="2" width="20" VALIGN="TOP"></TD><TD VALIGN="TOP">
<br>
<a name="Drivers"></a><b>Drivers</b>
<hr>
e232. <a class="eglink" href="SetupJdbc.html">Getting JDBC Drivers for a Database</a>
<br>
e233. <a class="eglink" href="LoadDrivers.html">Loading a JDBC Driver</a>
<br>
e234. <a class="eglink" href="ListDrivers.html">Listing All Loaded JDBC Drivers</a>
<br>
<br>
<a name="Connections"></a><b>Connections</b>
<hr>
e235. <a class="eglink" href="ConnectOracle.html">Connecting to an Oracle Database</a>
<br>
e236. <a class="eglink" href="ConnectMySql.html">Connecting to a MySQL Database</a>
<br>
e237. <a class="eglink" href="ConnectSqlServer.html">Connecting to a SQLServer Database</a>
<br>
e238. <a class="eglink" href="GetPropInfo.html">Listing All Available Parameters for Creating a JDBC Connection</a>
<br>
e239. <a class="eglink" href="CanTrans.html">Determining If a Database Supports Transactions</a>
<br>
e240. <a class="eglink" href="Commit.html">Committing and Rolling Back Updates to a Database</a>
<br>
e241. <a class="eglink" href="GetSqlException.html">Handling a SQL Exception</a>
<br>
e242. <a class="eglink" href="GetSqlWarnings.html">Determining If a SQL Warning Occurred</a>
<br>
e243. <a class="eglink" href="Conn2Driver.html">Getting the Driver of a Connection</a>
<br>
e244. <a class="eglink" href="GetFetchSize.html">Setting the Number of Rows to Prefetch When Executing a SQL Query</a>
<br>
<br>
<a name="Tables"></a><b>Tables</b>
<hr>
e245. <a class="eglink" href="CreateBasicTable.html">Creating a Database Table</a>
<br>
e246. <a class="eglink" href="DropBasicTable.html">Deleting a Database Table</a>
<br>
e247. <a class="eglink" href="GetTables.html">Listing All Table Names in a Database</a>
<br>
e248. <a class="eglink" href="CreateCompleteMySqlTable.html">Creating a MySQL Table to Store Java Types</a>
<br>
e249. <a class="eglink" href="Java2OracleType.html">Creating an Oracle Table to Store Java Types</a>
<br>
e250. <a class="eglink" href="CreateCompleteSqlServerTable.html">Creating a SQLServer Table to Store Java Types</a>
<br>
<br>
<a name="Retrieving%20Data"></a><b>Retrieving Data</b>
<hr>
e251. <a class="eglink" href="CreateResultSet.html">Getting Rows from a Database Table</a>
<br>
e252. <a class="eglink" href="GetRsData.html">Getting Data from a Result Set</a>
<br>
e253. <a class="eglink" href="IsNull.html">Determining If a Fetched Value Is NULL</a>
<br>
e254. <a class="eglink" href="GetRsColCount.html">Getting the Column Names in a Result Set</a>
<br>
e255. <a class="eglink" href="GetRowCountUsingCount.html">Getting the Number of Rows in a Database Table</a>
<br>
e256. <a class="eglink" href="GetBlob.html">Getting BLOB Data from a Database Table</a>
<br>
e257. <a class="eglink" href="SelectLike.html">Matching with Wildcards in a SQL Statement</a>
<br>
<br>
<a name="Inserting%20and%20Updating%20Data"></a><b>Inserting and Updating Data</b>
<hr>
e258. <a class="eglink" href="Insert.html">Inserting a Row into a Database Table</a>
<br>
e259. <a class="eglink" href="InsertPs.html">Inserting a Row into a Database Table Using a Prepared Statement</a>
<br>
e260. <a class="eglink" href="InsertBinary.html">Getting and Inserting Binary Data into an Database Table</a>
<br>
e261. <a class="eglink" href="UpdateData.html">Updating a Row in a Database Table</a>
<br>
<br>
<a name="Deleting%20Data"></a><b>Deleting Data</b>
<hr>
e262. <a class="eglink" href="Delete.html">Deleting a Row from a Database Table</a>
<br>
e263. <a class="eglink" href="DeleteAllBasicTable.html">Deleting All Rows from a Database Table</a>
<br>
<br>
<a name="Batching"></a><b>Batching</b>
<hr>
e264. <a class="eglink" href="CanBatch.html">Determining If a Database Supports Batching</a>
<br>
e265. <a class="eglink" href="BatchUpdate.html">Executing a Batch of SQL Statements in a Database</a>
<br>
<br>
<a name="Scrollable%20Result%20Sets"></a><b>Scrollable Result Sets</b>
<hr>
e266. <a class="eglink" href="CanSrs.html">Determining If a Database Supports Scrollable Result Sets</a>
<br>
e267. <a class="eglink" href="CreateScrollableResultSet.html">Creating a Scrollable Result Set</a>
<br>
e268. <a class="eglink" href="GetScroll.html">Determining If a Result Set Is Scrollable</a>
<br>
e269. <a class="eglink" href="MoveCursor.html">Moving the Cursor in a Scrollable Result Set</a>
<br>
e270. <a class="eglink" href="GetCursorPosition.html">Getting the Cursor Position in a Scrollable Result Set</a>
<br>
e271. <a class="eglink" href="GetRow.html">Getting the Number of Rows in a Table Using a Scrollable Result Set</a>
<br>
<br>
<a name="Updatable%20Result%20Sets"></a><b>Updatable Result Sets</b>
<hr>
e272. <a class="eglink" href="CanUrs.html">Determining If a Database Supports Updatable Result Sets</a>
<br>
e273. <a class="eglink" href="CreateUpdatableResultSet.html">Creating an Updatable Result Set</a>
<br>
e274. <a class="eglink" href="GetConcurrency.html">Determining If a Result Set Is Updatable</a>
<br>
e275. <a class="eglink" href="UpdateRow.html">Updating a Row in a Database Table Using an Updatable Result Set</a>
<br>
e276. <a class="eglink" href="CancelRowUpdates.html">Cancelling Updates to an Updatable Result Set</a>
<br>
e277. <a class="eglink" href="InsertRow.html">Inserting a Row into a Database Table Using an Updatable Result Set</a>
<br>
e278. <a class="eglink" href="DeleteRow.html">Deleting a Row from a Database Table Using an Updatable Result Set</a>
<br>
e279. <a class="eglink" href="RefreshRow.html">Refreshing a Row in an Updatable Result Set</a>
<br>
<br>
<a name="Procedures%20and%20Functions"></a><b>Procedures and Functions</b>
<hr>
e280. <a class="eglink" href="GetProcedures.html">Getting the Stored Procedure Names in a Database</a>
<br>
e281. <a class="eglink" href="CallProcedure.html">Calling a Stored Procedure in a Database</a>
<br>
e282. <a class="eglink" href="CallFunction.html">Calling a Function in a Database</a>
<br>
e283. <a class="eglink" href="CreateProcedureAndFunction.html">Creating a Stored Procedure or Function in an Oracle Database</a>
<br>
<br>
<a name="Database%20Meta%20Data"></a><b>Database Meta Data</b>
<hr>
e284. <a class="eglink" href="GetSqlKeywords.html">Listing All Non-SQL92 Keywords Used by a Database</a>
<br>
e285. <a class="eglink" href="GetStringFunctions.html">Listing the String Functions Supported by a Database</a>
<br>
e286. <a class="eglink" href="GetNumericFunctions.html">Listing the Numeric Functions Supported by a Database</a>
<br>
e287. <a class="eglink" href="GetSystemFunctions.html">Listing the System Functions Supported by a Database</a>
<br>
e288. <a class="eglink" href="GetTimeDateFunctions.html">Listing the Time and Date Functions Supported by a Database</a>
<br>
e289. <a class="eglink" href="GetMaxTableNameLength.html">Getting the Maximum Table Name Length in a Database</a>
<br>
e290. <a class="eglink" href="GetTypeInfo.html">Listing Available SQL Types Used by a Database</a>
<br>
e291. <a class="eglink" href="JdbcInt2Str.html">Getting the Name of a JDBC Type</a>
<br>
<br>
<a name="Importing%20and%20Exporting"></a><b>Importing and Exporting</b>
<hr>
e292. <a class="eglink" href="LoadFileToMySqlTable.html">Loading a Flat File to a MySQL Table</a>
<br>
e293. <a class="eglink" href="ExportOracleTableToFile.html">Exporting an Oracle Table to a Flat File</a>
<br>
e294. <a class="eglink" href="LoadFileToOracleTable.html">Loading a Flat File to an Oracle Table</a>
<br>
e295. <a class="eglink" href="ExportMySqlTableToFile.html">Exporting a MySQL Table to a Flat File</a>
<br>
<br>
<a name="Oracle%20OBJECTs"></a><b>Oracle OBJECTs</b>
<hr>
e296. <a class="eglink" href="CreateObjectOracle.html">Creating an OBJECT Type in an Oracle Database</a>
<br>
e297. <a class="eglink" href="InsertObjectOracle.html">Inserting an OBJECT Value into an Oracle Table</a>
<br>
e298. <a class="eglink" href="InsertObjectOraclePreparedStatement.html">Inserting an OBJECT Value into an Oracle Table Using a Prepared Statement</a>
<br>
e299. <a class="eglink" href="GetObjectOracle.html">Getting an OBJECT Value from an Oracle Table</a>
<br>
e300. <a class="eglink" href="DropObjectOracle.html">Deleting an OBJECT Type from an Oracle Table</a>
<br>
<br>
<a name="Oracle%20VARRAYs"></a><b>Oracle VARRAYs</b>
<hr>
e301. <a class="eglink" href="CreateArray.html">Creating a VARRAY Type in an Oracle Database</a>
<br>
e302. <a class="eglink" href="InsertArray.html">Inserting a VARRAY Value into an Oracle Table</a>
<br>
e303. <a class="eglink" href="InsertArrayPs.html">Inserting a VARRAY Value into an Oracle Table Using a Prepared Statement</a>
<br>
e304. <a class="eglink" href="GetArray.html">Getting a VARRAY Value from an Oracle Table</a>
<br>
</TD>
</TR>
</TABLE>
<br>
<FONT FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="0">
© 2002 Addison-Wesley.
</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?