Oracle数据库2天Java开发人员指南-11g Release 2-138—版权©2007,2012,Oracle及/或其关联公司。

需积分: 5 140 浏览量更新于2023-11-24 收藏 3.59MB PDF 举报

《Oracle Database 2 Day Java开发者指南11g Release 2-138》是Oracle公司所提供的一个软件和文档，版权归Oracle及其关联公司所有。这个指南的主要作者是Deepa Aswani、Rosslynne Hefferan和Maitreyee Chaliha。其他的作者和贡献者包括Kathleen Heap、Simon Law、Kuassi Mensah、Chris Schalk、Christian Bauwens、Mark Townsend、Paul Lo和Venkatasubramaniam Iyer。该指南的目的是帮助Java开发者快速了解如何使用Oracle数据库进行开发。它提供了一些标准工具和示例代码，供开发者使用。该指南覆盖了数据库连接、SQL和PL/SQL编程、存储过程和触发器的开发等内容。在使用该指南之前，用户需要遵守许可协议中的限制，并受到知识产权法的保护。除非在许可协议中明确允许或法律允许的情况下，用户不得使用、复制、翻译、广播、修改、许可、传输、传播该软件和相关文档。总而言之，《Oracle Database 2 Day Java开发者指南11g Release 2-138》是一个由Oracle公司提供的帮助Java开发者使用Oracle数据库进行开发的指南，其中包含了标准工具和示例代码。用户在使用之前需要遵守许可协议，并受到知识产权法的保护。

Using JDeveloper to Create JDBC Applications

1-4 Oracle Database 2 Day + Java Developer's Guide

You can arrange the windows as you choose, and can close and open them from the

View menu.

Figure 1–1 shows the default layout of some of the available navigators,

palettes, and work areas in the JDeveloper user interface (GUI).

Figure 1–1 JDeveloper User Interface

Java Source Editor/

Visual Editor

Application

Navigator

Connections

Navigator

Component

Palette

Property

Inspector

Runtime

Messages

Structure

Window

See Also: Working with Windows in the IDE, in the JDeveloper online

Help

JDeveloper Tools

For creating a Java application, JDeveloper provides the following tools to simplify the

process:

■ Structure window, which provides a tree view of all of the elements in the

application currently being edited be it Java, XML, or JSP/HTML.

■ Java Visual Editor, which you can use to assemble the elements of a user interface

quickly and easily.

■ JSP/HTML Visual Editor, which you can use to visually edit HTML and JSP

pages.

■ Java Source Editor, which provides extensive features for helping in writing the

Java code, such as distinctive highlighting for syntax and semantic errors,

assistance for adding and sorting import statements, the Java Code Insight feature,

and code templates.

Note: The Java Code Insight feature is a facility that provides

context-specific, intelligent input when creating code in the Java

Source Editor. In this guide, you will see many instances of how you

can use Java Code Insight to insert code.

Overview of Sample Java Application

1-6 Oracle Database 2 Day + Java Developer's Guide

■

index.jsp

This is the starting page of the application. It automatically forwards the user to

the login page of the application,

■

This page allows users to log in to the application. The user name, password, and

host information are validated and used to create the connection descriptor to log

in to the database.

■

login_action.jsp

This is a nonviewable page that handles the authentication of the user-supplied

. If authentication is successful, the page forwards the

user to

employees.jsp

. Otherwise, it redisplays the

page including a

message.

■

employees.jsp

This is the main page of the application. It displays a list of all the employees in

the

schema for AnyCo Corporation and allows the user to filter the list of

employees using any string. It also includes links to add, edit, and delete any user

data. These actions, however, are handled by other JSP pages that are created

specifically for each of these tasks.

■

insert.jsp

The link to insert employee data on the

employees.jsp

page redirects the user to

this page. This includes a form that accepts all the details for a new employee

record. The details entered on this form are processed by the

insert_action.jsp

page.

■

insert_action.jsp

This is a nonviewable page that handles the insertion of data for a new employee

that is entered on the

insert.jsp

page.

■

edit.jsp

The link to edit employee data on the

employees.jsp

page redirects the user to

this page. This form displays current data of a single employee in text fields, and

the user can edit this information.

■

update_action.jsp

The submit action on the

edit.jsp

page directs the data to this nonviewable page,

which inserts the edited data into the database.

■

delete_action.jsp

The link to delete an employee record on the

employees.jsp

page is handled by

this nonviewable page, which deletes the employee data and forwards the user

back to the

employees.jsp

page.

Classes

The sample application includes the following classes:

■

DataHandler.java

This class contains all the methods that are used to implement the important

functions of the sample application. It includes methods that validate user

credentials, connect to the database, retrieve employee data with and without

filters, insert data, update data, handle exceptions, and so on.

剩余137页未读，继续阅读

weixin_40191861_zj

粉丝: 84
资源: 1万+

Oracle数据库2天Java开发人员指南-11g Release 2-138—版权©2007,2012,Oracle及/或其关...

最新资源

Oracle数据库2天Java开发人员指南-11g Release 2-138—版权©2007,2012,Oracle及/或其关...

Oracle Database 2 Day + APEX开发者指南

Oracle Database 11g Release 2 .NET开发者指南

Oracle Database 11g Release 2开发者指南

Oracle Database 2 Day + .NET Developer’s Guide 11g Release 2 (11

Oracle Database 2 Day + PHP Developer's Guide 11g

Oracle Database 2 Day Developer's Guide 11g Release 2

Oracle Database 2 Day Developer's Guide 11g Release 2 (11.2

Oracle 11gR2 2 Day Java Developer's Guide

2 Day + .NET Developer's Guide for Microsoft Windows

Oracle database 2 Day Developers Guide 2013 11g R2

最新资源