WHAT THIS BOOK COVERS – Introduction

1.3   WHAT THIS BOOK COVERS

Nine chapters are included in this book. The contents of each chapter can be summarized as follows.

• Chapter 1 provides an introduction to and summary of the entire book.

• Chapter 2 provides detailed discussions and analyses of the structures and components of relational databases. Some key technologies in developing and designing databases are also given and discussed in this chapter. The procedure and components used to develop a practical relational database with Oracle 18c XE are analyzed in detail with some real data Tables in our sample database CSE _ DEPT.

• Chapter 3 provides discussions of JDBC APIs and drivers. A detailed introduction to the components and architecture of JDBC is given with step-by-step illustrations. Four popular types of JDBC drivers are discussed and analyzed with both their advantages and disadvantages emphasized in actual database applications. The working structure and operational principles of using JDBC drivers to establish a valid database connection, build a query statement and process the query results are also discussed and presented in

detail. One of the most useful tools, JDBC RowSet, is also discussed and analyzed with some example code.

• Chapter 4 provides a detailed discussion and analysis of JDBC design and actual applica-tion considerations. The fundamentals of using JDBC to access and manipulate data against databases are discussed and introduced with example code. Different JDBC interfaces, including the ResultSet, ResultSetMetaData, DatabaseMetaData and ParameterMetaData, are introduced and discussed with example code.

• Chapter 5 provides a detailed description of the Apache NetBeans IDE 12.4, including the components and architecture. This topic is necessary for college students who have no knowledge of the Apache NetBeans IDE. Starting from an introduction to installing the Apache NetBeans IDE 12.4, this chapter goes through each aspect of the NetBeans IDE 12.4, including the NetBeans Platform, NetBeans Open Source and all plug-in tools. Different projects built with the Apache NetBeans IDE 12.4 are also discussed and pre-sented in detail, with one example project.

• Starting from Chapter 6, real database programming techniques with Java and query data from a database are provided and discussed. This chapter covers the so-called runtime object method to develop and build professional data-driven applications. Detailed discus-sions and descriptions of how to build professional and practical database applications using this runtime object method are provided, with three real projects. In addition to basic query techniques, advanced query methods such as PreparedStatement, CallableStatement and Oracle stored procedures are also discussed and implemented in this chapter, with some real sample projects.

• Chapter 7 provides detailed discussions and analyses of how to insert, update and delete data from an Oracle database—Oracle 18c XE. This chapter covers some techniques to manipulate data in our sample database using the runtime object method. Nine real proj-ects are used to illustrate how to perform data manipulations against our sample database, CSE _ DEPT, which is built with Oracle SQL Developer. Professional and practical data validation methods are also discussed in this chapter to confirm data manipulations. Some advanced data manipulation techniques and methods, such as UpdaTable ResultSet and Callable Statements, are also introduced and discussed in this chapter, with real projects.

• Chapter 8 provides introductions to and discussions of the developments and implementa-tions of three-tier Java Web applications in the NetBeans IDE 12.4 environment. At the beginning of this chapter, a detailed and complete historical review of Java Web appli-cation development is provided, and this part is especially important and useful to col-lege students or programmers who do not have any background knowledge of Java Web application development and implementation. Following the introduction section, different techniques used to build Java Web applications are introduced and discussed in detail. The target database, CSE _ DEPT, which is built with Oracle SQL Developer, is utilized as the objective database for these development and building processes. JavaServer Pages and Java Beans techniques are also discussed and used in four real Web application projects.

• Chapter 9 provides introductions to and discussions of the developments and implementa-tions of Java Web Services in the NetBeans IDE 12.0 environment. A detailed discussion and analysis of the structure and components of the Java Web services is provided at the beginning of this chapter. Each Web service contains different operations that can be used to access different databases and perform the desired data actions, such as Select, Insert, Update and Delete via the Internet. To consume those Web services, different Web service client projects are also developed in this chapter. Both Windows-based and Web-based cli-ent projects are discussed and built for each kind of Web service listed previously. In all, 17 projects, including 3 Web service projects and 14 associated Web service client projects, are developed in this chapter. All projects have been debugged and tested and can be run in most Windows-compatible operating systems such as Windows 10.