First-Cut Business Service Development in Java

Drawer USS Code 39 in Java First-Cut Business Service Development

Now that you are armed with an understanding of the building blocks of ADF Business Components, the next step is to put that knowledge into action and build ADF Business Components based on database tables. There are a number of different ways to build ADF Business Components; however, JDeveloper provides an incredibly powerful wizard that creates entity objects, associations, view objects, view links, and an application module, based on a number of database tables, all in one go. This is a great way of getting a first cut of your business services.

The goal of this book is to give you a quick start on how to build a Fusion application, and as such, many of the features of JDeveloper and Oracle ADF are explained in the context of building a Fusion application. However, the book doesn t aim to hold your hand through every keypress or demonstrate every feature within that sample application. Instead, the aim is to explain the concepts, how they can be built in JDeveloper, and then how they can be used in a typical Fusion application. You can then explore, build, and experiment at your convenience after all, hands-on is the best way to learn. Where an application example is used, it is based on the Oracle OE (Order Entry) schema that is available with the Oracle database. This schema includes a number of tables for implementing an order entry system based around customers, orders, order items, and products. The scenario is that the application is being built to manage customer orders. The application should allow the creation, viewing, and editing of customers and their order information. Each customer can have zero or more orders, and each order is made up of one or more order items. The application has a number of pages for viewing and displaying data that is presented in a number of different ways, including data entry forms, tables, and graphs. The application also includes business rules to validating data, and features such as search facilities and lists of values. A completed application that demonstrates the features discussed in this book is available to download from https://qsfusionsample.samplecode.oracle.com/.

Creating new ADF Business Components from database tables is reasonably quick and intuitive. Assuming you ve already created an empty application based on the Fusion Web Application template, as described in 3, select the Model project and then select File | New. In the New Gallery dialog, select ADF Business Components and then Business Components from Tables. This launches the Create Business Components from Tables wizard, which steps you through creating entity objects, updatable view objects, read-only view objects, and an application module.

If you haven t yet created a connection to your database, the Initialize Business Components Project dialog prompts you to create a connection to the database. Click the green plus sign, then enter a name for the connection in the Connection Name field. Enter values for the Username,

4:

Password, Host Name, and SID, and then click Test Connection to confirm the connection to the database.

TIp You can alternatively create a database connection by selecting File | New and, in the New Gallery dialog, selecting Connections and then Database Connection. When you create a database connection, you can choose to create the connection as part of the application or associate the connection with the IDE. An IDE database connection adds the connection to the Resource Palette window and provides that connection for use within the IDE. You can then right-click a database connection in the Resource Palette to browse the database or add that connection to the current project.