Hello So in this video let's now try to write a select statement which wants to say user petitions or login. The system will check if the user name and password is correct or not. So let's go to the database our school schema and from school information I used to hear school principal name is called username and password so we should check this. So what we can do is we can right select in the school bring see the name from mission we're Transfer user name equal and in the school bus for equal okay just I want to double check user query is correct or not I will copy it and I will open the school connection and I will try to run it at least I should not getting a sequel exception okay we have something wrong so school principal cannot take the school principal and what it says here Swan Okay, looks written.
Frankly you can take it home here like this. Now it looks ok so I will take it copy this and paste it here. So here I need to add the user name and here I want to add so here are sets of buzzwords and Here we sit in username Okay, so select the school principal name from the school information with the school principal name equal the user name and password equals password, we can add this user name, the breathable name and decision we can call it name and we can set this to get trained training of one. So, if the username or password is wrong, this SELECT statement will not return nothing It will return nothing so it will not go to insights a while and it will go here and displays error message is the username and password are correct. It will won't say it's a while loop.
And it will set the user name with the username and the principal name with with whatever we're returning from the select statement and I will go forward to that dashboard. So, now, we should set some value here which have a look if there is a value or not so that we can try to test the login. So there is no Edwin draw my school name just no need for it. Now for now for x principal name, maybe you can call it admin. And here, admin and password Okay, So now we have here the username and password admin admin. So let us try now Purim and try to log in and see if it will work or there's something missing.
As I said, if you now run any beach anyway it will navigate to the login page because the filter will catch the request and it will forward it to the login page. Okay, so it is really a direct request to the login page. There is a username and password. Let us remove the username and password you will find an error message will appear. You must enter the value you can't look going on, then you enter the value. Actually, there's something missing, which is the data source.
So if even you try to enter the correct one, the data source, you will get an exception. Because here, we didn't integrate it as a source. You'll find here exception on a voltage of the school DS. So first we have to carry this data source in our WebLogic. So you will should go to to the console. Okay, and we can create a data source in the WebLogic.
And even if you will deploy your application in glassfish. You have to create this data source with the same name. Here is the console we go to four surfaces, data sources. I will create a new generic data source. Here's a name any name. I can give shinda name to the same name.
It is Oracle database. I will choose in essence connection thing. Nick asked Nick asked, here's the division formation Ixy hostname localhost. database name is school password is school, school. Let us try to test the connection success next it target will be our default and finish. So now we create school This is WebLogic.
So if you try to call our if school application If you enter now invalid username and login, here it print the username and the password. So let us enter the correct one if you correct admin, admin, press login okay so what what happened here it Brent admin admin, it checks database connection to source it is correct so it is login to the dashboard you can now navigate between the pages as usual as normal. The missing thing is you need to add here the login the current logon user and once I'm bearish look i would i should look out from the system. This is what will we do is an activity you see you next video.