Java-Business-Application/C2/Creating-and-viewing-inventories/English-timed

From Script | Spoken-Tutorial
Revision as of 17:15, 25 June 2014 by PoojaMoolya (Talk | contribs)

Jump to: navigation, search
Time
Narration
00.01 Welcome to the spoken-tutorial on Creating and viewing inventories.
00.07 In this tutorial we will learn to:
00.09 Modify the login page to redirect to admin page
00.14 To fetch all the book details
00.17 To fetch borrowed book details
00.20 To display the books borrowed by logged in user
00.25 Here we are using
00.27 Ubuntu Version 12.04
00.29 Netbeans IDE 7.3
00.32 JDK 1.7
00.34 Firefox web-browser 21.0
00.38 You can use any web-browser of your choice.
00.42 To follow this tutorial you must have knowledge of
00.45 Basics of Java Servlets and JSPs
00.50 Database and validation of fields
00.53 If not, for relevant tutorials please visit our website.
00.57 Now, let us switch to NetBeans IDE
01.01 I have created the Books table.
01.04 You can see the different fields in the table
01.08 I have inserted 10 books into this table.
01.12 I have created Checkout table to store borrowed books.
01.18 I have inserted 5 entries into Checkout table.
01.24 I have also created a model for Book and Checkout.
01.29 Book.java is a book model.
01.32 And Checkout.java is a checkout model.
01.37 Now, come to the browser.
01.40 Let us login as the admin.
01.43 So I will type the username and password as admin. Then click on Sign In.
01.51 We can see that we come to the Admin Section Page.
01.55 We will come back to this page. Now let us switch to Netbeans IDE.
02.02 We will see we how we modified the GreetingServlet to redirect to Admin Page.
02.08 Let us see the GreetingServlet.java.
02.13 Here we check if username and password equals admin.
02.19 If yes, then we redirect to adminsection.jsp.
02.25 We have already seen how to forward to another page using RequestDispatcher.
02.32 Now, switch back to the browser.
02.35 We have two options here.
02.37 We will click on the radio button for List Books.
02.41 Then click on Submit button.
02.44 Here, we can see that we have the list of all the Books.
02.49 It has all the details like Book Id, BookName,Author Name, ISBN, Publisher, Total Copies and Available copies.
02.59 Now I will show you how this is done.
03.03 Switch back to the IDE.
03.05 Now, let us come to adminsection dot jsp.
03.10 Here we have two radio buttons.
03.14 The first one is to list all the books.
03.19 We can see that in adminsection dot jsp we have the form action equal to AdminSection.
03.28 Now, Open AdminSection dot java.
03.32 Here, this checks the option that we click on.
03.36 We clicked on List Books.
03.39 So this part of the query will be executed.
03.44 We execute query to fetch books from Books table.
03.49 Next we create ArrayList to store the details of the books
03.55 Then we iterate through the result set
03.59 We create the Book object
04.03 We set BookId into the Book object
04.08 Similarly we set other attributes of the book into Book Object
04.16 Then we add book object into the books list.
04.21 Then we set the ArrayList books into the request.
04.26 Then we forward the request to listBooks.jsp using RequestDispatcher
04.33 Now we come to listBooks.jsp
04.38 In this page admin can view list of books.
04.43 Here, first we obtain the books from request.
04.48 This HTML table will display details of the books.
04.54 So we will iterate through the book list.
04.58 Here we display the BookId of the book.
05.02 Similarly we display other attributes of the book.
05.07 This is how we display the list of books.
05.11 Now, switch back to the browser.
05.14 Click on List Borrowed Books.
05.17 And Click on Submit button.
05.20 We see a list of all the Books issued.
05.24 It has details like Transaction Id, Book Id and Username.
05.29 Now,I will switch back to the IDE.
05.32 And show you the code for same.
05.35 Go to AdminSection.java.
05.38 We had clicked on List Borrowed Books.
05.42 So menuSelection is equal to List Borrowed books.
05.47 The steps are similar to what we saw for List Books.
05.53 We execute the query to fetch borrowed books details from the Checkout table.
05.59 Then we iterate through the borrowed books.
06.02 And set it into request as checkout attribute.
06.07 Now we come to listBorrowedBooks.jsp
06.12 Here we obtain checkout from the request.
06.17 We iterate through the Checkout list.
06.20 And, here we display the attributes of the Checkout.
06.25 This is how we display Borrowed Books.
06.28 Now, switch back to the browser.
06.30 In the borrowed books page we have one more list.
06.36 The list of books issued when the current date is more than the return date.
06.43 Switch back to IDE to see the code.
06.46 This is done in the same way as we did for Borrowed Books.
06.50 The only difference is in the SQL query.
06.56 In the query we give the condition, return_date less than now() order by transaction_Id.
07.05 Now I will show you the interface for a normal user.
07.10 So, switch back to the browser.
07.12 Come back to the login page.
07.15 I will login as mdhusein.
07.20 Type the password as welcome.
07.22 And click on Sign In.
07.25 We get a Success Greeting Page.
07.28 It has the books currently borrowed by the user.
07.32 It has details like Transaction Id, User Name, Book Id and Return Date.
07.39 Now, let us come back to the IDE.
07.43 Now we go to GreetingServlet.java
07.47 We display the books issued in same way as we did for the admin.
07.53 Here the difference will be that we have to display the books for the logged in user.
08.02 So I get the username from this line.
08.05 Then we fetch the details of borrowed books.
08.10 With the condition username is equal to the logged in user.
08.14 So, we get the list of books issued for the corresponding user.
08.20 Then in successGreeting dot jsp we will display the list.
08.27 This is how your successGreeting dot jsp will look.
08.32 In this tutorial we have learnt to:
08.35 Modify the login page to redirect to admin page
08.39 To fetch the book details
08.42 To fetch borrowed book details
08.45 And to display the books borrowed by logged in user
08.50 To know more about the spoken tutorial project, watch the video available at the following link.
08.56 It summarizes the Spoken Tutorial Project
08.59 If you do not have good bandwidth you can download and watch it
09.04 The Spoken Tutorial Project Team
09.06 Conducts workshops using spoken tutorials
09.09 Gives certificates to those who pass an online test
09.13 For more details please write to contact at spoken hyphen tutorial dot org
09.20 Spoken Tutorial Project is a part of the Talk to a Teacher Project
09.24 It is supported by the National Mission on Education through ICT, MHRD, Government of India
09.30 More information on this mission is available at http://spoken-tutorial.org/NMEICT-Intro


09.40 The Library Management System has been contributed by a leading software MNC, through their Corporate Social Responsibility Programme.
09.49 They have also validated the content for this spoken tutorial.
09.53 This is Arya Ratish from IIT Bombay signing off.
09.57 Thank you for joining.

Contributors and Content Editors

PoojaMoolya, Pratik kamble, Sandhya.np14