Table of Contents

• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Conventions
• 1 Aims and Objectives of This Book
  • 1.1 Architecture of the Application
  • 1.2 Part I
  • 1.3 Part II
• 2 Using Java with Oracle Database
  • 2.1 Java Database Connectivity Driver (JDBC)
  • 2.2 Universal Connection Pool
  • 2.3 Java in the Database (OJVM)
• 3 Overview of the HR Web Application
  • 3.1 Functionalities of the HR Web Application
  • 3.2 Components and Repositories
• 4 Getting Started with the Application
  • 4.1 What You Need to Install
    • 4.1.1 Oracle Database 12c Release 2 (12.2)
      • 4.1.1.1 Unlocking the HR Schema for the JDBC Application
    • 4.1.2 J2SE or JDK
    • 4.1.3 Integrated Development Environment
    • 4.1.4 Web Server
  • 4.2 Oracle Database Cloud — Starting with Oracle Database as a Service
  • 4.3 Verifying the Oracle Database 12c Release 2 (12.2) Installation
• 5 Connecting to Oracle Database 12c Release 2 (12.2)
  • 5.1 Creating an Employee Java Bean
  • 5.2 Creating a Java Bean Interface for a JDBC Connection
  • 5.3 Creating a Java Bean Implementation for a JDBC Connection
  • 5.4 Creating a Servlet to Process the Request
  • 5.5 Create an HTML Page to Display Results
  • 5.6 Create a CSS File
• 6 Search by Employee ID
  • 6.1 Employee Java Bean
  • 6.2 Create a Method in Java Bean for Search by Employee ID
  • 6.3 Implement a Method getEmployee() for Search by Employee ID
  • 6.4 Create a New HTML for Search by Employee Id
• 7 Update an Employee Record
  • 7.1 Create a Method in Java Bean for Search by Employee’s First Name
  • 7.2 Implement a Method getEmployeebyFn() for Search by Employee name
• 8 Best Practices
• Index