next »

[Arkie]

Since my JDeveloper project has succesfully finished, I can post a bit about the stuff that you might need to make with JDeveloper.

This is how you can make a search field that takes parameters: (I got this from my classmate, he showed me how to do this)
Go to your modelview, double click on the viewObject, go to SQL statements and insert your SQL.

Example 1):

Code

GeSHi (oracle8):
SELECT Werksoorten.NAAM, 
       Werksoorten.WERKSOORT_ID
FROM WERKSOORTEN Werksoorten
WHERE Medewerkers.ACHTERNAAM LIKE '%' || :CustAchterNaam || '%' AND Medewerkers.WOONPLAATS LIKE '%' || :CustWoonplaats || '%'
 
Created by GeSHI 1.0.7.20

Example 2):

Code

GeSHi (oracle8):
SELECT Medewerkers.MEDEWERKER_ID, 
       Medewerkers.VOORNAAM, 
       Medewerkers.ACHTERNAAM, 
       Medewerkers.GESLACHT, 
       Medewerkers.GEBDATUM, 
       Medewerkers.STRAAT, 
       Medewerkers.HUISNUMMER, 
       Medewerkers.POSTCODE, 
       Medewerkers.WOONPLAATS, 
       Medewerkers.EMAIL, 
       Medewerkers.VESTIGING_ID, 
       Medewerkers.TELEFOONNR
FROM MEDEWERKERS Medewerkers
 
WHERE UPPER(Medewerkers.ACHTERNAAM) LIKE UPPER('%' || :CustAchterNaam || '%') AND UPPER(Medewerkers.WOONPLAATS) LIKE UPPER('%' || :CustWoonplaats || '%')
Created by GeSHI 1.0.7.20

The second example will enable you to search for ALL text(s) that contains in the search criteria.

Example:
This is a string in the database: EngineerinGserver.com
If you are searching for: ringserver the first example will return 0 results because it will search for the literal text. The second example will change ALL text in uppercase so it will find the match regarding if the original search string is in an uppercase or not..

Next go to the "Bind variables" and add "CustAchterNaam" and "CustWoonplaats" Both types are: String
Change labelText: Go to the "control hints" in the "Bind variables" and change/add the text in the "Label text" field.

After you are done click OK and go to the viewController. Create a new page by click with your right mouse on the "New..." choose: web tier -> jsf and name the page whatever you want. After that go to the "Data Control Palette" click the "+" and drap & drop the "ExecWithParams" in your JSF page. You can now test the page by right clicking with your mouse and select "Run"

Screenshots:
http://www.engineeringser...c0d3z/tpmod.html;dl=item5
http://www.engineeringser...c0d3z/tpmod.html;dl=item4
http://www.engineeringser...c0d3z/tpmod.html;dl=item6