Practical Database Programming with Java

Acknowledgments xxv

Chapter 1 Introduction 1

What This Book Covers 2

How This Book Is Organized and How to Use This Book 3

How to Use the Source Code and Sample Databases 5

Instructor and Customer Support 6

Homework Solutions 7

Chapter 2 Introduction to Databases 9

2.1 What Are Databases and Database Programs? 10

2.2 Develop a Database 12

2.3 Sample Database 13

2.4 Identifying Keys 17

2.5 Define Relationships 18

2.6 ER Notation 21

2.7 Data Normalization 21

2.8 Database Components in Some Popular Databases 26

2.9 Create Microsoft Access Sample Database 34

2.10 Create Microsoft SQL Server 2008

2.11 Create Oracle 10g XE Sample Database 61

2.12 Chapter Summary 85

Chapter 3 JDBC API and JDBC Drivers 89

3.1 What Are JDBC and JDBC API? 89

3.2 JDBC Components and Architecture 90

3.3 How Does JDBC Work? 92

3.4 JDBC Driver and Driver Types 95

3.5 JDBC Standard Extension API 99

3.6 Chapter Summary 108

Chapter 4 JDBC Application Design Considerations 113

4.1 JDBC Application Models 113

4.2 JDBC Applications Fundamentals 115

4.3 Chapter Summary 151

Chapter 5 Introduction to NetBeans IDE 155

5.1 Overview of the NetBeans IDE 6.8 156

5.2 Installing and Confi guring the NetBeans IDE 6.8 161

5.3 Exploring NetBeans IDE 6.8 164

5.4 Chapter Summary 312

 PART I Building Two-Tier Client–Server Applications 317

Chapter 6 Query Data from Databases 319

Section I Query Data Using Java Persistence API Wizards 319

6.1 Java Persistence APIs 319

6.2 Query Data Using Java Persistence API Wizards (JPA) 321

Section II Query Data Using Java Runtime Objects Method 383

6.3 Introduction to Runtime Object Method 383

6.4 Create a Java Application Project to Access the SQL Server Database 384

6.5 Create a Java Application Project to Access the Oracle Database 441

6.6 Chapter Summary 455

Chapter 7 Insert, Update, and Delete Data from Databases 463

Section I Insert, Update and Delete Data Using Java Persistence API Wizards 463

7.1 Perform Data Manipulations to SQL Server Database Using JPA Wizards 464

7.2 Perform Data Manipulations to Oracle Database Using JPA Wizards 482

Section II Insert, Update and Delete Data Using Java Runtime Objects Method 488

7.3 Perform Data Manipulations to SQL Server Database Using Java Runtime Object 488

7.4 Perform Data Manipulations to Oracle Database Using Java Runtime Object 502

7.5 Perform Data Manipulations Using Updatable ResultSet 510

7.6 Perform Data Manipulations Using Callable Statements 522

7.7 Chapter Summary 550

PART II Building Three-Tier Client–Server Applications 555

Chapter 8 Developing Java Web Applications to Access Databases 557

8.1 A Historical Review about Java Web Application Development 557

8.2 Java EE Web Application Model 597

8.3 The Architecture and Components of Java Web Applications 599

8.4 Getting Started with Java Web Applications Using NetBeans IDE 611

8.5 Build Java Web Project to Access SQL Server Database 625

8.6 Build Java Web Project to Access and Manipulate Oracle Database 690

8.7 Chapter Summary 764

Chapter 9 Developing Java Web Services to Access Databases 769

9.1 Introduction to Java Web Services 770

9.2 The Structure and Components of SOAP-Based Web Services 772

9.3 The Procedure of Building a Typical SOAP-Based Web Service Project 774

9.4 Getting Started with Java Web Services Using NetBeans IDE 786

9.5 Build Java Web Service Projects to Access SQL Server Database 787

9.6 Build a Windows-Based Web Client Project to Consume the Web Service 795

9.7 Build a Web-Based Client Project to Consume the Web Service 801

9.8 Build Java Web Service to Insert Data into the SQL Server Database 808

9.9 Build a Windows-Based Web Client Project to Consume the Web Service 811

9.10 Build a Web-Based Client Project to Consume the Web Service 815

9.11 Build Java Web Service to Update and Delete Data from the SQL Server Database 819

9.12 Build a Windows-Based Web Client Project to Consume the Web Service 827

9.13 Build a Web-Based Client Project to Consume the Web Service 834

9.14 Build Java Web Service Projects to Access Oracle Databases 840

9.15 Build a Windows-Based Web Client Project to Consume the Web Service 873

9.16 Build a Web-Based Web Client Project to Consume the Web Service 890

9.17 Chapter Summary 904

Homework 905

Index 909

About the Author 919