Java Programming with Oracle JDBC

Donald Bales

  • 出版商: O'Reilly
  • 出版日期: 2002-01-01
  • 售價: $2,210
  • 貴賓價: 9.5$2,100
  • 語言: 英文
  • 頁數: 450
  • 裝訂: Paperback
  • ISBN: 059600088X
  • ISBN-13: 9780596000882
  • 相關分類: Java 程式語言Oracle
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

JDBC is the key Java technology for relational database access. Oracle is arguably the most widely used relational database platform in the world. In this book, Donald Bales brings these two technologies together, and shows you how to leverage the full power of Oracle's implementation of JDBC.

You begin by learning the all-important mysteries of establishing database connections. This can be one of the most frustrating areas for programmers new to JDBC, and Donald covers it well with detailed information and examples showing how to make database connections from applications, applets, Servlets, and even from Java programs running within the database itself.

Next comes thorough coverage of JDBC's relational SQL features. You'll learn how to issue SQL statements and get results back from the database, how to read and write data from large, streaming data types such as BLOBs, CLOBs, and BFILEs, and you'll learn how to interface with Oracle's other built-in programming language, PL/SQL.

If you're taking advantage of the Oracle's relatively new ability to create object tables and column objects based on user-defined datatypes, you'll be pleased with Don's thorough treatment of this subject. Don shows you how to use JPublisher and JDBC to work seamlessly with Oracle database objects from within Java programs. You'll also learn how to access nested tables and arrays using JDBC.

Donald concludes the book with a discussion of transaction management, locking, concurrency, and performance--topics that every professional JDBC programmer must be familiar with. If you write Java programs to run against an Oracle database, this book is a must-have.

Table of Contents

Preface

Part I. Overview

1. Introduction to JDBC

Part II. Connections

2. Application Database Connections

3. Applet Database Connections

4. Servlet Database Connections

5. Internal Database Connections

6. Oracle Advanced Security

7. JNDI and Connection Pooling

Part III. Relational SQL

8. A Relational SQL Example

9. Statements

10. Result Sets

11. Prepared Statements

12. Streaming Data Types

13. Callable Statements

Part IV. Object-Relational SQL

14. An Object-Relational SQL Example

15. Weakly Typed Object SQL

16. Strongly Typed Object SQL

Part V. Essentials

17. Transactions

18. Detection and Locking

19. Performance

20. Troubleshooting

Index

商品描述(中文翻譯)

JDBC是用於關聯式資料庫存取的關鍵Java技術。Oracle可以說是全球使用最廣泛的關聯式資料庫平台。在這本書中,Donald Bales將這兩個技術結合在一起,並向您展示如何充分利用Oracle對JDBC的實現。

您首先將學習建立資料庫連接的重要技巧。對於新手JDBC程式設計師來說,這可能是最令人沮喪的領域之一,Donald通過詳細的資訊和示例展示了如何從應用程式、小程式、Servlet甚至在資料庫內運行的Java程式中建立資料庫連接。

接下來是對JDBC關聯式SQL功能的全面介紹。您將學習如何發出SQL語句並從資料庫中獲取結果,如何讀寫大型流數據類型(如BLOB、CLOB和BFILE),以及如何與Oracle的其他內建程式語言PL/SQL進行交互。

如果您正在利用Oracle相對較新的功能來創建基於用戶定義資料類型的物件表和列物件,您將對Don對此主題的詳細處理感到滿意。Don向您展示如何使用JPublisher和JDBC在Java程式中無縫地使用Oracle資料庫物件。您還將學習如何使用JDBC訪問嵌套表和數組。

Donald在本書中以交易管理、鎖定、並發和性能等主題作為結尾,這些主題是每個專業的JDBC程式設計師都必須熟悉的。如果您撰寫Java程式來運行在Oracle資料庫上,這本書是必不可少的。

目錄:

前言

第一部分. 概述

1. JDBC簡介

第二部分. 連接

2. 應用程式資料庫連接
3. 小程式資料庫連接
4. Servlet資料庫連接
5. 內部資料庫連接
6. Oracle高級安全性
7. JNDI和連接池

第三部分. 關聯式SQL

8. 關聯式SQL示例
9. 語句
10. 結果集
11. 預備語句
12. 流數據類型
13. 可調用語句

第四部分. 物件關聯式SQL

14. 物件關聯式SQL示例
15. 弱型別物件SQL
16. 強型別物件SQL

第五部分. 基本要素

17. 交易
18. 檢測和鎖定
19. 性能
20. 故障排除

索引