Practical Guide for Java Programmers


  • Gregory Speegle, Baylor University, Waco, TX

JDBC: Practical Guide for Java Programmers is the quickest way to gain the skills required for connecting your Java application to a SQL database. Practical, tutorial-based coverage keeps you focused on the essential tasks and techniques, and incisive explanations cement your understanding of the API features you'll use again and again. No other resource presents so concisely or so effectively the exact material you need to get up and running with JDBC right away.

View full description


database programmers, Java programmers and developers, system designers, database administrators and upper-level undergraduate/graduate computer science students


Book information

  • Published: August 2001
  • ISBN: 978-1-55860-736-1


"A highly useful reference for students, educators, and professionals alike, who are learning to use JAVA and JDBC for interconnecting and using databases. The real world analogies and JDBC examples presented throughout the text direct the reader to the essential elements required to make the Java database connection function seamlessly within a user's application. I found the book easy to read, informative, and a great addition to standard course texts."
—Dr. Paul J. Fortier, University of Massachusetts--Dartmouth

Table of Contents

1 - Introduction to JDBC1.1 An Analogy1.2 Connection/Statement Example1.3 Example Database 1.4 Analogy Continued 1.5 Simple Example 1.6 API Summary 1.7 Going Beyond2 - Presenting Information to Users2.1 JTables 2.2 JTable Example with Abstract Table Model 2.3 JDBC 2.0 ResultSets 2.4 Serializing ResultSets 2.5 API Summary 2.6 Going Beyond3 - Querying the Database3.1 Prepared Statements 3.2 CallableStatements 3.3 Summary API 3.4 Going Beyond4 - Updating the Database 4.1 Simple Updates 4.2 BatchUpdates 4.3 Update Through ResultSets 4.4 API Summary 4.5 Going Beyond5 - Advanced JDBC Topics 5.1 Drivers 5.2 Metadata 5.3 Transactions 5.4 Blobs 5.5 API Summary 5.6 Going Beyond6 - An eCommerce Example 6.1 Applets6.2 Servlets 6.3 Multi-Tiered Architecture Example 6.3.1 The Applet 6.3.2 The Servlet 6.3.3 The Stored Procedures6.4 Going Beyond7 - How to Stay Current with JDBC 7.1 JDBC 3.0 7.2 javax.sql Package 7.3 The Rest of java.sql7.4 JSP7.5 Security8 - Appendix 8.1 GUIJDBC 8.2 Communication 8.3 JSP Example