1.

Record Nr.

UNINA9911019647703321

Autore

Bai Ying <1956->

Titolo

Practical database programming with Java / / Ying Bai

Pubbl/distr/stampa

Hoboken, N.J., : Wiley, c2011

ISBN

9786613227928

9781118104699

1118104692

9781283227926

1283227924

9781118104668

1118104668

Descrizione fisica

1 online resource (947 p.)

Classificazione

COM051230

ST 250

Disciplina

005.13/3

Soggetti

Database management - Computer programs

Database design

Java (Computer program language)

Computer software - Development

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Description based upon print version of record.

Nota di bibliografia

Includes bibliographical references and index.

Nota di contenuto

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.

Sommario/riassunto

"This important resource offers a detailed description about the



practical considerations and applications in database programming using Java NetBeans 6.8 with authentic examples and detailed explanations. This book provides readers with a clear picture as to how to handle the database programming issues in the Java NetBeans environment. The book is ideal for classroom and professional training material. It includes a wealth of supplemental material that is available for download including Powerpoint slides, solution manuals, and sample databases"--