Monday, June 8, 2015

Build an Image Slider in ADF

Hello Guys,
In this blog i am going to show you how to use image slider in ADF application.In a portal application it is very common to have an image slider that can slide image automatically or manually from one to another.The image slider transition is implemented by JQuery. I will not focus anything on JQuery as there are many third party JQuery plugin out there for such image sliding effect. The Basic purpose of this post is to use Slider on my ADF application. To implement this, you should have some basic knowledge on ADF skinning, JavaScript and UI development.

Here is the link to download some files(CSS & JQuery) that are used in this application. 
  • Firstly create a task flow, as it would be preety easy to wrap all the slider related resources in one task flow.
  • Drop a view and create a jsff page.
  • Now, drop af:resources in the pages as,
  • Drop a af:panelGroupLayout and paste the html code inside this as,
  • Now,create a jspx page and drop this af:panelGroppLayout on this and drop task flow in this layout.
  • Now run jspx page and you will get the desirable output.
  • Here is the link to download the sample application Slider.

THANK YOU :)

Monday, June 1, 2015

Style Facebook Login Page Using Oracle ADF Face Component & implementing CSS

Hello All,
This post is about implementing CSS on ADF application used to change the look and apperence of ADF application by using skin. I have designed a Facebook Page just to show you how to implement this. 
  • Firstly,create a Fusion Web Application.
  • Now create a CSS File as,
         Right click on ViewController ----> New ----> All Items ----> CSS File.
  • Now create a XML file in WEB-INF of the name of trinidad-skin.xml
  • Make sure that the skin-family type of trinidad-config.xml & trinidad-skin.xml should be same.
  • Now create a jspx page and drop af:resource from the component palette and define type and source of the file as,

  • By this way your CSS file will be implemented on the ADF application.
  • Here, I have designed Facebook Login Page using ADF face component and implementing CSS and i also have done the functionality in this Application.
  • To access this sample application firstly create a table in HR schema by using the following SQL query as,  
                                  CREATE TABLE  "FACEBOOK_SIGNUP"

                     Code for SignUp (Insert data in DB):

              Code for Login(Using DB credentials):

  • Now Run jspx file(main.jspx).
  • Here, is the link to download the sample application Facebook_Login.

THANK YOU :)

Dependent LOV or Creating Cascading Dropdown in ADF

The purpose of this post is to document, step-by-step, how to create cascading drop-downs in an ADF form's user interface when ADF business components are used.  A cascading drop down frequently occurs in forms and occurs when a selection made in one field's drop-down automatically and dynamically changes the list of valid values in another field's drop-down.
  • Create query based view object using Region, Country & Location tables.
  • Now, we'll modify the query of the dependent VOs to include a bind variable in their WHERE clause.
  • Create bind variables i.e. regionBind & CountryBind for country & location tables respectively, as these variables are used to hold the values from the first selected LOV and will update the value on the next i.e. cascaded LOV as shown in the figures below.




  • Now,we have created a new query based VO,lets call it CombinedVO with three attribute i.e. Region_Id, Country_Id & Location_Id(to populate our LOV's) as,
  • Here we have modified the where query as: REGIONS.REGION_ID = COUNTRIES.REGION_ID AND COUNTRIES.COUNTRY_ID = LOCATIONS.COUNTRY_ID
  • Make sure that all the 3 attributes of CombinedVo are updateable.
  • Now set LOV on all these attributes as, like i have set it on Region_Id as,
  • Similarly,set LOV on Country_Id & Location_Id too.
  • Now set the value at View Accessors of CombinedVO of CountriesView1 and LocationsView1 as regionBindCountryBind respectively as,

  • Now set Partial trigger & Auto submit on the LOV's.
  • Finally,run your jspx page.

THANK YOU :)