ADF资料 Charting with ADF Data Visualization Components

关于ADF学习资料 比较基础 大家可以参考下13-7-24Oracle JDeveloper 11g release 2 Tutorials- Charting with ADF Data Visualization Components命 Test queryonnectionD ( BrowsEEditAppSELECT irom (sELET addressesstate province,count (addresses STATE PROVINCE) as Roduct Popularity IndexFRCM products oase, orders, order items, addressesWHERE producta haae product id- order itemS. product 1d andproducts base CATEGORY_ID(SELECT products base category idfRoM pRoducts 365eWHERE products base product id=1)andM,SH工PT0 ADDRESS1D·0ddca, ADDRESS工Dandorders, order ia= order items. ORMER p andadcre3se3 COUTRY ID=UsTTest Query Query Results Explain PlanResultQuery executed successfullyClick close7. Click Next up to the Application Module(step 8 of 9)Check the Add to Application Module option It should default to FoDModule application module nameCreate View Object - Step B of 9ModuleOpliur lally aud dnl it slDr ice tf Lis view ubjetL lu ari appliNameIf the application module doas not exist, it wil be created, rI muduleSORry回 Add to application ModuBind variablesPackage: orade, fod, modelBrowse,n.Attribute MappingsName: FODModuleBrAttributeAttribute Settings.aveApplication ModuleU SummaryClick Finish8. The new vew object appears in the Application NavigatorProjects+l OrderItems Warehouse StockLevels View Link2. OrderItemsOrdersFkAssoc+2] OrderItemsOrdersFkLinkI 2 OrdcrItcm3ProductcFkA330c+. OrderItemsView的Q中吗小Orders+a Order GhiFpingSummmary回 Ordersview庄 Product? opularity庄器 Productseas9. Click the save allicon to save your work10. Right-click the FODModule and select Run from contextdocs. oracle. com/cd/E18941_01/tutorials/jdtut1Ir2_58jdtut_11r2_58_ 4. html3/1013-7-24Oracle JDeveloper 11g Release 2 Tutorials- Charting with ADF Data Visualization Components日□品 pplication5 aUTOs白- orade,vd. model+-f FO)Mod la中gOpen FODMcduleorderiRefactor色 OrderLy+-&: Delee由 OrderItd Find usages由- ordering-器 OrdersConfigurations.Business Components Deployer中钟 Orders Runtl-8a OrderS i' DebugRunning the Application Module allows you to validate the new view object and see what the expected results can be11. In the Business Component Browser, double-click ProductPopularity 1 to open it in the Running pane4 Oracle Business Component Browser(FODModuleLocal-LDcal巴回区File View CreatE Database HelpHl FODModuleEa arderItemshiew1ProductPopuarity1s ardershippirgDetails1Order ShippirgSurmary1《N中X的vg Order ShippirgSum mary2过a OrderShipaingDetails2--g0 Orderswiew1白 OrderltemsordersFklink:闷 Orderitemevie2F2 Orer: els_WalefUUseSLuckLevels_VieNLink1WsrehouseStocklevelsview 1翘 ProductPopuarity1StateProvince NYso salesPivotT:ble 1Produ=tPopularityIndex 9Click the Next iconto scroll through records, then close your browser window.2. Open the Data Controls accordion and click RefreshData Contr回岛 FODModulc ControlefreshThis refresh action is not always necessary but it will ensure that the new Business Components added to an ApplicationModule appears in the Data Controls pane13. The new Data Control is now ready for useCata controls· FoDModuledatacontrol且 Orderiemsviej1+E Order shippingDetails1t且 rder ShippingSummary1+ E Order ShippingSummary 2中且 Orderswiew1出 ProductPopularity1中目Saesdocs. oracle. com/cd/E18941_01/tutorials/jdtut1Ir2_58jdtut_11r2_58_ 4. html4/1013-7-24Oracle JDeveloper 11g release 2 Tutorials- Charting with ADF Data Visualization ComponentsStep 2: Create the Product Popularity page tabNow that the model component is available as a databound component, you can use it to create a new rendering as a Thematic Map1. Click the OrdersAndStocks jsf tab to open the page in the design editorStart Page xoordersAndStocks jsf x&lProduct·| Show- Match Current Monitor Resolution回2. Right-click within the OrdersPlanning tab and select Insert after Show Detail Item - Show Detail ItemationPivot Tablc ordoAD- Facesnse"before Show Detail Item-OrdersPlanning国8|昌8 Inse-tinsideshowDeailItem- OrdersplannindTesar This fastenerSwviluhlx3. In the Property Ins pector, for the Show Detail Item, change the text to Product Popularityshow Detail Item-showDetailItemn xMare·aFnd□ Commono Id:sdiRendered: (true)Disdoscd: Area Layer: states-al1f: iew> af: document#c1 r> af: orm#F1 +> af paneltabbed#pt1 t) af: shawdetailitem#sdis dvt: thematicmap#tm18. In the Thematic map popup, expand the Area nodes and selecting the Area-a1 one, click the Edit icorto openUSA tmlLayers:8<5 Thematic Map-tmlE<> Area Layer: states-all3- Area Data Layer-d19. In the Configure Area dialog, select the Attribute Groups tab and click the New icon to create a grouping ruleConfigure AreaDefault stamp Attribute GroupsAn attribute group lets you configure markers for selected data values and dsplay properties. Each group corresponds to asingle legend entry, as illustrated in these examplesGrouping rulesGroup by valueMarker PropertesLegend LabSee the built-in ramps or each propertyvalue-Specific Rules>>10. From the dropdown lists, select ProductPopularitylndex for the Group by value attribute and for the Lege nd Label attributedocs. oracle. com/cd/E18941_01/tutorials/jdtut1Ir2_58jdtut_11r2_58_ 4. html7/1013-7-24Oracle JDeveloper 11g Release 2 Tutorials- Charting with ADF Data Visualization ComponentsGrouping rules中Goup by valueMarker PropertiesLegend LabelProductPopularityIndexColorProductPopularityIndex>Click OK11. The page should look like the followingMDOrders SockLevels Location Pivot Taple CrdersPlanning Product Popularity中·∠8③ D Thematic Map-tm1--> Area Layer: states-allR<2 Area Data Layer-d1Area -a1VDItem#sdis+ >dwt: thematicmap*tm1 t>dvt arealayer#all>dvt areadat alayer*dll t> dvt arealotation#alz>dvt area#al12. Click the Save Al icon e to save your work and click the Run button l to launch the page in your browser13. In the browser window, click the Product Popularity tabMDOrders SpckLevels Location Pivot Table OrdersPlanning Product POrderDate 119/2011Order Date 1/19/2011OrHerc-hicrmd-CnMDICTE14. The state maps displays product popularity with the color legend on the top right corner indicating the number of times a productwas specified in orders independently of the quantity ordereddocs. oracle. com/cd/E18941_01/tutorials/jdtut1Ir2_58jdtut_11r2_58_ 4. html8/1013-7-24Oracle JDeveloper 11g Release 2 Tutorials -Charting wth ADF Data Visualization ComponentsMDOrders StockLevels Location Pivot Table OrderEP anning Product PopularityWAVT9654321W/YIANL IN OHCAMW VAGALA15. You can hide the legend tooProduct Popularity16. Try the Navigation toolbar by opening the toolbar in the upper left corner, allowing you to move, rotate or zoom in and out withinthe mapMDOrders StockLevels Location Pivot TabledersPlanningIdaho17. Click the Fit Mapn to the generaldocs. oracle. com/cd/E18941_01/tutorials/jdtut1Ir2_58jdtut_11r2_58_ 4. html9/1013-7-24Oracle JDeveloper 11g Release 2 Tutorials-Charting with ADF Data Visualization ComponentsMDOrders stockLevels Location Plvot Table OrdersPlEnnInc Product PopularityWAFtⅣap(0ILDEAZOKINSCHI18. Close your browser window nowYou've successfully completed this tutorialummaryIn this tutorial you discovered how to use DVT components in a Web Application. You learned how toUse a Model and Build a page upon itStart using Graphic com ponents, like Bar Chart and GaugeAdd other com plex graphical presentations like Geographic Map, Pivot Table and Gantt ChartUse Thematic Map componentTo learn more about aDF Faces and DVT components, refer toWeb User Interface Developer's Guide for Oracle ADFJava EE Developers Guide for Oracle ADFPrevous 1 23 4 NextCopyright o 2011, Oracle and/or its affiliates. All rights reserveddocs. oracle. com/cd/E18941_01/tutorials/jdtut1Ir2_58jdtut_11r2_58_ 4. html10/10