Data Models and JSP

Application developers; data architects; technical architects; and anyone with experience in Java programming, XML parsing and editing, basic JavaServer page and HTML page coding, and a basic understanding of SQL database table structure and data querying.

Prerequisite
None

Expected Duration
71 minutes

Description
The Oracle Commerce Platform consists of a data and presentation layer. Understanding the data relationships, and how that data is accessed is a fundamental skill for any developer. In this course, you will be able to describe the data relationships in the Oracle Commerce Platform, create data sources, describe form handling mechanisms, and write robust JSP. This course is one of a series in the Skillsoft learning path that covers the material for the Oracle Commerce Platform Fundamentals for Developers.

Objective

Data Element Relationships

  • start the course
  • choose the collection type when working with ordered/unordered data
  • name the Java collection types that bind keys to values
  • identify when two items have a many-to-many relationship
  • describe how auxiliary and multi tables are joined with the primary table
  • list the steps in setting up a test data source
  • describe how to make your repository accessible in the ACC

SQL Repository Data Models

  • identify how item types can be created as subtypes of other item types
  • list the attributes of item descriptors for a subtype item
  • identify how a composite ID is a unique ID represented by more than one column in the databasecomposite ID is a unique ID represented by more than one column in the database.
  • list the ways how grouping properties can improve performance
  • describe how to configure cascading relationships

Repository Form Handlers

  • describe the mechanism Oracle Commerce uses for handling forms
  • specify how Oracle Commerce normally accesses properties of beans
  • configure fields of a form page by associating them with the properties of the form handler
  • specify how to provide methods to select from an enumerated list of possible options
  • list the methods that can be called on submission to process the data in a form

JSP Design

  • write a JSP page using form page redirection to set the action page back to the form page
  • list the properties RepositoryFormHandler uses to help manage form errors
  • describe how form submission and handling occurs, and how request-scoped form handlers work
  • describe how form handlers know which item in the repository to update

Practice: Request Repository Form Handler

  • build a JSP form using collections, tag, and error handling

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.