Student Result Management System in JSP (Eclipse ,Tomcat , MySQL ) Complete Project (step by step)

hello everyone welcome to my youtube channel in this video I am going to show you quick overview on my strengths result management system project I am going to use GSP my skill database Eclipse IDE Tomcat server HTML CSS so on this click on finish I am also going to make more videos on this that how I just created this project is step by step so stay tuned with us and open this project ok they can see that this one is our home page or you can see the index page you can see the three buttons for showing the admin and you can see the details you can insert the latest address contact number email ok here you can see the image of APJ Abdul Kalam sir and you can add here the details of about of college at all now let me move through the admin module in this I am going to insert student details as well in restraint marks so first we have to login as admin so first we are going to enter wrong password I think so that you can see that new bgill here you can see there in correct username and password so in this way we can handle any error in our JSP ok yeah correct username and password well if you can login so you move to the upper admin homepage you can see that add new result okay here I am writing P check ok after that we are selecting the branch ok ok after that I am entering name Anil Kumar ok here things to make one for the same and ginger I am sitting it babe okay clicking on see data has been saved let me see the registration details you can see the roll number one tuple zero for a little cumin name so minimal father's name and men all has been started okay let me result insert the result for this until to 0 for n to the marks 50 15 2048 70 and this means visit engineering chemistry lab so maximum ass is 30 so we are entering here 25 20 okay click on save it when it's certain our database of all study showed that you can see that ronamoon two possible for opting month in physics 150 chemistry you can see all the details of that ok so in this way you can see the registered registered amusement in certainly Brazil and all you can also see the details of the user ok this one is all my created by me Jake days okay so this is all log on written when you click on this it will move to the admin login page when we click on back it will move to the home page or you can say that index page now it's time to move in this to range Auggie okay first clearly you have be entering the already registered what - / 0 1 ok search it and you can see that name DCI institution in BTech civil engineer and see that branch wrong number you can see and here you can see the name as well as father's name gender okay this is also in print and we click on this button you can see that this train - option has been open okay so you can see that you can I am not connected with the ad crater so it's showing here you can see the all the radius of this okay say this baking you can print it this page and here you can see the obtained marks obtained mark 60 30 40 70 is a particular subject and here you can see the total full marks is 516 by adding this and obtain marks is 283 humidity and the percentage obtained is 50 okay so in this vein let me go to the back page and again into the triple zero for right now this just show you that I just register for this column let me search for this now you can see that the name is Anil Kumar the name is same as which I already in told the details in admin module you can see the computer science and you nearly consider fifty fifteen thirty eight forty eight seventy twenty five twenty you can see the three hundred one is obtained and you can see the total marks and the percentage obtained by this okay so you can also see there all the details here like father's name is Amit Kumar gender and course name okay let me get to the back so this is all of them of my newly created project a student results management system in JSP so if you need directly the source just go to the comments section and come in to your email address I will change you will mail okay and I am also going to create mood will use in on this project that how I just created this project so stay tuned with us and please hit like and subscribe my channel thank you hello everyone welcome to my youtube channel this one is my first we'll do a after a demonstration of a straight trajectory system future in this video I'm going to show you how it is created the login page of admin basically I am NOT going to focus in HTML CSS and JavaScript part my main focus is on JSP so so first you need to create dynamical project result it meant system finish now I can see that our project is now just go to description and check out the link is provided for a steam in CSS part just go and download it when you download that file orgy file then you get when you extract that then you need this files ok so just go and download that file and just copy it and this if content section ok just copy and click on ok copy here you can see that okay now now we have to write the code for the admin login ok you can see that admin lolly is not HTML here you can see the next action action page okay so we'll just copy the accent page are we need to create a JSP page for first click on this you move to the JSP file and renaming it as admin login action finished click on finish ok ok now here we have to write the codes to login ok first we have to take the parameters username and here you can see that beam username and for the password we have said name as a password so let's writer we're taking that first we are taking the two variable string there we are taking username one because she requests let's start gate meter and here we have to write the name of the first one you can see user name here you can see that okay so I'm going to write user name in the same way we are also taking for the username a password buddy password and sitting password okay now we have to match we are sitting not using her database to validate admin I'm just hard coding this equals equals force including and and we are also sitting the name and password is also admin okay pink this one is correct then we have to send the response so response taught send the direct and they'll have to write the page name so we need successful login it will move to that this page admin dot from admin home dot JSP okay so here at right admin admin whom thought gee recipe okay f if if the password is incorrect then we are sending that response to you can see that there is another little piece here admin login page right Robin dot H so let me run this project we will start from the index I already provided all the HTML uses part of this project so just go to the description and download it and just pop in the Bill Clinton section okay so it will mean you're scoping it will take a bit time here you can see that our first page has been opened let me click on admin I'm ensuring admin ok like username and password is correct click on login you can see that waiting for response you can see that even each a twin login dot HTML has been proven you say that there is a message in correct username and password ok and here you're entering admin correct username and password so that we can get in ok so here you can see that he moves to the Auburn homepage this one is homepage I already designed this homepage and already provided the source code in description just to go and download it so this is all about admin part I hope you guys like this video so please hit like and subscribe my channel thank you hello everyone welcome to my youtube channel in the previous video I just show you about the admin module or you can say the admin login and you click on login it will move to this page you can see that add news 20 inserting mister and registered still to all student results ok so in this video I am going to write the codes for the add new student and basically my main focus is on JSP part so I will really provide you the link in the description of the all ports which are I am using in this project of HTML CSS and JavaScript ok so it's time to start the project so first we need jar file ok of MySQL ok so here you can see that I already downloaded it I am just going to copy it you will need to copy it in the big content folder you have there's a folder bill INF there is a library folder ok I just copied and click on ok now this one is you can see that copy now we have to create a package here so we can provide a connection okay so here we are creating a project named package project and this we are going to create a class and that one is our connection connection provider provider click on finish now first we need to import put my input Java dot s well okay now now we have to create a method public static static might our connection it on its doing here because we did not return function return any function you can see that this method return a result type of connection okay so we have try and catch to suppress the exception catch some writing class dot holding and writing comm tour twice well if you're using oracle database this name is different okay just go to log-roll and search it driver after that we have to create a connection to connection and to finish section called driver driver manager dot get calm on first we need to write the URL so for my duck i eat otherwise the body Gerry we see MySQL MySQL localhost localhost three 3:06 default port number of mayest well after that we have to write the database name so they create the database first okay create data base I am writing project one okay now our turtle is created now here now we get right to project one now you have to enter the default you enter the default username or our database after that we have to write the password now you can see that password is 1 2 3 4 5 6 okay now we have to return connection ok it will return then it should return now you can see that all these rails has been removed those we returned up okay now now we have to write the code to insert ok so here you can see that the action put the add news to the action is add new student or JSP okay so just let me copy this or we are going to create a JSP file for it right for the action idea should click on finish or here we have to write the ports for the action so first we need going to import import their project widget dot connection provider fight it root now the same baby I was going to import for mice port for Java TARDIS bill okay now you have to get the parameter from that page for the positive string strain we are taking course a little evil don't request please don't get parameter and I'll be a city right now and let me check out that name of the first yeah you can see that course you see the name so here we are taking the name is here course okay in the same way we are writing for others okay one two six field so the question is for the force and branch for the second one and third one and fourth father's name and at last gender you can see all these name here which one to change it just we can just hit her and change your branch you can see here roll number name father's name ginger you can see here okay now we are also only naming it as same branch you're taking it all now you have to try and catch method for it and area lighting exception exception so occur out dot print and then it will just print it now you have to write the connection connection corn and they'll be writing project is your dot connection provider don't get here okay after that we have to create the statement statement St call thought statement okay as T dot execute execute queried state okay so actually we do not created our table so create the table student and first we are taking the course goes well it will take 20 after course we are taking branch right so take 50 after all after name they didn't and a father named father name we're care you'll also take me hundred at last gender where can ten oh I just forget the roll number view it should be the primary I am Ricky so let me run this query let me show you the description okay you can see the course name branch roll roll number is a primary key okay so here we have to write the query to insert dot obvious so let me go start to student okay well you have to insert the values the first one is we are entering a Poor's goes and after course the next one is for branch by this after branch roll number insert name father Ling at last check the way this one is successfully inserted it will move to the response pubes also spawns dot send redirect so I'm writing admin Oh dot T is ok now we have to run this admin homepage so that we were not this one server click on finish restart the server for self is already running it will take little bit time no sir my drink we take ranch I'm just reading computer science problem and I'm including one tuple zero one okay and here are my knitting Amit Kumar father name I am writing is submit Tomas Linda I am the sitting mean I let me click on Steve waiting for response here let me check out in the order is select star from then here you can see that our data is successfully inserted you can see that course name be take branch computer science all damn what - / 0 1 Amit Kumar for the names Kumar gender you can see the meal so so this is all about add new student part so in the next video I am going to show you how to insert a new result in your database I hope you guys like this video so please hit like and subscribe my channel thank you hello everyone welcome to my youtube channel in the previous video I just created a new strain part where the admin entered this detail and when we click on save it will say to the our database so in this video I am going to create for the insert new results where admin internal number subject marks and click on save it will go to and a store in our database product to start and this one is our admin home page we can see here so for inserting result to be having action insert new result page so we need to create this page okay so there in the pill content section app folder we are creating a new JSP part JSP remove this click on finish inside name just to remove this wall and here we have to write the ports like at the rich page in boat okay and first we are going to import project dot connection provider okay after that you are reporting my Java dot my school Java dot school okay and me okay no now you have to take this string where he was okay first one is string roll number okay request the quiz torque it parameter here let's write the name of all let me check it out in her I've been home now you can see there is all number okay you all number and for this next one s1 subject one you can say that H 2 s 3 s po you can see that in the same way okay so let me write for this and I'm writing roll number let me copy this one to not write s 1 s 2 s 2 s 3 this full test file so chip you can see this s6 at last s7 okay now you have to also change the string variable name s 1 s 2 s 3 S 4 S 5 s 6 X 7 ok now we have to write the trycatch right slowly catch exception the chin okay now let's write connection connection bond goes to a connection provider Rider dot get con okay after that we have to create the statement statement that still equals to corn dot create statement okay after that we have to write the query okay X cubed cute update okay now first we need to create a table for this so let me open this okay our database name is project one okay so here you are we are going to create table create table table table result okay and here I'm entering roll number well care searching 10 after that subject s1 and we also taking it primary so that you're not in search duplicate values in it so subject 1s one end it has 3 s 2 8 3 s 3 int 3 S 4 int cs5 subject PI you can say that s 5 int 3 s 6 inch for checking it all swiftly s 7 int 3 okay click on ok we show you the description of this table al dirt I can see that roll number s1 s2 s3 s4 s5 s6 ok now we have to insert ok so here we are I am writing insert it into insert into result values first roll number and minimize this number column s1 to s2 s2 after s2 s3 the same variety for others yes for yes 5 yes six okay yes seven okay if this one is inserted then we are sending the response Todd since send you direct here to our admin homepage admin dot G is okay I need occur so just displaying that okay now it's time to run admin home so run this file run the run the server one server and insert the result I already inserted the dessert multiple zero one so there are my entering 50 50 60 70 80 90 this one is the max mark 6:30 so Lea I'm inserting 24 25 so little concede you can see that it will move to the or you can say de-frizz this page so let me check on him database that is brilliant search in our database or not prom result okay now you can see that the roll number is subject one subject to all marks as with certain successfully so this is all about insert new result okay and I also provided all the suits hood of this project that I am using HTML CSS a JavaScript and description just pull to description check out the link I already provided and if you need all the project of source food like JSP could also just comment in the comment section I will mail you ok so I hope you guys like this video so please hit like and subscribe my channel thank you hello everyone welcome to my youtube channel in the previous video I just show you how to insert new result part so if you don't seem that video just go to the description and check out the link I already provided in this video I am going to show you when you click on register destroy and it will show all the registered student details here so let's start now in this admin admin home dot JSP just move it in here and here you have to write the codes to display all the details of the student okay so let's write here at rate page goes to Java dot this will strike okay here we have to also write okay now after inputting this we have to improve the connection provider also result package dot connection provider now now we have to write the codes here first we are writing a try-catch okay connection connection pawn project play connection very tightly connection provider both get get gone okay after ed we have to create a statement here statement St Austell pawn dot creates statement after that we have to use result set result set our s push to st dot execute query here now here we have to write the query so here you are writing select star from a student ii certainly it is we have to display this to end it is so here we writing strength while while our s dot next okay this one you're writing the holes for this let me remove this okay because this money dot close there and they're closing it here the connection and all so really you're writing your goals for that to a little bit catch exception exception okay they're not displaying any exception here okay now in between we take here we have to write /r s dot RS dot get get string okay string name and here we are writing the column one okay in the same way we are writing for the others it will move this CSC from here and I am sitting to from earlier also removing the wrong number we are inserting three here and we're also removing this from three after four five five and here six okay now it's time to run this project and see that register is showing it is okay or this one page is loading now when we click on register restraint you can see that we take computer science roll number one to possess a one team up with c'mon and he can see the father's name is Sameer Kumar and male let me check on in our database select solve from student here you can see that the here the data is also same so you can see there is here that this data is coming from our database so that means that you wish to entertain so we can better check what - / 0 - okay branch sorry all Lamba the British science branch Here I am entering all the multiple 0 - & name here I'm inserting got one father name I have settings come on and gender hey okay okay now when we click on register this friend you can see that our detail has been inserted successfully so our number one - / 0 name wash and for the same Sunil Kumar at me okay so this is all it registered a student I hope you guys like this video so please hit like and subscribe my channel thank you hello everyone welcome to my youtube channel in the previous we divided show you about how is created distance print part okay we click on this it will show all the details for tetris friends okay so in this video i am going to create for the oldest friend results and we click on this it will display all the shrimp result okay so let's start here here we are right first move to the line number 3 0 2 and admin home okay here you have to write a great page okay boot Java dot squirrel dot okay and also writing the C and here we are importing project package project package don't connection provided class in it okay now now we have to write a try and catch try ok this are rising connection connection con here hitting connection provider provider Todd kid con ok already get into this package in video number second of a strand result my incision project if you want to see that just code is written down but this see yes I will be provided the link okay so here I've statement statement St Wells to cannot create statement here now up to the creating a statement weenies result side result set RS course USC dot excute query okay now we have to select result solely I created the table for it select star from result okay now here we have to write while while our s dot next okay let me about this now we have to move outside of this t body and here we have to write catch permission and you also need to close this okay those two and after there be a true catch catch exception error writing suppress this suppress okay now ambient right close to our s dot get get string okay I have to write the index values and just let me remove this too I'm writing three okay oh I have to write PI okay six seven and at last we are okay now let me run this file run this page on server click on finish eyes will open in you it will go all others taps now let me click on all destroyed result you can see that all the multiple zero mark secrecy fifty sixty seventy done it means hurt you result further all the more triple zero in the previous video I just registered this is trend okay 50 80 70 60 50 13 20 and 20 here okay let me click on save when we click on all is 20 yet you can see that is where all the details of that restraint has been displayed let me check out in our doctor this also from result okay you can see that all the details and you can see here the result of that is trend and it also stood in our database okay so this is all about a student result and you can say that it is all about the admin module now now we are going to move to the strength a module in next video so I hope you guys like this video so please hit like and subscribe my channel thank you welcome to my youtube channel in the frequency I just completed the admin module but if you don't see that wheew just go to the description and check out the link in this video I am working on strength module okay so let's open sprint home dot JSP and if you don't download this HTML CSS school just go to description I already provided the link you can download it from there okay so let's start here here you are right first we need to import connection provider okay boot push to project package dot connection Rider plus okay now we have to improve my spell also I treat each input Java dot okay now now here we have to write the codes okay try catch we have to take first roll number from this page straight Dzi when you okay there you can see that roll number name okay we are taking this from this page roll number and requesting dot request dot get parameter and Here I am entering roll number and after that we have to create the connection connection so that for that we are calling connection provider class from the package project okay fixin provider dot gate connection is a method in that class cooking now after that we have to create a statement statement st dot condor creator statement okay after that we need results is to extract data from our database yes RS st dot it X cubed query here now here we have to write the query to display okay display select you have to inner join because we need both details of a result as valid is Trent retains so put that we had start from student inner inner join mulled wine here we are is writing result a second table is result where a student dot roll number is equal to result dot roll number okay and and student dot roll number is equal equals to the [Music] equally possible roll number okay now let me run this query in our database also you can better understand why up why I write the sports query sorry so our database name is project one and we write this query here select now here I'm writing one triple zero one okay no now you can see here you can see all the details of the both to the table okay like to position one here when we written here then it's through all the details of that triple zero one from doing inner join with both okay no or we have to display this data like if roll Emma exists then it should be artist dot next okay now you started a packet and we need to also not be too close here or we have to display the data in field okay so let's go I hear we have to display the name of force named force name of his Trent okay so for that we are writing here yeah it was - RS dot kicked it straight okay and here I'm writing column number one because can see here the course whose name is at P tip thought that you can see the course name okay at the position one okay that's why I am written here for the branch we are writing here just let me copy this okay are they stored - Here I am writing - and for the next line yeah I am writing three you can see here the number one is for the cause number two for price number three for all number okay I'm the same way we are writing for number of four and five and six here writing for and for the father's name I am writing files and for gender I'm writing six in it okay let me show you one two three four five six six numbers for gender okay now let me get back to her okay now now we have to move to the subject subjects okay now here you can see that the physics one marks so for this we have to write one two three four five six seven eight eight number 48 so here I'm writing date and for writing nine display the marks of that trend okay for her via writing ten and four basic electrical we are eighteen eleven okay the same way we are writing for others 11:12 and for this rewriting her d and at last year 1840 let me show you her in the database one two three four five six seven eight nine ten eleven twelve thirteen fourteen the s7 subject is locked or fourteen okay you can see the little engineering physics lab you can see the results 8.8 this string is 14 now now we have to calculate the marks okay okay put that here we have displaying there also need to display the mark so for that now int sum we are taking a variable to add the marks get int and full from each column we are writing and the same we are is not good and we are taking for nine and a distort get it int 10 RS don't get it int 11 plus RS dot get int 12 plus our distort get pinched we are taking 30 at last our is Tod get and 14 okay now now you can see that our all subjects subject 1 2 3 4 5 6 7 has been added now you to print this so for that out dot print Ln and we are just printing the sum here okay of up to the printings and we also need to calculate the percentage of the marks so at line 185 you have to write this first we take this okay now here we are writing out dot print Ln and in this you have to write it some in 200 and / 560 our total marks you can see their total marks yeah total marks is 560 okay now at last we need to close the connection and cinge responds when it it wrong okay so for that we are writing here for the if condition is completed so for the else condition we are writing here if some errors occur or you can say that roll number does not exist for that response dot send the detail it okay so for that I already created a page here you can see the either Dzi one view here you can see that either Dzi one view okay let me write this either i1u dot HTML okay now this condition has been also completed now we have to close the now we have to okay now we have to write the catch condition for before catching we also need to close another now get to write the catch catch exception okay you also need to close this or if saying okay we forget the semicolon here I can see that it has been removed so now let me run this from the start our project has been completed so we are going to run this on server let me run this on server on finish it will take a little bit time to run Tom Perez particle thing okay or just opening now this one is our index page let me click on a string module are already registered one triple zero one draw lumber here okay so let me click on search they say a line number 196 let me open or 96 okay finger oh here I just need to reboot this okay and I just need to lose this because we do not close that ex-wife so Indira that meant okay 1 2 / 0 1 click on search can see all the details of this trend in see the college name pools name it's coming from the our database we are retrieving the data from a database when tuple 0 1 you can see let me show you the calculated percentage you can see that you can see 400 and the percentage is 71 and all you can see here okay let me get back and I mean triple 0 to 2 and when we click on search we'll also you can see here the details have been changed computer science call number to name Walmart and you can see all the percentage you can see the calculator percentage 62 percent 350 and you can see also the total marks and all so this is all about my training module I hope you guys like this video and this is all about my project a strain rigid binary system this project is completed I hope you guys liked this video so please hit like and subscribe my channel thank you

Channel: BTech Days

Views: 66,825

Keywords: project, complete project, final year project, server project, mysql, mysql database, jsp project

Id: smvCvhOs0lc

Length: 64min 4sec (3844 seconds)

Published: Sat Mar 28 2020