book

Core Java, Volume II: Advanced Features, 13th Edition

by Cay S. Horstmann

August 2024

Intermediate to advanced

988 pages

24h 37m

English

Pearson

Read now

Unlock full access

Includes

Has Sandbox

To the Reader A Tour of This Book Conventions
1.1. From Iterating to Stream Operations1.2. Stream Creation1.3. The filter, map, and flatMap Methods1.4. Extracting Substreams and Combining Streams1.5. Other Stream Transformations1.6. Simple Reductions1.7. The Optional Type1.8. Collecting Results1.9. Collecting into Maps1.10. Grouping and Partitioning1.11. Downstream Collectors1.12. Reduction Operations1.13. Primitive Type Streams1.14. Parallel Streams
2.1. Input/Output Streams2.2. Reading and Writing Binary Data2.3. Object Input/Output Streams and Serialization2.4. Working with Files2.5. Memory-Mapped Files2.6. File Locking2.7. Regular Expressions
3.1. Introducing XML3.2. The Structure of an XML Document3.3. Parsing an XML Document3.4. Validating XML Documents3.5. Locating Information with XPath3.6. Using Namespaces3.7. Streaming Parsers3.8. Generating XML Documents3.9. XSL Transformations
4.1. Connecting to a Server4.2. Implementing Servers4.3. Getting Web Data4.4. The HTTP Client4.5. The Simple HTTP Server4.6. Sending E-Mail
5.1. The Design of JDBC5.2. The Structured Query Language5.3. JDBC Configuration5.4. Working with JDBC Statements5.5. Query Execution5.6. Scrollable and Updatable Result Sets5.7. Row Sets5.8. Metadata5.9. Transactions5.10. Connection Management in Web and Enterprise Applications
6.1. The Time Line6.2. Local Dates6.3. Date Adjusters6.4. Local Time6.5. Zoned Time6.6. Formatting and Parsing6.7. Interoperating with Legacy Code
7.1. Locales7.2. Number Formats7.3. Date and Time7.4. Collation and Normalization7.5. Message Formatting7.6. Text Boundaries7.7. Text Input and Output7.8. Resource Bundles7.9. A Complete Example

8.1. The Compiler API8.2. Scripting for the Java Platform
9.1. Class Loaders9.2. User Authentication9.3. Digital Signatures9.4. Encryption
10.1. A History of Java User Interface Toolkits10.2. Displaying Frames10.3. Displaying Information in a Component10.4. Event Handling10.5. The Preferences API
11.1. Swing and the Model-View-Controller Design Pattern11.2. Introduction to Layout Management11.3. Text Input11.4. Choice Components11.5. Menus11.6. The Grid Bag Layout11.7. Custom Layout Managers11.8. Dialog Boxes
12.1. Tables12.2. Working with Rows and Columns12.3. Cell Rendering and Editing12.4. Trees12.5. Advanced AWT12.6. Raster Images12.7. Printing
13.1. Calling a C Function from a Java Program13.2. Numeric Parameters and Return Values13.3. String Parameters13.4. Accessing Fields13.5. Encoding Signatures13.6. Calling Java Methods13.7. Accessing Array Elements13.8. Handling Errors13.9. Using the Invocation API13.10. A Complete Example: Accessing the Windows Registry13.11. Foreign Functions: A Glimpse into the Future

Content preview from Core Java, Volume II: Advanced Features, 13th Edition

Chapter 5 ▪ Database Programming

In 1996, Sun released the first version of the JDBC API. This API lets programmers connect to a database to query or update it using the Structured Query Language (SQL). (SQL, usually pronounced “sequel,” is an industry standard for relational database access.) JDBC has since become one of the most commonly used APIs in the Java library.

JDBC has been updated several times. As this book is published, JDBC 4.3, the version included with Java 9, is the most current version.

In this chapter, I will explain the key ideas behind JDBC. I will introduce you to (or refresh your memory of) SQL, the industry-standard Structured Query Language for relational databases. The chapter has enough details and examples to ...