ORACLE DATABASE PROGRAMMING WITH JAVA : ideas, designs, and implementations.

Cover
Half Title
Title
Copyright
Dedication
Contents
Preface
Acknowledgments
About the Author
Copyrights and Trademarks
Chapter 1 Introduction
	1.1 Outstanding Features of This Book
	1.2 Whom This Book Is For
	1.3 What This Book Covers
	1.4 How This Book Is Organized and How to Use This Book
	1.5 How to Use the Source Code and the Sample Database
		1.5.1 Instructor Materials and Customer Support
Chapter 2 Introduction to Databases
	2.1 What Are Databases and Database Programs?
		2.1.1 File Processing System
		2.1.2 Integrated Databases
	2.2 Developing a Database
	2.3 A Sample Database
		2.3.1 Relational Data Model
		2.3.2 Entity-Relationship (ER) Model
	2.4 Identifying Keys
		2.4.1 Primary Key and Entity Integrity
		2.4.2 Candidate Key
		2.4.3 Foreign Keys and Referential Integrity
	2.5 Define Relationships
		2.5.1 Connectivity
	2.6 ER Notation
	2.7 Data Normalization
		2.7.1 First Normal Form (1NF)
		2.7.2 Second Normal Form (2NF)
		2.7.3 Third Normal Form (3NF)
	2.8 Database Components in Some Popular Databases
		2.8.1 Microsoft Access Databases
			2.8.1.1 Database File
			2.8.1.2 Tables
			2.8.1.3 Queries
		2.8.2 SQL Server Databases
			2.8.2.1 Data Files
			2.8.2.2 Tables
			2.8.2.3 Views
			2.8.2.4 Stored Procedures
			2.8.2.5 Keys and Relationships
			2.8.2.6 Indexes
			2.8.2.7 Transaction Log Files
		2.8.3 Oracle Databases
			2.8.3.1 Data Files
			2.8.3.2 Tables
			2.8.3.3 Views
			2.8.3.4 Stored Procedures
			2.8.3.5 Initialization Parameter Files
			2.8.3.6 Control Files
			2.8.3.7 Redo Log Files
			2.8.3.8 Password Files
	2.9 Create a New Oracle XE 18c Sample Database
		2.9.1 Connect to Default Oracle Database from the Oracle SQL Developer
		2.9.2 Create an Oracle User Account for the User Schema
		2.9.3 Create LogIn Table
		2.9.4 Create Faculty Table
		2.9.5 Create Other Tables
		2.9.6 Create Relationships among Tables
			2.9.6.1 Create Relationship between LogIn and Faculty Tables
			2.9.6.2 Create Relationship between LogIn and Student Tables
			2.9.6.3 Create Relationship between Faculty and Course Tables
			2.9.6.4 Create Relationship between Student and StudentCourse Tables
			2.9.6.5 Create Relationship between Course and StudentCourse Tables
		2.9.7 Store Images in the Oracle 18c Express Edition Database
			2.9.7.1 Store Images in the FACULTY Table
			2.9.7.2 Store Images in the STUDENT Table
	2.10 A ShortCut: How to Use the Sample Database without Building It
	2.11 Chapter Summary
	Homework
Chapter 3 JDBC API and JDBC Drivers
	3.1 What Are JDBC and JDBC API?
	3.2 JDBC Components and Architecture
	3.3 How Does JDBC Work?
		3.3.1 Establish a Connection
			3.3.1.1 Using DriverManager to Establish a Connection
			3.3.1.2 Using DataSource Object to Establish a Connection
		3.3.2 Build and Execute Oracle Statements
		3.3.3 Process Results
			3.3.3.1 Using a ResultSet Object
			3.3.3.2 Using a RowSet Object
	3.4 JDBC Driver and Driver Types
		3.4.1 Type I: JDBC-ODBC Bridge Driver
		3.4.2 Type II: Native-API-Partly-Java Driver
		3.4.3 Type III: JDBC-Net-All-Java Driver
		3.4.4 Type IV: Native-Protocol-All-Java Driver
	3.5 JDBC Standard Extension API
		3.5.1 JDBC DataSource
			3.5.1.1 Java Naming and Directory Interface
			3.5.1.2 Deploy and Use a Basic Implementation of DataSource
		3.5.2 JDBC Driver-Based Connection Pooling
		3.5.3 Distributed Transactions
			3.5.3.1 Distributed Transaction Components and Scenarios
			3.5.3.2 The Distributed Transaction Process
		3.5.4 JDBC RowSet
			3.5.4.1 Introduction to Java RowSet Object
			3.5.4.2 Implementation Process of a RowSet Object
	3.6 Chapter Summary
	Homework
Chapter 4 JDBC Applications and Design Considerations
	4.1 JDBC Application Models
		4.1.1 Two-Tier Client-Server Model
		4.1.2 Three-Tier Client-Server Model
	4.2 JDBC Application Fundamentals
		4.2.1 Loading and Registering Drivers
		4.2.2 Getting Connected
			4.2.2.1 The DriverManager and Driver Classes
			4.2.2.2 Using the DriverManager.getConnection() Method
			4.2.2.3 Using the Driver.connect() Method
			4.2.2.4 The JDBC Connection URL
			4.2.2.5 Establish a Database Connection
		4.2.3 Executing Statements
			4.2.3.1 Overview of Statement Objects and Their Execution Methods
			4.2.3.2 Using the Statement Object
				4.2.3.2.1 Creating the Statement Object
				4.2.3.2.2 Executing the Statement Object
			4.2.3.3 Using the PreparedStatement Object
				4.2.3.3.1 Creating the PreparedStatement Object
				4.2.3.3.2 Setting the Input Parameters
				4.2.3.3.3 Set Primitive Data Type and Object IN Values
				4.2.3.3.4 Executing the PreparedStatement Object
			4.2.3.4 Using the CallableStatement Object
				4.2.3.4.1 Building a CallableStatement Query String
				4.2.3.4.2 Creating the CallableStatement Object
				4.2.3.4.3 Setting the Input Parameters
				4.2.3.4.4 Registering the Output Parameters
				4.2.3.4.5 Executing the CallableStatement Object
			4.2.3.5 More about the Execution Methods
			4.2.3.6 Creating and Executing Oracle Statements
				4.2.3.6.1 Creating and Executing DDL Statements
				4.2.3.6.2 Creating and Executing DML Statements
				4.2.3.6.3 JDBC Escape Syntax
		4.2.4 Retrieving Results
			4.2.4.1 The ResultSet Interface
			4.2.4.2 Getting and Processing the ResultSet Object
				4.2.4.2.1 Fetching by Row
				4.2.4.2.2 Fetching by Column
		4.2.5 Using JDBC MetaData Interfaces
			4.2.5.1 Using the ResultSetMetaData Interface
			4.2.5.2 Using the DatabaseMetaData Interface
			4.2.5.3 Using the ParameterMetaData Interface
		4.2.6 Closing the Connection and Statements
	4.3 Chapter Summary
	Homework
Chapter 5 Introduction to Apache NetBeans IDE
	5.1 Overview of Apache NetBeans 12
		5.1.1 The Apache NetBeans Platform
		5.1.2 The Apache NetBeans Open-Source IDE
	5.2 Installing and Confirming the Apache NetBeans IDE
	5.3 Exploring the Apache NetBeans IDE 12
		5.3.1 An Overview of the Apache NetBeans IDE 12 GUI
		5.3.2 Build a New Java with Ant Project
			5.3.2.1 Build a Java Application Project
				5.3.2.1.1 Add a Graphical User Interface
				5.3.2.1.2 Add Other GUI-Related Components
				5.3.2.1.3 Develop the Code for Three Buttons
					5.3.2.1.3.1 Code for the Display Button
					5.3.2.1.3.2 Code for the Clear Button
					5.3.2.1.3.3 Code for the Exit Button
				5.3.2.1.4 Run the Project
			5.3.2.2 Build a Java Class Library
				5.3.2.2.1 Create a Java Class Library Project
				5.3.2.2.2 Create a Java Application Project
				5.3.2.2.3 ConFigure the Compilation Classpath
				5.3.2.2.4 Add Code to the Main.java Tab in the Java  Application Project
				5.3.2.2.5 Run the Application Project to Call the Java Library
				5.3.2.2.6 Build and Deploy the Application
				5.3.2.2.7 Distribute the Application to Other Users
			5.3.2.3 Build a Java Project with Existing Sources
			5.3.2.4 Build a Free-Form Java Project
		5.3.3 Build a Java Web Application Project
	5.4 Set up the Environment for the Apache NetBeans IDE 12 to Build Our Customer Projects
	5.5 Chapter Summary
	Homework
Part I Building Two-Tier Client-Server Applications
	Chapter 6 Querying Data from Databases
		6.1 Introduction to Runtime Object Method
		6.2 Connect to the Oracle Database 18c Express Edition CSE_DEPT
		6.3 Create a Java Application Project to Access the Oracle Database
			6.3.1 Create Graphic User Interfaces
			6.3.2 Create a Message Box with JDialog Form Class
			6.3.3 Add Oracle JDBC Driver to the Project
				6.3.3.1 Load and Register the Oracle JDBC Driver
				6.3.3.2 JDBC Uniform Resource Locators (URLs)
				6.3.3.3 Create and Manage the Statement and PreparedStatement Objects
				6.3.3.4 Use ResultSet Object
					6.3.3.4.1 Fetching by Row:
					6.3.3.4.2 Fetching by Column:
			6.3.4 Develop Code for the LogIn Table to Connect to Our Sample Database
			6.3.5 Use the PreparedStatement Object to Perform Dynamic Query for the LogIn Table
			6.3.6 Develop the Code for the SelectionFrame Form
			6.3.7 Perform a Data Query for the Faculty Table
				6.3.7.1 Add Java Package and Code for the Constructor
				6.3.7.2 Introduction to Some Popular JDBC MetaData Interfaces
					6.3.7.2.1 The DatabaseMetaData Interface
					6.3.7.2.2 The ResultSetMetaData Interface
					6.3.7.2.3 The ParameterMetaData Interface
				6.3.7.3 Use Java executeQuery() with the DatabaseMetaData Interface to Query the Faculty Table
				6.3.7.4 Use the Java execute() Method to Query the Faculty Table
				6.3.7.5 Use the Java CallableStatement Method to Query the Faculty Table
					6.3.7.5.1 Build and Formulate the CallableStatement Query String
					6.3.7.5.2 Create a CallableStatement Object
					6.3.7.5.3 Set the Input Parameters
					6.3.7.5.4 Register the Output Parameters
					6.3.7.5.5 Execute CallableStatement
					6.3.7.5.6 Retrieve the Run Results
					6.3.7.5.7 The Syntax of Creating Stored Procedures in the Oracle Database
					6.3.7.5.8 The Syntax of Creating Packages in the Oracle Database
					6.3.7.5.9 Create an Oracle Package FacultyInfo
					6.3.7.5.10 Develop the Code to Perform the CallableStatement Query
				6.3.7.6 Display an Image for the Selected Faculty Member in Canvas
					6.3.7.6.1 Operational Sequence to Display an Image in Java
					6.3.7.6.2 Create a User-Defined Method to Select and Display Desired Faculty Image
					6.3.7.6.3 Develop Additional Code to Coordinate theImage Display
				6.3.7.7 Develop the Code for the Back Button Click Event Handler
				6.3.7.8 Build and Run the Project to Test Functions of the FacultyFrame Form
			6.3.8 Perform the Data Query for the Course Table
				6.3.8.1 Import Java Packages and Code for the CourseFrame Constructor
				6.3.8.2 Create an Oracle Package, FacultyCourse
				6.3.8.3 Develop the Code to Perform the CallableStatement Query
			6.3.9 Query Data from the Student Table Using the Java RowSet Object
				6.3.9.1 Introduction to Java RowSet Object
				6.3.9.2 The Operational Procedure of Using the JDBC RowSet Object
				6.3.9.3 Coding for the Constructor of the StudentFrame Class
				6.3.9.4 Coding for the Select Button Event Handler to Query Data Using the CachedRowSet
				6.3.9.5 Display a Student Picture for the Selected Student
		6.4 Chapter Summary
		Homework
	Chapter 7 Insert, Update and Delete Data from Databases
		7.1 Perform Data Manipulations to Oracle Database Using the Java Runtime Object
		7.2 Perform Data Insertion to Oracle Database Using the Java Runtime Object Method
			7.2.1 Develop the Code for the Insert Button Event Handler
			7.2.2 Develop a Method for Data Checking Prior to Data Insertion
			7.2.3 Develop a Method for Selecting a Valid Faculty Image
			7.2.4 Find a Way to Enable the Insert Button to Begin a New Data Insertion
			7.2.5 Develop a Method for Clearing Original Faculty Information
			7.2.6 Develop the Code for the Validation of the Data Insertion
			7.2.7 Build and Run the Project to Test the Data Insertion
		7.3 Perform Data Update to Oracle Database Using the Java Runtime Object Method
			7.3.1 Modify the Code Inside the FacultyFrame Constructor
			7.3.2 Develop the Code for the Update Button Event Handler
			7.3.3 Build and Run the Project to Test the Data Update
		7.4 Perform Data Delete to Oracle Database Using the Java Runtime Object
			7.4.1 Develop the Code for the Delete Button Event Handler
			7.4.2 Build and Run the Project to Test the Data Deletion
		7.5 Perform Data Manipulation Using UpdaTable ResultSet
			7.5.1 Introduction to ResultSet Enhanced Functionalities and Categories
			7.5.2 Perform Data Manipulation Using the UpdaTable ResultSet Object
				7.5.2.1 Insert a New Row Using the UpdaTable ResultSet
				7.5.2.2 Update a Data Row Using the UpdaTable ResultSet
				7.5.2.3 Delete a Data Row Using the UpdaTable ResultSet
		7.6 Perform Data Manipulation Using Callable Statements
			7.6.1 Insert Data to the Course Table Using Callable Statements
				7.6.1.1 Develop the Oracle Stored Procedure InsertNewCourse()
				7.6.1.2 Develop the Code for the Insert Button Click Event Handler
			7.6.2 Update Data to the Course Table Using Callable Statements
				7.6.2.1 Develop the Oracle Stored Procedure UpdateCourse()
				7.6.2.2 Develop the Code for the Update Button Click Event Handler
			7.6.3 Delete Data from the Course Table Using Callable Statements
				7.6.3.1 Develop the Stored Procedure DeleteCourse()
				7.6.3.2 Develop the Code for the Delete Button Click Event Handler
		7.7 Chapter Summary
		Homework
Part II Building Three-Tier Client-Server Applications
	Chapter 8 Develop Java Web Applications to Access Databases
		8.1 A Historical Review about Java Web Application Development
			8.1.1 Using Servlet and HTML Web Pages for Java Web Applications
			8.1.2 Using JavaServer Pages Technology for Java Web Applications
			8.1.3 Using Java Help Class Files for Java Web Applications
			8.1.4 Using the JSP Implicit Object Session for Java Web Applications
				8.1.4.1 Modify the FacultyPage JSP File to Use the Session Object
				8.1.4.2 Build the Transaction JSP File, FacultyQuery.jsp
				8.1.4.3 Build the Help Class FacultyBean
			8.1.5 Using Java Beans Technology for Java Web Applications
				8.1.5.1 Modify the Help Class FacultyBean to Make It a Java Bean Class
				8.1.5.2 Build a New Starting Web Page, FacultyBeanPage
			8.1.6 Using JavaServer Faces Technology for Java Web Applications
				8.1.6.1 The Application Configuration Resource File, faces-config.xml
				8.1.6.2 Sample JavaServer Face Page Files
				8.1.6.3 The Java Bean Class File
				8.1.6.4 The Web Deployment Descriptor File, web.xml
				8.1.6.5 A Complete Run Procedure of JSF Web Applications
					8.1.6.5.1 The Java Bean–JSF Page Relationship and Page Navigation
					8.1.6.5.2 The Detailed Code for the Java Bean Class
		8.2 Java EE Web Application Model
			8.2.1 Java EE Web Applications with and without EJB
		8.3 The Architecture and Components of Java Web Applications
			8.3.1 Java EE Containers
			8.3.2 Java EE 8 APIs
				8.3.2.1 Enterprise Java Beans API Technology
				8.3.2.2 Java Servlet API Technology
				8.3.2.3 JavaServer Pages API Technology
				8.3.2.4 JavaServer Faces API Technology
				8.3.2.5 Java Transaction API
				8.3.2.6 Java Message Service API
			8.3.3 Java Web Application Life Cycle
			8.3.4 Java Web Modules
			8.3.5 Java Web Frameworks
		8.4 Build Java Web Project to Query Oracle Database
			8.4.1 Create Five Web Pages Using Microsoft Office Publisher 2007
				8.4.1.1 Create the LogIn Page
				8.4.1.2 Create the Selection Page
				8.4.1.3 Create the Faculty Page
				8.4.1.4 Create the Course Page
				8.4.1.5 Create the Student Page
			8.4.2 Setup Environments for NetBeans IDE to Build Java Web Applications
				8.4.2.1 Download and Install Required Components
				8.4.2.2 ConFigure Apache NetBeans IDE 12 and Create Our First Web Application Project
					8.4.2.2.1 Setup the Correct JDBC Driver and Java Platform
			8.4.3 Access and Query the LogIn Table Using JavaServer Pages and Help Class Files
				8.4.3.1 Modify the LogIn.jsp Page and Create LogInQuery.jsp File
				8.4.3.2 Create the Java Help Class File LogInQuery.java
				8.4.3.3 Create a Dialog Box as the Message Box
				8.4.3.4 Develop the Code for the Java Model or Java Help Class File
					8.4.3.4.1 Import Oracle-Related Package and Create the Class Constructor
					8.4.3.4.2 Build the Code for the checkLogIn() Method
					8.4.3.4.3 Build the Code for the CloseDBConnection() Method
			8.4.4 Develop the Code for the Selection Page
			8.4.5 Query the Faculty Table Using JavaServer Pages and JSP Implicit Session Object
				8.4.5.1 Query Faculty Records with Image via Web Server and Display Them in JSP Pages
				8.4.5.2 Modify the Faculty.jsp Page
				8.4.5.3 Create the FacultyProcess.jsp Page
				8.4.5.4 Create the Help Class or Java Model File, FacultyQuery.java
		8.5 Build a Java Web Project to Manipulate Data in the Oracle Database
			8.5.1 Modify the Faculty.jsp Page by Adding a File Selection Function
			8.5.2 Insert New Records to the Faculty Table Using JavaServer Pages and Java Beans
				8.5.2.1 Create a New Java Help Class File, FacultyInsertBean.java
				8.5.2.2 Modify the FacultyProcess.jsp Page to Handle Faculty Data Collection and Insertion
			8.5.3 Update and Delete Data from the Faculty Table Using JSP and Java Beans Techniques
				8.5.3.1 Create a New Java Session Bean Class
				8.5.3.2 Modify the FacultyProcess Page to Handle Faculty Data Updating
				8.5.3.3 Add a Method to the Java Bean to Perform Faculty Data Deleting
				8.5.3.4 Modify the FacultyProcess Page to Handle Faculty Data Deleting
		8.6 Query the Course Table Using JavaServer Pages and JSP Implicit Session Object
			8.6.1 Modify the Course.jsp Page
			8.6.2 Create the CourseProcess.jsp Page
			8.6.3 Create the Java Bean or Java Model File, CourseQuery.java
		8.7 Chapter Summary
		Homework
	Chapter 9 Develop Java Web Services to Access Databases
		9.1 Introduction to Java Web Services
			9.1.1 REST-Based Web Services
			9.1.2 SOAP-Based Web Services
		9.2 The Structure and Components of SOAP-Based Web Services
		9.3 The Procedure of Building a Typical SOAP-Based Web Service Project
			9.3.1 Create a New Java Web Application Project, WSTestApp
			9.3.2 Create a New Java SOAP-Based Web Service Project, WSTest
			9.3.3 Add Desired Operations to the Web Service
			9.3.4 Deploy and Test the Web Service on the Selected Container
			9.3.5 Create Web Service Clients to Consume the Web Service
		9.4 Getting Started with Java Web Services Using NetBeans IDE
		9.5 Build Java Web Service Projects to Access and Manipulate the Faculty Table
			9.5.1 Create a New Java Web Application Project, WebAppFaculty
			9.5.2 Create a New Java SOAP-Based Web Service Project, WebServiceFaculty
			9.5.3 Add the First Web Operation to Our Web Services to Perform a Data Query
			9.5.4 Build the User-Defined Method DBConnection()
			9.5.5 Add the Second Operation to Our Web Service to Query the Faculty Image
			9.5.6 Setup the Correct JDBC Driver and Java Platform for Our Web Service
			9.5.7 Deploy the Web Service Project and Test the Data Query Function
		9.6 Build a Window-Based Client Project to Consume the Web Service
			9.6.1 Copy the FacultyFrame and MsgDislog Components as GUIs
			9.6.2 Create a Web Service Reference for Our Window-Based Client Project
			9.6.3 Develop the Code to Call Our Web Service Project
			9.6.4 Build and Run Our Client Project to Query Faculty Data via Web Service
		9.7 Build a Web-Based Client Project to Consume the Web Service
			9.7.1 Create a Web-Based Client Project, WebClientFaculty_Select
			9.7.2 Create a Java Managed Bean Class, FacultyMBean
			9.7.3 Modify Three Files to Make Them Work for Our Web Client Project
			9.7.4 Add a Web Service Reference to Our Web-Based Client Project
			9.7.5 Build and Run Our Client Project to Query Faculty Data via Web Service
		9.8 Build Java Web Services to Insert Data into the Oracle Database
			9.8.1 Add a New Operation InsertFaculty() into Our Web Service Project
			9.8.2 Deploy the Web Service Project
		9.9 Build a Window-Based Client Project to Consume the Web Service
			9.9.1 Refresh the Web Service Reference for Our Window-Based Client Project
			9.9.2 Develop the Code to Call Our Web Service Project
			9.9.3 Build and Run Our Client Project to Insert Faculty Data via Web Service
		9.10 Build a Web-Based Client Project to Consume the Web Service
			9.10.1 Refresh the Web Service Reference for Our Web-Based Client Project
			9.10.2 Develop the Code to Call Our Web Service Project
			9.10.3 Build and Run Our Client Project to Insert Faculty Data via Web Service
		9.11 Build Java Web Service to Update and Delete Data from the Oracle Database
			9.11.1 Add a New Operation, UpdateFaculty(), to Perform Faculty Data Update
			9.11.2 Add a New Operation, DeleteFaculty(), to Perform Faculty Data Delete
			9.11.3 Deploy and Test the Web Service Project
		9.12 Build a Window-Based Client Project to Consume the Web Service
			9.12.1 Refresh the Web Service Reference for Our Window-Based Client Project
			9.12.2 Build the Code to Call the UpdateFaculty() Operation
			9.12.3 Build the Code to Call the DeleteFaculty() Operation
			9.12.4 Build and Run Our Client Project to Update and Delete Faculty Record via Web Service
		9.13 Build a Web-Based Client Project to Consume the Web Service
			9.13.1 Refresh the Web Service Reference for Our Web-Based Client Project
			9.13.2 Develop the Code to Call Our Web Service Operation, UpdateFaculty()
			9.13.3 Develop the Code to Call Our Web Service Operation DeleteFaculty()
			9.13.4 Add Necessary Code to the FacultyProcess.jsp Page to Do Data Updating and Deleting
			9.13.5 Build and Run Our Client Project to Update and Delete Faculty Record via Web Service
		9.14 Build Java Web Service Project to Access Course Table in Our Sample Database
			9.14.1 Create a New Java Web Application Project, WebAppCourse
			9.14.2 Create a New Java SOAP-Based Web Service Project, WebServiceCourse
			9.14.3 The Organization of Web Service Operations
			9.14.4 Create and Build Web Service Operations
				9.14.4.1 Create and Build the Web Operation QueryCourseID()
				9.14.4.2 Build and Run the Web Service to Test the CourseID Query Function
				9.14.4.3 Create and Build the Web Operation QueryCourse()
				9.14.4.4 Create and Build the Web Operation InsertCourse()
				9.14.4.5 Create and Build the Web Operation UpdateCourse()
				9.14.4.6 Create and Build the Web Operation DeleteCourse()
		9.15 Build Windows-Based Project to Consume the Web Service Project
			9.15.1 Update the Web Service Reference for Our Window-Based Client Project
			9.15.2 Develop the Code to Query Course Information from our Web Service
			9.15.3 Build Code for the Select Button Event Handler to Query CourseIDs
			9.15.4 Build Code for the CourseListValueChanged() Method to Get Course Details
			9.15.5 Build Code for the Insert Button Event Handler to Insert a New Course
			9.15.6 Build Code for the Update Button Method to Update Course Records
			9.15.7 Build Code for the Delete Button Method to Delete Course Records
		9.16 Build a Web-Based Client Project to Consume our Web Service Project
			9.16.1 Create a Web-Based Client Project, WebClientCourse_Select
			9.16.2 Add a Web Service Reference to Our Web-Based Project and Change the Ports
			9.16.3 Modify the Java Bean CourseQuery.java and the Control File CourseProcess.jsp
			9.16.4 Build and Run Our Client Project to Query Course Record via Our Web Service
			9.16.5 Build a Web Client Project to Insert New Course Records via Our Web Service
			9.16.6 Build Our Client Project to Update Course Records via Our Web Service
			9.16.7 Build Our Client Project to Delete Course Records via Our Web Service
		9.17 Chapter Summary
		Homework
Appendix A: Download and Install Oracle Database XE 18c
Appendix B: Download and Install Apache NetBeans 12.0
Appendix C: Download and Install Oracle SQL Developer
Appendix D: Download and Install DevExpress WinForms
Appendix E: How to Use the Sample Database
Appendix F: How to Export the Sample Database
Appendix G: Download and Install dotConnect Express
Appendix H: Download JDBC Driver for Oracle XE 18c
Appendix I: Download and Install Tomcat Server 8.0.27
Appendix J: Download and Install Java JDK 8
Appendix K: Trouble Shooting for the WS00041 Service Exception
Appendix L: Download and Install Apache NetBeans 12.4
Appendix M: ConFigure Apache NetBeans 12.0 for Initial Runs
Appendix N: Download and Install Java JDK 14
Index