JDBC Recipes: A Problem-Solution Approach

by Mahmoud Parsian

Overview

JDBC Recipes provides easy-to-implement, usable solutions to problems in relational databases that use JDBC. You will be able to integrate these solutions into your web-based applications, such as Java servlets, JavaServer Pages, and Java server-side frameworks. This handy book allows you to cut and paste the solutions without any code changes.

This book focuses on topics that have been ignored in most other JDBC books, such as database and result set metadata. It will help you develop database solutions, like adapters, connectors, and frameworks using Java/JDBC. The insightful solutions will enable you to handle all data types, including large binary objects. A unique feature of the book is that it presents JDBC solutions (result sets) in XML.

Product Details

ISBN-13:	9781430211990
Publisher:	Apress
Publication date:	11/28/2014
Edition description:	Softcover reprint of the original 1st ed.
Pages:	636
Product dimensions:	7.52(w) x 9.25(h) x 0.05(d)

About the Author

Mahmoud Parsian, Ph.D. is a Sun Certified Java Programmer and senior lead software engineer for AskJeeves.com, and he has expertise in Java database programming and development. His honors include the following: Ask Jeeves Bright Star Award, Octopus Award for successive release of the Octopus software, Cisco Systems Leadership Award, Individual Achievement Award, and four Specialist of the Quarter awards. Parsian has also received numerous commendation letters from customers regarding his outstanding performance and leadership on customer projects.

Table of Contents

Introducing JDBC.- Exploring JDBC’s Novel Feature.- Making Database Connections.- Making Database Connections Using DataSource.- Exploring the ResultSet Interface.- Working with Scrollable and Updatable ResultSet Objects.- Reading and Writing BLOBs.- Reading and Writing CLOBs.- Working with Date, Time, and Timestamp in JDBC.- Handling Exceptions in JDBC.- Exploring the Statement.- Working with the PreparedStatement.- Passing Input Parameters to PreparedStatement.- Exploring JDBC Utilities.