JDBC API Tutorial and Reference

Acknowledgments.
PART ONE. 1. Introduction.
What the JDBC 3.0 API Includes.Conventions Used in This Book.Fonts to Indicate Function.Icons to Indicate New Material.Special Page Designations in the Index.SQLException Is Implied in Method Explanations.Some Method Explanations Are Combined.Contents of the Book.Part One.Part Two.Suggested Order for Reading Chapters.Where to Find Information by Topic.Resources on the Web.What Is the JDBC API?What Does the JDBC API Do?A Base for Other APIs.The JDBC API versus ODBC.Two-tier and Three-tier Models.SQL Conformance.Products Based on JDBC Technology.JDBC Product Framework.JDBC Driver Types.Obtaining JDBC Drivers.Java-relational DBMSs.Other Products.The JDBC API and the Java Platforms.The JDBC API and the J2SE Platform.The JDBC API and the J2EE Platform.The JDBC API and the J2ME Platform.Java Overview.Java Is Portable.Java Is Object-oriented.Java Makes It Easy to Write Correct Code.Java Includes a Library of Classes and Interfaces.Java Is Extensible.Java Is Secure.Java Performs Well.Java Scales Well.Java Is Multithreaded.Relational Database Overview.Integrity Rules.SELECT Statements.WHERE Clauses.Joins.Common SQL Commands.Result Sets and Cursors.Transactions.Stored Procedures.Metadata.2. Basic Tutorial.
Getting Started.Setting Up a Database.Establishing a Connection.Loading Drivers.Making the Connection.Setting Up Tables.Creating a Table.Creating JDBC Statements.Executing Statements.Entering Data into a Table.Getting Data from a Table.Retrieving Values from Result Sets.Using the Method next.Retrieving Column Values.Using the Method getString.Updating Tables.Milestone: The Basics of JDBC.Using Prepared Statements.When to Use a PreparedStatement Object.Creating a PreparedStatement Object.Supplying Values for PreparedStatement Parameters.Using a Loop to Set Values.Return Values for the Method executeUpdate.Using Joins.Using Transactions.Disabling Auto-commit Mode.Committing a Transaction.Using Transactions to Preserve Data Integrity.When to Roll Back a Transaction.Stored Procedures.SQL Statements for Creating a Stored Procedure.Calling a Stored Procedure Using the JDBC API.Creating Complete JDBC Applications.Putting Code in a Class Definition.Importing Classes to Make Them Visible.Using the main Method.Using try and catch Blocks.Retrieving Exceptions.Retrieving Warnings.Running the Sample Applications.Sample Code.Sample Code 1 and 2.Sample Code 3 and 4.Sample Code 5.Sample Code 6.Creating an Applet from an Application.Writing Applet Code.Running an Applet.Sample Code 7 and 8.Stored Pr...

Autorentext
Maydene Fisher, a native of San Jose, California, specializes in object-oriented languages. She has experience spanning both coasts of the United States, having documented everything from complex financial models on Wall Street to Java APIs in Silicon Valley. Jon Ellis, author of the JDBC 3.0 API specification, has been working with database systems for the past ten years. Currently based in Tokyo, Japan, he is now leading several Java Community Process specifications in the wireless space. Jonathan Bruce, who previously worked on JNDI technology in Ireland and is now based in Santa Clara, California, has worked on the specifications for the JDBC 3.0 API, the RowSet implementations, and the JDBC API subset for use with wireless devices. 0321173848AB05222003

Klappentext
This book provides the definitive tutorial and reference to the JDBC™ API, the technology that enables universal data access for the Java™ programming language. This new edition has been updated and expanded to cover the entire JDBC 3.0 API, including the java.sql package and the javax.sql package, the package that facilitates building server-side applications.Containing in-depth explanations that go beyond the specification, this complete resource pairs a step-by-step tutorial with a comprehensive reference to every class and interface.For those new to Java technology, the book includes an introduction to the Java programming language and to SQL. It builds on this basic knowledge to walk you through the creation of a JDBC application--from setting up a database and establishing a connection to retrieving values from result sets and using prepared statements. In addition, the authors provide many examples along the way that demonstrate how to execute common tasks. The book then turns to more advanced topics, focusing on features such as scrollable and updatable result sets, batch updates, SQL99 data types, custom mapping, savepoints, statement pooling, automatically generated keys, and more.In addition to in-depth coverage of the JDBC metadata API, the book gives you the latest information on rowsets, the technology that makes it possible to handle data sets as JavaBeans™ components. As an added bonus, you get a preview of the standard implementations for JdbcRowSet, CachedRowSet, WebRowSet, JoinRowSet, and FilteredRowSet objects.From Array to XADataSource, an easy-to-use alphabetical reference provides concise but complete information on each class and interface in the JDBC API. Each entry includes an overview with usage examples as well as a comprehensive explanation of the methods and fields.A chapter on mapping SQL types and types in the Java programming language, an appendix for driver writers, a summary of the new features in the JDBC 2.0 and 3.0 APIs, and a glossary complete this indispensable resource for all database programmers.The Java™ Series is supported, endorsed, and authored by the creators of the Java technology at Sun Microsystems, Inc. It is the official place to go for complete, expert, and definitive information on Java technology. The books in this Series provide the inside information you need to build effective, robust, and portable applications and applets. The Series is an indispensable resource for anyone targeting the Java™ 2 platform.

0321173848B05222003

Zusammenfassung
Acts as a tutorial and reference to the JDBC API. Building on the introduction to the Java programming language and to SQL, this book walks the reader through the creation of a JDBC application. It also contains an easy-to-use alphabetical reference which provides information on each class and interface in the JDBC API.

Inhalt
Acknowledgments. PART ONE. 1. Introduction. What the JDBC 3.0 API Includes. Conventions Used in This Book. Fonts to Indicate Function. Icons to Indicate New Material…

#	Onlineshop	Preis CHF	Versand CHF	Total CHF
1	Seller	0.00	0.00	0.00