Practical Database Programming with Java
by Bai, YingEdition: 1st
Format: Paperback
Pub. Date: 2011-09-13
Publisher(s): Wiley-IEEE Press
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $137.70
Buy New
Arriving Soon. Will ship when available.
$131.14
Rent Textbook
Select for Price
Rent Digital
$117.60
Used Textbook
We're Sorry
Sold Out
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
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.
Author Biography
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.
Table of Contents
| Preface | p. xxiii |
| Acknowledgments | p. xxv |
| Introduction | p. 1 |
| What This Book Covers | p. 2 |
| How This Book Is Organized and How to Use This Book | p. 3 |
| How to Use the Source Code and Sample Databases | p. 5 |
| Instructor and Customer Support | p. 6 |
| Homework Solutions | p. 7 |
| Introduction to Databases | p. 9 |
| What Are Databases and Database Programs? | p. 10 |
| Develop a Database | p. 12 |
| Sample Database | p. 13 |
| Identifying Keys | p. 17 |
| Define Relationships | p. 18 |
| ER Notation | p. 21 |
| Data Normalization | p. 21 |
| Database Components in Some Popular Databases | p. 26 |
| Create Microsoft Access Sample Database | p. 34 |
| Create Microsoft SQL Server | p. 2008 |
| Create Oracle 10g XE Sample Database | p. 61 |
| Chapter Summary | p. 85 |
| JDBC API and JDBC Drivers | p. 89 |
| What Are JDBC and JDBC API? | p. 89 |
| JDBC Components and Architecture | p. 90 |
| How Does JDBC Work? | p. 92 |
| JDBC Driver and Driver Types | p. 95 |
| JDBC Standard Extension API | p. 99 |
| Chapter Summary | p. 108 |
| JDBC Application Design Considerations | p. 113 |
| JDBC Application Models | p. 113 |
| JDBC Applications Fundamentals | p. 115 |
| Chapter Summary | p. 151 |
| Introduction to NetBeans IDE | p. 155 |
| Overview of the NetBeans IDE 6.8 | p. 156 |
| Installing and Confi guring the NetBeans IDE 6.8 | p. 161 |
| Exploring NetBeans IDE 6.8 | p. 164 |
| Chapter Summary | p. 312 |
| Building Two-Tier Client-Server Applications | p. 317 |
| Query Data from Databases | p. 319 |
| Query Data Using Java Persistence API Wizards | p. 319 |
| Java Persistence APIs | p. 319 |
| Query Data Using Java Persistence API Wizards (JPA) | p. 321 |
| Query Data Using Java Runtime Objects Method | p. 383 |
| Introduction to Runtime Object Method | p. 383 |
| Create a Java Application Project to Access the SQL Server Database | p. 384 |
| Create a Java Application Project to Access the Oracle Database | p. 441 |
| Chapter Summary | p. 455 |
| Insert, Update, and Delete Data from Databases | p. 463 |
| Insert, Update and Delete Data Using Java Persistence API Wizards | p. 463 |
| Perform Data Manipulations to SQL Server Database Using JPA Wizards | p. 464 |
| Perform Data Manipulations to Oracle Database Using JPA Wizards | p. 482 |
| Insert, Update and Delete Data Using Java Runtime Objects Method | p. 488 |
| Perform Data Manipulations to SQL Server Database Using Java Runtime Object | p. 488 |
| Perform Data Manipulations to Oracle Database Using Java Runtime Object | p. 502 |
| Perform Data Manipulations Using Updatable ResultSet | p. 510 |
| Perform Data Manipulations Using Callable Statements | p. 522 |
| Chapter Summary | p. 550 |
| Building Three-Tier Client-Server Applications | p. 555 |
| Developing Java Web Applications to Access Databases | p. 557 |
| A Historical Review about Java Web Application Development | p. 557 |
| Java EE Web Application Model | p. 597 |
| The Architecture and Components of Java Web Applications | p. 599 |
| Getting Started with Java Web Applications Using NetBeans IDE | p. 611 |
| Build Java Web Project to Access SQL Server Database | p. 625 |
| Build Java Web Project to Access and Manipulate Oracle Database | p. 690 |
| Chapter Summary | p. 764 |
| Developing Java Web Services to Access Databases | p. 769 |
| Introduction to Java Web Services | p. 770 |
| The Structure and Components of SOAP-Based Web Services | p. 772 |
| The Procedure of Building a Typical SOAP-Based Web Service Project | p. 774 |
| Getting Started with Java Web Services Using NetBeans IDE | p. 786 |
| Build Java Web Service Projects to Access SQL Server Database | p. 787 |
| Build a Windows-Based Web Client Project to Consume the Web Service | p. 795 |
| Build a Web-Based Client Project to Consume the Web Service | p. 801 |
| Build Java Web Service to Insert Data into the SQL Server Database | p. 808 |
| Build a Windows-Based Web Client Project to Consume the Web Service | p. 811 |
| Build a Web-Based Client Project to Consume the Web Service | p. 815 |
| Build Java Web Service to Update and Delete Data from the SQL Server Database | p. 819 |
| Build a Windows-Based Web Client Project to Consume the Web Service | p. 827 |
| Build a Web-Based Client Project to Consume the Web Service | p. 834 |
| Build Java Web Service Projects to Access Oracle Databases | p. 840 |
| Build a Windows-Based Web Client Project to Consume the Web Service | p. 873 |
| Build a Web-Based Web Client Project to Consume the Web Service | p. 890 |
| Chapter Summary | p. 904 |
| Homework | p. 905 |
| Index | p. 909 |
| About the Author | p. 919 |
| Table of Contents provided by Publisher. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.