Oracle Database Programming with Java Ideas, Designs, and Implementations

Databases have become an integral part of modern life. Today’s society is an information-driven society, and database technology has a direct impact on all aspects of daily life. Decisions are routinely made by organizations based on the information collected and stored in databases. Database management systems such as Oracle are crucial to apply data in industrial or commercial systems. Equally crucial is a graphical user interface (GUI) to enable users to access and manipulate data in databases. The Apache NetBeans IDE with Java is an ideal candidate for developing a GUI with programming functionality. Oracle Database Programming with Java: Ideas, Designs, and Implementations is written for college students and software programmers who want to develop practical and commercial database programming with Java and relational databases such as Oracle Database XE 18c. The book details practical considerations and applications of database programming with Java and is filled with authentic examples as well as detailed explanations. Advanced topics in Java Web, like Java Web Applications and Java Web Services, are covered in real project examples to show how to handle the database programming issues in the Apache NetBeans IDE environment. This book features: A real sample database, CSE _ DEPT, which is built with Oracle SQL Developer, provided and used throughout the book Step by step, detailed illustrations and descriptions of how to design and build a practical relational database Fundamental and advanced Java database programming techniques practical to both beginning students and experienced programmers Updated Java desktop and Web database programming techniques, such as Java Enterprise Edition 7, JavaServer Pages, JavaServer Faces, Enterprise Java Beans, Web applications and Web services, including GlassFish and Tomcat Web servers More than 30 real database programming projects with detailed illustrations Actual JDBC APIs and JDBC drivers, along with code explanations Homework and selected solutions for each chapter to strengthen and improve students’ learning and understanding of the topics they have studied

1 Introduction2 Introduction to Databases3 JDBC API and JDBC Drivers4 JDBC Application and Design Considerations5 Introduction to Apache NetBeans IDE I: Building Two-Tier Client-Server Applications6 Querying Data from Databases7 Insert, Update and Delete Data from Databases II: Building Three-Tier Client-Server Applications8 Develop Java Web Applications to Access Databases9 Develop Java Web Services to Access Databases Appendix A: Download and Install Oracle Database XE 18cAppendix B: Download and Install Apache NetBeans 12.0Appendix C: Download and Install Oracle SQL DeveloperAppendix D: Download and Install DevExpress WinFormsAppendix E: How to Use theSample DatabaseAppendix F: How to Export the Sample DatabaseAppendix G: Download and Install dotConnect ExpressAppendix H: Download JDBC Driver for Oracle XE 18cAppendix I: Download and Install Tomcat Server 8.027Appendix J: Download and Install Java JDK 8Appendix K: Trouble Shooting for WS00041 Service ExceptionAppendix L: Download and Install Apache NetBeans 12.4Appendix M: Configure Apache NetBeans 12.0 for Initial RunsAppendix N: Download and Install Java JDK 14

Dr. Ying Bai is a Professor in the Department of Computer Science and Engineering at Johnson C. Smith University. His special interests include Artificial intelligences, soft-computing, mix-language programming, fuzzy logic and deep learning, robotic controls, robots calibrations, and database programming. His industry experience includes positions as software and senior software engineers at companies such as Motorola MMS, Schlumberger ATE Technology, Immix TeleCom, and Lam Research. Since 2003, Dr. Bai has published 18 books with publishers such as Prentice Hall, CRC Press LLC, Springer, Cambridge University Press and Wiley IEEE Press. The Russian translation of his first book titled Applications Interface Programming Using Multiple Languages was published by Prentice Hall in 2005. The Chinese translation of his 8th book titled Practical Database Programming with Visual C#.NET was published by Tsinghua University Press in China in 2011. Most of his books are about artificial intelligence and soft-computing, software interfacing and serial port programming, database programming, fuzzy logic controls, microcontroller programming as well as classical and modern control technologies. During recent years, Dr. Bai has also published more than 65 academic research papers in IEEE Trans. Journals and International conferences.