JDBC Pocket Reference: A Quick Guide for Programmers by Donald Bales (English) P

Description: JDBC Pocket Reference by Donald Bales The JDBC Pocket Reference offers quick look-ups for all methods of the standard JDBC classes. These include concise reviews of the procedures for common JDBC tasks such as connecting to a database, executing stored procedures, executing DDL and the like. FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description JDBC - the Java Database Connectivity specification - is a complex set of application programming interfaces (APIs) that developers need to understand if they want their Java applications to work with databases. JDBC is so complex that even the most experienced developers need to refresh their memories from time to time on specific methods and details. But, practically speaking, who wants to stop and thumb through a weighty tutorial volume each time a question arises? The answer is the JDBC Pocket Reference, a data-packed quick reference that is both a time-saver and a lifesaver. This reference offers quick look-ups for all methods of the standard JDBC classes. These include concise reviews of the procedures for common JDBC tasks such as connecting to a database, executing stored procedures, executing DDL and the like. Youll find documentation of the connect string formats for the most common databases, including Oracle, SQL-Server, and PostgreSQL. Youll even find information on working with large objects, and on using SQL 99 user defined datatypes to work with object-relational data. Searching for this sort of material through large tutorials is frustrating and a waste of time, but this pocket-sized book is easy to take anywhere and makes finding the information you need a snap." Author Biography Donald Bales is a Computer Applications Consultant specializing in the analysis, design, and programming of distributed systems; systems integration; and data warehousing. Don has over sixteen years experience with Oracle as both a developer and a database administrator, and six years experiance with Java. He is currently working on the migration of medical and industrial hygiene systems to a web environment for a major Oil company. When he is not developing applications, Donald can often be found working with horses, playing the piano, or playing the bagpipes. Donald has had several careers, and has at various times been a mechanic, a general contractor, Mr. Mom, a developer, and currently a consultant. He has a bachelor of science degree in Business from Elmhurst College in Elmhurst, Illinois. Don currently resides in Downers Grove, Illinois with his wife Diane and his daughter Kristyn. Table of Contents Introduction Import Statements JDBC Drivers Driver Types Database URLs Establishing a Connection Using DriverManager Using JNDI Examining Database MetaData Executing Dynamic SQL Executing DDL Executing INSERT, UPDATE, or DELETE Statements Executing SELECT Statements Executing Precompiled SQL Executing a Stored Procedure Retrieving Query Results Navigating a Result Set Accessing Column Values Inserting, Updating, and Deleting Rows in a ResultSet Dynamically Determining Result Set Characteristics SQL/Java Data Type Mapping Handling NULL Values Detecting NULL Values with wasNull( ) Detecting NULL Values with BigDecimal Setting a Column to a NULL Value Batching Inserts and Updates Working with Large Objects Inserting a BLOB Retrieving a BLOB User-Defined Data Types Creating a Java Class for a UDT Updating a Type Map Inserting a UDT Selecting a UDT Row Sets Escape Syntax Transaction Management The JDBC API Long Description JDBC--the Java Database Connectivity specification--is a complex set of application programming interfaces (APIs) that developers need to understand if they want their Java applications to work with databases. JDBC is so complex that even the most experienced developers need to refresh their memories from time to time on specific methods and details. But, practically speaking, who wants to stop and thumb through a weighty tutorial volume each time a question arises? The answer is the "JDBC Pocket Reference, a data-packed quick reference that is both a time-saver and a lifesaver. The "JDBC Pocket Reference offers quick look-ups for all methods of the standard JDBC classes. These include concise reviews of the procedures for common JDBC tasks such as connecting to a database, executing stored procedures, executing DDL and the like. Youll find documentation of the connect string formats for the most common databases, including Oracle, SQL-Server, and PostgreSQL. Youll even find information on working with large objects, and on using SQL99 user defined datatypes to work with object-relational data. Searching for this sort of material through large tutorials is frustrating and a waste of time, but this pocket-sized book is easy to take anywhere and makes finding the information you need a snap. OReillys Pocket References have become a favorite among developers everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When youve reached a sticking point and need to get to the answer quickly, the new "JDBC Pocket Reference is the book youll want close at hand. Details ISBN0596004575 Author Donald Bales Short Title JDBC PCKT REF Pages 152 Publisher OReilly Media Language English ISBN-10 0596004575 ISBN-13 9780596004576 Media Book Format Paperback Year 2003 Country of Publication United States Place of Publication Sebastopol Residence US Illustrations black & white illustrations Subtitle A Quick Guide for Programmers DOI 10.1604/9780596004576 AU Release Date 2003-03-04 NZ Release Date 2003-03-04 US Release Date 2003-03-04 UK Release Date 2003-03-04 Imprint OReilly Media Edited by Fu-Chan Wei Birth 1945 Affiliation Consultant Urological Surgeon, Royal Bournemouth Hospital, and Visiting Professor, Bournemouth University, Bournemouth, UK Position Contributor Qualifications MD Publication Date 2003-03-04 DEWEY 005.133 Audience Undergraduate Series Pocket References Ser. We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:8211590;

Price: 20.88 AUD

Location: Melbourne

End Time: 2024-11-25T03:48:54.000Z

Shipping Cost: 0 AUD