Developing School Application Lookups Pages (cont.)

Complete Oracle ADF 12c Course for Beginners Create a Complete ADF Application
18 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€65.24
List Price:  €93.21
You save:  €27.96
£55.79
List Price:  £79.71
You save:  £23.91
CA$95.78
List Price:  CA$136.84
You save:  CA$41.05
A$107.15
List Price:  A$153.08
You save:  A$45.92
S$95.25
List Price:  S$136.08
You save:  S$40.82
HK$547.16
List Price:  HK$781.69
You save:  HK$234.53
CHF 63.78
List Price:  CHF 91.12
You save:  CHF 27.33
NOK kr771.03
List Price:  NOK kr1,101.52
You save:  NOK kr330.49
DKK kr486.66
List Price:  DKK kr695.26
You save:  DKK kr208.59
NZ$117.65
List Price:  NZ$168.07
You save:  NZ$50.42
د.إ257.05
List Price:  د.إ367.24
You save:  د.إ110.18
৳7,682.75
List Price:  ৳10,975.83
You save:  ৳3,293.07
₹5,839.27
List Price:  ₹8,342.17
You save:  ₹2,502.90
RM334.02
List Price:  RM477.20
You save:  RM143.17
₦92,745.84
List Price:  ₦132,499.74
You save:  ₦39,753.90
₨19,488.62
List Price:  ₨27,842.08
You save:  ₨8,353.45
฿2,593.98
List Price:  ฿3,705.84
You save:  ฿1,111.86
₺2,266.58
List Price:  ₺3,238.11
You save:  ₺971.53
B$358.23
List Price:  B$511.78
You save:  B$153.55
R1,308.04
List Price:  R1,868.72
You save:  R560.67
Лв127.69
List Price:  Лв182.42
You save:  Лв54.73
₩96,593.58
List Price:  ₩137,996.75
You save:  ₩41,403.16
₪262.11
List Price:  ₪374.46
You save:  ₪112.34
₱4,037.82
List Price:  ₱5,768.57
You save:  ₱1,730.74
¥10,982.62
List Price:  ¥15,690.13
You save:  ¥4,707.51
MX$1,188.90
List Price:  MX$1,698.50
You save:  MX$509.60
QR255.36
List Price:  QR364.82
You save:  QR109.45
P960.21
List Price:  P1,371.80
You save:  P411.58
KSh9,275.87
List Price:  KSh13,251.81
You save:  KSh3,975.94
E£3,354.25
List Price:  E£4,792
You save:  E£1,437.74
ብር4,018.25
List Price:  ብር5,740.61
You save:  ብር1,722.35
Kz58,443.04
List Price:  Kz83,493.64
You save:  Kz25,050.60
CLP$66,028.30
List Price:  CLP$94,330.18
You save:  CLP$28,301.88
CN¥506.69
List Price:  CN¥723.88
You save:  CN¥217.18
RD$4,095.54
List Price:  RD$5,851.02
You save:  RD$1,755.48
DA9,393.81
List Price:  DA13,420.31
You save:  DA4,026.49
FJ$158.42
List Price:  FJ$226.32
You save:  FJ$67.90
Q544.03
List Price:  Q777.22
You save:  Q233.19
GY$14,645.70
List Price:  GY$20,923.32
You save:  GY$6,277.62
ISK kr9,806.99
List Price:  ISK kr14,010.59
You save:  ISK kr4,203.60
DH708.51
List Price:  DH1,012.20
You save:  DH303.69
L1,235.26
List Price:  L1,764.74
You save:  L529.47
ден4,024.43
List Price:  ден5,749.43
You save:  ден1,725
MOP$564.37
List Price:  MOP$806.28
You save:  MOP$241.91
N$1,312.44
List Price:  N$1,875
You save:  N$562.55
C$2,589.99
List Price:  C$3,700.15
You save:  C$1,110.15
रु9,350.18
List Price:  रु13,357.97
You save:  रु4,007.79
S/262
List Price:  S/374.30
You save:  S/112.30
K266.57
List Price:  K380.83
You save:  K114.26
SAR262.49
List Price:  SAR375.01
You save:  SAR112.51
ZK1,865.62
List Price:  ZK2,665.29
You save:  ZK799.66
L324.62
List Price:  L463.77
You save:  L139.14
Kč1,642.25
List Price:  Kč2,346.17
You save:  Kč703.92
Ft25,489.50
List Price:  Ft36,415.13
You save:  Ft10,925.63
SEK kr767.15
List Price:  SEK kr1,095.98
You save:  SEK kr328.82
ARS$61,365.44
List Price:  ARS$87,668.68
You save:  ARS$26,303.23
Bs484.79
List Price:  Bs692.59
You save:  Bs207.79
COP$272,495.59
List Price:  COP$389,296.10
You save:  COP$116,800.51
₡35,128.88
List Price:  ₡50,186.26
You save:  ₡15,057.38
L1,728.92
List Price:  L2,470
You save:  L741.07
₲521,305.22
List Price:  ₲744,753.66
You save:  ₲223,448.44
$U2,682.06
List Price:  $U3,831.68
You save:  $U1,149.62
zł282.11
List Price:  zł403.03
You save:  zł120.92
Already have an account? Log In

Transcript

Hello. So let's now start developing the students page. So I will select students. Here's a body and let's have a look in the students you have a lot of columns so it will be like the teacher it will be only one one table, stretch it to all the beach so I will add straight away a better prediction. This beach maybe it will be right like repetition to the teacher page so if you miss something from the teacher or you didn't understand something while we are developing teachers, I will repeat everything here in the students page. When the collection as I said it will be good component to add in a diff table because it adds some predefined features from the table.

The tables so I will add the bedding collection. I will go for style to make it stretch it all here you can add here if stretch width and inside this pendant collection I will add students as a table enabled sorting filtering and single row and we need to display all this data as we add here if switch width and it was added here in the table as well. As I said it is standard in any table you add you should add some something you should be standard in all as I said if they will be stretch, we should add let's quantum to be stretch it we can be quantum As a column to be structured maybe address we need more wide more. So, we can say see for as well to be structured. So, in the appearance I would select see for I will add one initial column column here for clearing further with with 14 for Haider through wants us to develop it the application you will do this thing is automatically without any thinking at this column, student ID should be read only.

So, we can say this is should be true sorry not this it should be read only true. This is required the way it is would be read only, and it will be auto generated. Maybe student name we can include is the width be 200 k here here email and phone I think we will go back to the model layer to show you how you can add email confirmation conformation and form and created date created date as well should be read only because this is will be inserted automatically from the system the user should not be able to update it or change it. So now it looks okay. We make one stretch we add the first column we increase the student name. This is will be stretchable maybe parent name we can make it 150 after we were on the beach, we will exactly know what what column we can increase So this is okay to add the bottom over this I like to use a secondary toolbar.

This is secondary toolbar inside this toolbar I will add the old operation here. So in the student view or operations so that I would add to create insert, delete, save or commit and rollback orchids. Okay, and in the toolbar, I will add one button to export to Excel like we did in the teacher beach. So the tickets will be support to Sir and as I said to make the bottom export that toxin you should ask If component code export collection, you should add this export collection action is on inside this component and you should set the table ID which is T one and the type it will be support as an exit. You can add two more singles which is the filename which will be supported it will be student dot exe s and the title will be students can make it students as well. So that's simple and easy.

Export operation is done. Commit, we'll remove the disable and rollback. We will remove this. See simple and easy. Here I will change to be at and sits icons delete, delete, commit to be safe rollback will be cancer. I think we did we had our icon here we can have icons Export to Excel.

Okay, so all looks good. Now let's add the Delete operation as I show you in the teacher how to can add a confirmation message. So here I will create a back been here for the for the Delete I will add here for this note we can add a mobile first so this is known as a bulb If you if you didn't if you didn't understand something was a teacher I will explain it now. So, to display a confirmation bubble or any bubble you add a component called Bob if you will use some binding information such as Bob you should set the content delivery to lazy uncashed okay inside this Bob, I will add a dialog. In the dialog you will make three singers Ferris wheel uses a title. So we can say here delete student okay and choose the type if it is okay or cancel yes I need to cancel because I need once the user press Cancel only the ball will be hide, nothing will done.

And if you want to brace Okay, you have to execute some code. This code will be around on forums a dialogue listener, so is the dialogue listener now I would create a missiles which will be executed once the user press OK, but I can use the T shirt back in but I don't like to make us like a shared being between pages I need each page has its own managed bean. So, I will create a new measurement for student I will call here student and the class will be student spin and it will be in the package corn bean as it as I told you, you can have some standards like as a class name will be the page and in this beam and it will be inside package all be okay. So this is a been I need co-curator method. We can say delete any message you want to delete student dialog.

Listen like this. DS children dialog listener. So now we have here students we have a dialogue by a listener, we can just point it again to student delete student dialogue. So this is the three things we do in the dialog. So first thing is we set the title we check the type and we add the dialogue. As I said, if you don't want to like okay to beat splay you want Yes, so we can right here, say yes because this will override the thickest in silky text.

Okay, so inside this dialogue, I just want to display a message. So I will just oh what decreased here and they can see Are you sure you want to delete student and you can add here student name is additional additional ID but the easiest example I will show you how to do the name it seemed like ID you can just drag student name here as an output tickets just to be added in the binding if you go to the binding now you will find student editing so binding I just drag it here to add this as a binding after that you will take the value and add it here okay in the case you can delete this need for this. So here are you sure you want to delete student and to give the student name I can change the state color to be same like what we did.

Okay so expression builder and cm he is a way should notice a weight here we can add as a book Okay. So now all everything looks okay I just want to arise the cool is the student been here as I said you should execute the Delete operation commit operation and display the message we can query what we have here. Here just see student deleted successfully. So just to be sure once you write execute a bration delete this delete should be exist here in the binding otherwise you will get an error commit as well should be displayed here and this is successfully message. So, now let us try to run the page. As you can see how it if is easy to build the pages without any noise output of good writing and a lot of code plus you have a lot of features like you can add a filter over the each column you can make a sorting by column you have the detach to put this table into full screen you can hide and display some column.

So you have a lot of features without writing too much code on it. So as you can see here, this is our table. This is a student query data this is looks not labeled in the entity level this is why it is looks like this not like the others we will back again to the entity and We can update this so now once you press add here you will find the student ID by default coming here this is as a male by default okay and the created date was automatically coming as you can see here so if you've received is it mandatory no so we can mark the name and address as a mandatory and we can meet at a label in this created because it looks not added. So first we can back to the entity object, how you can back to the object so you know what is a view object which you drag to the beach.

This is so you can go to the definition. It will open the view object from the object you'll find the entity select from the entity here it will open the entity because currently the application is bit simple. You can easily go but if you have hundreds of injury and the view it will be hard to go You have to go like this way. Watch what I did. So you will be just to go to the attribute is still created and you can add the label here created it okay and I think it is here it looks with is okay everything is okay here okay so this is just add Mark student name as our behavior required a right here through maybe student address as well. True we have our tonic key for student name so we try to test if we added it to Same thing we will receive an error message or not because we already defined like tonic key here okay now created it is labeled okay so let's add now add preset if you save you will get this has been required I will add here name student one iron eating no need for it now so we can save.

So if we add again here is student one and see if UK save what will happen if username is already exist. So this is the alternate key validation which we add over the student name So all validation which we did in the entity level it is we can see it here as you can see. So this is how you can add student three. Me UK save it has now selected this and try to delete okay we didn't add Shabaab in the Delete so let us go here and delete to show this pop up which is B one so in the Delete we will insert the F shoe pop behavior and you write is B one and trigger B actually we forgot to add this in the delete button. So let us now refresh it again Okay, so it's To jump to UK save okay save. So now, if you fix into and delete you will see Are you sure you want to delete student two if you select SR two one and delete Are you sure you want to delete student one content nothing will happen yes should be deleted and successfully predicted okay this because we just refreshed it refresh the page sometimes it have this look error, but now it should be okay.

Can see. Delete, okay, yes can see delete one is gone now. Okay, so this adds to you didn't want safe so now we All almost finish the old lookups this is plus room, this is t shirts and this is students if you want to just support as well you can find it is supported. Supporting is added it is exported to that. So all looks okay. So, from the negativity we'll go for the search to search about the student and teacher.

So see you next activity

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.