Résumé
This title provides a step-by-step tutorial on the JDBC 3 API, as well as many examples and discussions about advanced techniques. It also provides a complete reference of the API's packages and extensions. Powerful and enhanced new features are covered: Batch updates, DataSource object, transaction savepoints, connection pooling, distributed transaction support, XA compatibility, types of ResultSets, holdable cursors, SQL99 types, scalar functions, CLOB, array, reference and datalink objects, customized type mapping, transform groups, ParameterMetaData API, auto generated keys, and more.
Contents
Foreword
Preface
Part 1 An Introduction to Java Database ProgrammingChapter 1 Java as an Enterprise Platform
- A Feature-Rich Enterprise Platform
Write Once, Run Anywhere
N-tiered Computing
Database Aspects in J2EE
The Tools That You Need to Get Started
Summary
Chapter 2 Database Fundamentals
- Relational Databases
Client/Server Concepts
Database Standards - SQL
A simple SQL primer
SAG-X/Open CLI - An Industry Standard: ODBC
- The ODBC interface
ODBC components
JDBC versus ODBC - Summary
Chapter 3 Integrating Databases with JDBC
- The Role of JDBC
- JDBC characteristics
JDBC components
New features of JDBC 3.0
JDBC driver types
The big picture - JDBC Package Contents
JDBC Package Extensions
Summary
Chapter 4 JDBC's Role in Java 2 Enterprise Edition
- J2EE's Layered Architecture
- The client tier
The presentation tier
The application logic tier
The integration tier
The resource tier - JDBC's Relationship to Enterprise JavaBeans
- Business logic components
Business data components - Summary
Chapter 5 Getting Started with JDBC
- The JDBC Mechanisms
The JDBC Interfaces
Typical Uses of JDBC - Applets
Applets in three-tier architectures
Rich-client applications
Thin-client applications - ODBC versus Specific Drivers as a Subprotocol
Summary
Chapter 6 Database Connectivity, Step by Step
- First Steps
Connecting to the Database - JDBC's database naming scheme
Specifying a JDBC driver
Creating a connection
Closing a connection
Adjusting properties
Putting it all together - Sending SQL Statements
- Building statements
Sending statements
Closing statements
Storing BLOBs and CLOBs
Adjusting properties
Setting time-outs - What You Have Done So Far
Handling Results - Fetchable result types
Getting the result set
Retrieving rows
Getting the number and label of columns
Accessing columns
Managing multiple result types
Canceling unwanted results
Closing the result set
Converting types
Receiving BLOBs
Adjusting properties
Creating SQL cursors
Putting it all together again - Managing Errors and Warnings
- SQLException
SQLWarning
Data truncation - Summary
Chapter 7 Refining JDBC Queries and Updates
- The Internals of Driver and DriverManager
SQL Data Type Conversions - Mapping data types to Java
Type mapping tables
Customizing type mapping - The SQL Escape Syntax
- For stored procedures
For the time and date
For scalar functions
For characters that have a special meaning
For outer joins - Transaction Management
- Transaction modes
Transaction isolation levels
Managing transactions with JDBC
Transaction savepoints
Distributed transactions - Types of ResultSets
- Navigating a ResultSet
Updating a ResultSet without using cursors
Updating a ResultSet using cursors - Performing Batch Updates
Summary
Chapter 8 Advanced Techniques
- Using DataSource Objects and Connection Pooling
Handling Stored Procedures with Callable Statements - Setting parameters
Accessing parameters
An example of handling stored procedures - Creating Dynamic SQL with Prepared Statements
- Passing IN parameters
Executing the query and retrieving results
Sending BLOBs - Using RowSets
- Using RowSet methods
Designing and using RowSets - Using Auto-Generated Keys
Summary
Chapter 9 Accessing Database Metadata
- Metadata Interfaces
The DatabaseMetaData Interface - Database information
Supported features
Database limitations
Database objects - The ResultSetMetaData Interface
- ResultSet columns
Column properties - The ParameterMetaData Interface
Dynamic Data Access - Retrieving dynamically typed data
Inserting or updating dynamically typed data - Summary
Chapter 10 Accessing Databases with Enterprise JavaBeans
- Types of Beans
Session Beans - Stateless session beans
Stateful session beans - Entity Beans
- Container-managed persistence
Bean-managed persistence
Container-managed persistence versus \tbean-managed persistence - Summary
Chapter 11 Examples of Java Applications
- Handling Simple Database Statements
- A simple Interactive SQL client application
A simple ISQL client applet - Handling Multimedia Content
- Sending BLOBS
Retrieving BLOBS - Accessing a Database Remotely with a Browser
- The HTML file
Airplet.java
Airport.java
AirportChoice.java
ColumnLayout.java
Flight.java
FlightsPanel.java
FlightsVector.java
ImageCanvas.java
MapCanvas.java
MapInfo.java
MultilineLabel.java - Dealing with Database Transactions
- The HTML file
Account.java
NetBank.java
TimeT.java
The Data Definition Language for the Bank of Java applet - Summary
Chapter 12 Complex Examples of Java Applications
- Dynamic Database Access: A Java Database Explorer
- Logging in to the database
The navigation graphical control
Database engine specifications and limitations
Browsing database catalogs and their content
An Interactive SQL tool
The source code for the JDBCExplorer example - Multitier Applications: Remote Method \tInvocation and JDBC
- The database side
The RMI server side
The client side
Car.java
CarImpl.java
CarFactory.java
CarFactoryImpl.java
CarSales.java
CarSupplierServer.java - Summary
JDBC Extension Reference
Hungry Minds, Inc. End-User License Agreement
L'auteur - Bernard Van Haecke
Bernard Van Haecke is senior consultant and Java
Practice team leader at Sun Microsystems Professional
Services. He has led a number of projects especially in
finance over the past five years; those include
implementing Javabased e-banking/e-trading solutions. He
has also helped re-architect large banks' IT systems with
standard Java/J2EE technologies, which he still does today.
He generally uses application server products such as IBM
WebSphere, BEA Weblogic and iPlanet Application Server, in
combination with Oracle, Sybase or Informix as database and
MQ-Series to integrate with mainframes.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | IDG |
| Auteur(s) | Bernard Van Haecke |
| Parution | 12/03/2002 |
| Nb. de pages | 580 |
| Format | 18,6 x 23,3 |
| Couverture | Broché |
| Poids | 879g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780764548758 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
