Read more
Informationen zum Autor 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. Klappentext Covers fundamental and advanced Java database programming techniques for beginning and experienced readersThis 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 OracleThis 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: pressbooks@ieee.org Zusammenfassung 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. Inhaltsverzeichnis 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 Sample Database 44 2.11 Create Oracle 10g XE Sample Database 61 2.12 Chapter Summary 85 Homework 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...