Oracle JDeveloper Introduction - Oracle JDeveloper 10g Quick Tour

 JDeveloper is a complete, integrated development environment which can be used for Multiple languages. The J2EE Framework enables developers to quickly build applications and gives them many choices on how to build them. Now we’re going to demonstrate how to build the business services. Oracle ADF raises the bar for J2EE application development productivity without locking users into a particular platform. This demo begins with developing the Business Services for an application, which can be implemented as any combination of EJBs, Web Services, TopLink classes, Java classes, or Oracle ADF Business Components. You can add new business service entities from the component palette, or you can drag and drop a table from the database navigator. Business Logic, such as validation rules, is implemented in the Business Services. First we select the entity in which we want to add a validation rule by double clicking the object. Select validation on the right, then select the field we want to validate and click ‘New’. The add validation rull dialog box is displayed. In the rules drop down, select ‘Compare validator’. We want to validate that the salary is Less Than or equal to hundred ninety-nine thousand, nine hundred, ninety nine. We enter our literal value which is nine hundred ninety-nine thousand, nine hundred, ninety nine. Then enter an appropriate error message and click OK. Now we see our validation rul under the Salary object. Click Ok to return to the diagram. Next we will build the user interface. With oracle ADF and Oracle JDeveloper 10g, you can develop user interfaces for web applications, rich client applications, or wireless applications, all using the same set of business services. Jdeveloper includes a visual page flow diagrammer for visually constructing the page flow of Struts applications. Select ‘Page’ in the Component Palette, then click below createDeptAct. A new page is added. Change the name to /createEmp.jsp. Next select ‘Forward’ in the component palatte. Click on /createEmpAct then click on /createEmp.jsp. A line will be drawn with the arrow pointing to /createEmp.jsp. Double click the /createEmp.jsp file to open it. Type ‘Human Resources Application’ and hit enter. Then type ‘New Employee’. Select the ‘Paragraph’ drop down and select Heading 3. Notice the ‘New Employee’ text changes to bold. Move the cursor up to Human resources application then go to the ‘paragraph’ drop down and select ‘Heading 1’. Select the ‘components’ tab on the right side of the screen. Select the JDeveloper CSS and drag it to the editor after the title. This will add the JDeveloper Cascading Style sheet to the page and change the format of the text that was entered. Oracle provides a databinding layer to make binding web, rich client, or wireless applications to Business Services as easy as “drag and drop”. Select the Data Control palette tab on the right side of the screen. Make sure ‘Drag and Drop As’ has Input Form selected and select the EmployeesView object in the palette. Drag the object to the editor below the ‘New Employee’ text. All of the available fields are added to the screen. Next we’ll talk about profiling and testing the application. Oracle JDeveloper contains a lightweight J2EE application server (OC4J) to enable easy testing of applications. The quick startup reduces time spent on the edit, compile, test cycle. JDeveloper also provides a suite of testing and tuning tools, including a state-of-the-art debugger, profilers, audits/metrics, and CodeCoach. This demo shows testing the web application using the Event profiler. Select Run from the toolbar, then select Event profile ViewController.jpr. The page is now displayed in a browser. Click Next to move through the department records. On department 30, click edit for the employee details for employee 114. The Edit Employee page is displayed. Change the salary from eleven thousand to 1.1 million and click update. This validation error is a result of the logic added to the business service earlier in the demo. Meanwhile, we can use the Event Profiler to pause the application and retrieve the profiling statistics up to this point. Select the pause icon. Here we see the profiling statistics. This profiler provides insight into the internal events generated by the application. Used in conjunction with the other tuning tools in JDeveloper, the profiler can help ensure optimum code quality and performance. Now we’ll look at tailoring JDeveloper. The JDeveloper environment can be highly customized to fit user requirements. For example, if you know that you will not uses certain features, you can disable them. You can also develop your own extensions to supplement the JDeveloper feature set by using the JDeveloper Extention SDK. We’ll expand the System Extentions extension and then deselect the System Extention. You’ll see that all the extensions within the System Extension are all deselected. Then click OK. Right click Applications in the Applications Navigator and click the New Application workspace. When you create a new application, you can use one of the existing application templates, or you can create your own. Application templates help set reasonable defaults for the type of application you are building. Change the application name to MyHRApp then select ‘Manage Templates’. Now select ‘View’ under ‘Web Application [JSP,EJB]. One of the default settings you can control is the Technology scope. Technology Scopes assist you by prompting you with the most pertinent menu choices and other options while you are working. Select ok. Right click Model and select NEW. For example, the Technology Scope is used to filter the contents of the New Gallery, providing faster access to the items you are likely to need. Now we’ll talk about working with XML Schemas and Documents. JDeveloper includes a visual XML Schema editor. Like most JDeveloper features, you can interact with the editor using the Structure window, Component Palette and Property Inspector. Select attribute from the component palette and drag it inside the PurchaseOrderType object before the OrderDate. On the right update the name to OrderNo. Additionally, the XML code editor has many productivity features such as tag insight. Select the purchase-order.xml tab. We want to add a tag. After hit enter. Then right click to display the available tags. Select shipto. Hit the space and another option pops up for country. Hit enter to select it and type US in the double quotes. Then type in the closing tag . Now we’ll talk about working with a database. Oracle JDeveloper facilitates working with objects in any SQL92-compliant database. There are some additional features (such as PL/SQL support) that are specific to oracle. In the connections navigator, expand the OracleDB_HR connection. In the packages group and the EMP_MAIN package, select EMP_MAIN. If you double click the list_emps field, you’ll see the source in the editor. If you need to tune an SQL statement, you can copy and paste the statement into JDeveloper’s SQL worksheet. In the list_emps procedure copy the select statement. Go back to the OracleDB_HR connection by clicking the tab. Remove the existing select statement and paste the statement copied from the list_emps procedure. From the SQL Worksheet, you can execute any SQL statement, as well as get it’s explain plan. Open the SQL Worksheet. Here we’re viewing the explain plan. In the Connections Navigator, scroll down to the Tables and select the Employees table. Now we see a view of the data in the Employees table. You can even work with Database diagrams, either by reverse-engineering from existing tables, or by creating new tables. Now we’ll select the HRSchemaDiagram tab. Holding down the control key, select the Countries table, departments table, employees table, job history table, and the jobs table from the connections navigator and drag them to the diagram. Now you’ll see the selected tables in the diagram. From a database diagram, you can generate the DDL to create (or reconcile) the tables. Right click in the diagram. Click generate, then Data Definition Language for Diagram. When the dialog box opens, Create(or replace) the chosen objects should be selected. Click next and then click next again. Now we have the DDL needed to create the selected tables. That’s the end of our Oracle JDeveloper 10g Quick Tour. For more information, visit the oracle technology network at otn.oracle.com. There you’ll find additional online demos, technical whitepapers, code samples, product downloads and much more.