Covers fundamental and advanced Java database programming techniques for beginning and experienced readers This book covers the practical considerations and applications in database programming using Java NetBeans IDE, JavaServer Pages, JavaServer Faces, and Java Beans, and comes complete with authentic examples and detailed explanations.
Two data-action methods are developed and presented in this important resource. With Java Persistence API and plug-in Tools, readers are directed step by step through the entire database programming development process and will be able to design and build professional data-action projects with a few lines of code in mere minutes. The second method, runtime object, allows readers to design and build more sophisticated and practical Java database applications.
Advanced and updated Java database programming techniques such as Java Enterprise Edition development kits, Enterprise Java Beans, JavaServer Pages, JavaServer Faces, Java RowSet Object, and Java Updatable ResultSet are also discussed and implemented with numerous example projects.
Ideal for classroom and professional training use, this text also features:
- A detailed introduction to NetBeans Integrated Development Environment
- Java web-based database programming techniques (web applications and web services)
- More than thirty detailed, real-life sample projects analyzed via line-by-line illustrations
- Problems and solutions for each chapter
- A wealth of supplemental material available for download from the book's ftp site, including PowerPoint slides, solution manual, JSP pages, sample image files, and sample databases
- Coverage of two popular database systems: SQL Server 2008 and Oracle
This book provides undergraduate and graduate students as well as database programmers and software engineers with the necessary tools to handle the database programming issues in the Java NetBeans environment.
To obtain instructor materials please send an email to: [email protected]
Preface xxiii 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
Ying Bai , PhD, is a Professor in the Department of Computer Science and Engineering at Johnson C. Smith University. He has extensive experience in database programming, software programming, and robotic controls. Dr. Bai is a Senior Member of the IEEE and a member of the ACM. He has published eight books and more than thirty papers on database programming, interface programming, and fuzzy logic controls.
