使用ADF Faces 之二：数据可视化组件 Thematic Map

开发环境：JDeveloper 11.1.2.1.0 + Oracle XE Database 10gR2。

本实验需要使用FOD Schema，请参考《 发布与运行 Oracle Fusion Order Demo 》。

1. 通过SQL语句创建VO：ProductPopularityVO

SQL语句内容如下：看某个产品在美国各州的受欢迎程度。

SELECT addresses.state_province, 
count(addresses.state_province) as "Product Popularity Index" 
FROM products_base, orders, order_items, addresses
WHERE products_base.product_id = order_items.product_id AND
products_base.category_id = 
 (SELECT products_base.category_id 
  FROM products_base 
  WHERE products_base.product_id = '1') AND
orders.ship_to_address_id = addresses.address_id AND
orders.order_id = order_items.order_id AND
addresses.country_id = 'US'
GROUP BY addresses.state_province 
ORDER BY "Product Popularity Index" DESC

2. 拖放DataControl:ProductPopularityVO1，选择Thematic Map






3. 运行效果

Project 下载：ADF_ThematicMap.7z

http://maping930883.blogspot.com/2009/09/adf022adf-faces-thematic-map.html