View source for Java-Business-Application/C2/Creating-and-viewing-inventories/English

'''Title of script''': Creating and viewing inventories

'''Author: arya '''

'''Keywords: video, tutorial,fetch book details, fetch borrowed book details'''
{| style="border-spacing:0;"
| style="border:1pt solid #000000;padding:0.097cm;"| <center>'''Visual Cue'''</center>
| style="border:1pt solid #000000;padding:0.097cm;"| <center>'''Narration'''</center>

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 1
| style="border:1pt solid #000000;padding:0.097cm;"| Welcome to the spoken-tutorial on''' Creating and viewing inventories.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 2
| style="border:1pt solid #000000;padding:0.097cm;"| In this tutorial we will learn to:

* Modify the login page to redirect to admin page

* Fetch all the book details 
* Fetch borrowed book details
* To display the books borrowed by logged in user



|-
| style="border:1pt solid #000000;padding:0.106cm;"| Slide 3

Software Requirements
| style="border:1pt solid #000000;padding:0.106cm;"| Here we are using

* Ubuntu Version 12.04
* Netbeans IDE 7.3
* JDK 1.7
* Firefox web-browser 21.0

You can use any web-browser of your choice.

|-
| style="border:1pt solid #000000;padding:0.106cm;"| Slide 4

Prerequisites
| style="border:1pt solid #000000;padding:0.106cm;"| To follow this tutorial you must have knowledge of


* Basics of '''Java Servlets '''and '''JSPs'''
* Database and validation of fields

If not, for relevant tutorials please visit our website.

|-
| style="border:1pt solid #000000;padding:0.106cm;"| Switch to '''NetBeans IDE '''
| style="border:1pt solid #000000;padding:0.106cm;"| Now, let us switch to '''NetBeans IDE '''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Point to the '''Books table.'''
| style="border:1pt solid #000000;padding:0.097cm;"| I have created the '''Books table.'''

You can see the different fields in the table

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| I have inserted '''10 books '''into this '''table.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Point to '''Checkout table.'''
| style="border:1pt solid #000000;padding:0.097cm;"| I have created '''Checkout''' table to store borrowed books.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| I have inserted 5 entries into Checkout table.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| I have also created a '''model '''for '''Book '''and '''Checkout.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Open '''Book.java '''and '''Checkout.java.'''
| style="border:1pt solid #000000;padding:0.097cm;"| '''Book.java '''is a book model.

And '''Checkout.java '''is a checkout model.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Switch to the browser.
| style="border:1pt solid #000000;padding:0.097cm;"| Now, come to the browser.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| Let us login as the '''admin.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Type the username as '''admin '''and password as '''admin.'''
| style="border:1pt solid #000000;padding:0.097cm;"| So I will type the username and password''' as admin. '''Then click on '''Sign In.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Point your mouse on the '''Admin Section Page.'''



| style="border:1pt solid #000000;padding:0.097cm;"| We can see that we come to the '''Admin Section Page.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Switch to '''Netbeans IDE.'''
| style="border:1pt solid #000000;padding:0.097cm;"| We will come back to this page. Now let us switch to '''Netbeans IDE. '''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| We will see we how we modified the '''GreetingServlet '''to redirect to '''Admin Page.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Open '''GreetingServlet.java.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Let us see the '''GreetingServlet.java.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''if(username.equals("admin") && password.equals("admin")) {'''

'''RequestDispatcher view = request.getRequestDispatcher("adminsection.jsp");'''

'''view.forward(request, response);'''

'''return<nowiki>;</nowiki>'''

''' '''

'''}'''



| style="border:1pt solid #000000;padding:0.097cm;"| Here we check if '''username''' and '''password '''equals '''admin.'''

If yes,''' '''then we redirect to '''adminsection.jsp.'''


We have already seen how to forward to another page using '''RequestDispatcher.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Switch to '''browser.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Now, switch back to the '''browser.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| We have two options here.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Click on the radio button for '''List Books.'''
| style="border:1pt solid #000000;padding:0.097cm;"| We will click on the '''radio button '''for '''List Books.''' 

Then click on '''Submit button.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Point to the '''list '''of all the '''books.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Here, we can see that we have the '''list '''of all the '''Books.'''

It has all the details like '''Book Id, BookName,Author Name, Publisher, ISBN, Total Copies and Available copies.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| Now I will show you how this is done..

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the '''IDE.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the '''IDE.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Open '''adminsection.jsp.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Now, let us come to the '''adminsection '''''dot '''''jsp.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><</nowiki>input type<nowiki>="</nowiki>radio" name<nowiki>="</nowiki>menuselection" value<nowiki>="</nowiki>listbooks">List Books<nowiki> <</nowiki>br>'''

'''<nowiki><</nowiki>input type<nowiki>="</nowiki>radio" name<nowiki>="</nowiki>menuselection" value<nowiki>="</nowiki>listborrowedbooks">List Borrowed Books<nowiki> <</nowiki>br>'''



| style="border:1pt solid #000000;padding:0.097cm;"| Here we have two '''radio buttons.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><</nowiki>input type<nowiki>="</nowiki>radio" name<nowiki>="</nowiki>menuselection" value<nowiki>="</nowiki>listbooks">List Books<nowiki> <</nowiki>br>'''
| style="border:1pt solid #000000;padding:0.097cm;"| The first one is to '''list '''all the '''books.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''form action<nowiki>=</nowiki>AdminSection.java.'''
| style="border:1pt solid #000000;padding:0.097cm;"| We can see that in '''adminsection '''''dot '''''jsp '''we have the '''form action '''as equal to '''AdminSection'''''.''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Open '''AdminSection '''''dot '''''java.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Open '''AdminSection '''''dot '''''java.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''if(menuSelection.equals("listbooks")){'''
| style="border:1pt solid #000000;padding:0.097cm;"| This checks the option that we click on.

We clicked on List Books.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''rs = statement.executeQuery("SELECT * FROM Books");'''
| style="border:1pt solid #000000;padding:0.097cm;"| So this part of code is executed.

We execute query to fetch books from '''Books table.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight 

'''List<nowiki><</nowiki>Book> books = new ArrayList<nowiki><</nowiki>Book>();'''
| style="border:1pt solid #000000;padding:0.097cm;"| Next we create '''ArrayList''' to store the details of books

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''while(rs.next()){'''

'''Book book = new Book();'''

'''book.setBookId(rs.getInt("id"));'''

'''book.setBookName(rs.getString("bookName"));'''

'''book.setAuthorName(rs.getString("authorName"));'''

'''book.setISBN(rs.getString("ISBN"));'''

'''book.setPublisher(rs.getString("publisher"));'''

'''book.setTotalCopies(rs.getInt("totalcopies"));'''

'''book.setAvailCopies(rs.getInt("availablecopies"));'''

'''books.add(book);'''

'''}'''



| style="border:1pt solid #000000;padding:0.097cm;"| Then we iterate through the '''result set'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''Book book = new Book();'''
| style="border:1pt solid #000000;padding:0.097cm;"| We create '''Book''' object

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''book.setBookId(rs.getInt("id"));'''
| style="border:1pt solid #000000;padding:0.097cm;"| We set '''BookId '''into the '''Book '''object

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''book.setBookName(rs.getString("bookName"));'''

'''book.setAuthorName(rs.getString("authorName"));'''

'''book.setISBN(rs.getString("ISBN"));'''

'''book.setPublisher(rs.getString("publisher"));'''

'''book.setTotalCopies(rs.getInt("totalcopies"));'''

'''book.setAvailCopies(rs.getInt("availablecopies"));'''
| style="border:1pt solid #000000;padding:0.097cm;"| Similarly we set other attributes of book into '''Book '''Object

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''books.add(book);'''
| style="border:1pt solid #000000;padding:0.097cm;"| Then we add '''book '''object into the '''books '''list.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''req.setAttribute("books", books);'''
| style="border:1pt solid #000000;padding:0.097cm;"| Then we set '''ArrayList books''' into the '''request.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''RequestDispatcher requestDispatcher = req.getRequestDispatcher("listBooks.jsp");'''

'''requestDispatcher.forward(req, resp);'''



| style="border:1pt solid #000000;padding:0.097cm;"| We forward the '''request '''to '''listBooks.jsp '''using '''RequestDispatcher'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| Now we come to '''listBooks.jsp'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><</nowiki>p>'''

'''This form allows you to view the list of books.'''

'''<nowiki></</nowiki>p>'''



| style="border:1pt solid #000000;padding:0.097cm;"| In this page '''admin '''can view list of books.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight

'''<nowiki><%</nowiki>'''

'''List<nowiki><</nowiki>Book> books = (ArrayList<nowiki><</nowiki>Book>)request.getAttribute("books");'''

'''%>'''



| style="border:1pt solid #000000;padding:0.097cm;"| Here, first we obtain '''books''' from '''request'''.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><</nowiki>table width<nowiki>='100%' </nowiki>border<nowiki>='1'></nowiki>'''

'''<nowiki><</nowiki>thead align<nowiki>='</nowiki>center'>'''

'''<nowiki><</nowiki>th>Book Id<nowiki></</nowiki>th>'''

'''<nowiki><</nowiki>th>Book Name<nowiki></</nowiki>th>'''

'''<nowiki><</nowiki>th>Author Name<nowiki></</nowiki>th>'''

'''<nowiki><</nowiki>th>ISBN<nowiki></</nowiki>th>'''

'''<nowiki><</nowiki>th>Publisher<nowiki></</nowiki>th>'''

'''<nowiki><</nowiki>th>Total Copies<nowiki></</nowiki>th>'''

'''<nowiki><</nowiki>th>Available Copies<nowiki></</nowiki>th>'''

'''<nowiki></</nowiki>thead>'''



| style="border:1pt solid #000000;padding:0.097cm;"| This '''HTML table''' will display details of books. 




|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><%</nowiki>'''

'''for(Book book:books){'''

'''%>'''

'''<nowiki><</nowiki>tr align<nowiki>='</nowiki>center'>'''

'''<nowiki><</nowiki>td<nowiki>><</nowiki>%=book.getBookId<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getBookName<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getAuthorName<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getISBN<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getPublisher<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getTotalCopies<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getAvailCopies<nowiki>() %></</nowiki>td>'''


'''<nowiki></</nowiki>tr>'''

'''<nowiki><%</nowiki>'''

'''}'''

'''%>'''



| style="border:1pt solid #000000;padding:0.097cm;"| So we will iterate through the book list.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getBookId<nowiki>()%></</nowiki>td>'''
| style="border:1pt solid #000000;padding:0.097cm;"| Here we display '''BookId''' of book.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getBookName<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getAuthorName<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getISBN<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getPublisher<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getTotalCopies<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getAvailCopies<nowiki>() %></</nowiki>td>'''
| style="border:1pt solid #000000;padding:0.097cm;"| Similarly we display other attributes of book.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| This is how we display the list of books.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the '''browser'''.
| style="border:1pt solid #000000;padding:0.097cm;"| Now, switch back to the '''browser'''.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| click on '''List of Borrowed Books.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Now, click on '''List of Borrowed Books.'''

'''Click on Submit button.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Point to the '''list '''of the '''books '''issued.
| style="border:1pt solid #000000;padding:0.097cm;"| We see a '''list '''of all the '''Books '''issued.

It has details like '''Transaction Id, Book Id '''and '''Username.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the '''IDE.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Now,I will switch back to the '''IDE.'''

And show you the code for same.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Go to '''AdminSection.java.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Go to '''AdminSection.java.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''if(menuSelection.equals("listborrowedbooks")){'''
| style="border:1pt solid #000000;padding:0.097cm;"| We had clicked on '''List Borrowed Books.'''

So''' menuSelection '''is equal to '''List Borrowed books.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''rs = statement.executeQuery("SELECT * FROM Checkout order by transaction_Id");'''
| style="border:1pt solid #000000;padding:0.097cm;"| The steps are similar to what we saw for '''List Books.'''

We execute the query to fetch borrowed books details from '''Checkout table.'''




|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''List<nowiki><</nowiki>CheckOut> checkOut = new ArrayList<nowiki><</nowiki>CheckOut>();'''

'''while(rs.next()){'''

'''CheckOut checkOutInstance = new CheckOut();'''

'''checkOutInstance.setBookId(rs.getInt("book_Id"));'''

'''checkOutInstance.setTransactionId(rs.getInt("transaction_Id"));'''

'''checkOutInstance.setUserName(rs.getString("username"));'''

'''checkOut.add(checkOutInstance);'''

'''}'''

'''req.setAttribute("checkout", checkOut);'''



| style="border:1pt solid #000000;padding:0.097cm;"| Then we iterate through borrowed books.

And set it into '''request''' as '''checkout '''attribute.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| Now we come to '''listBooks.jsp'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| '''List<nowiki><</nowiki>CheckOut> checkout = (ArrayList<nowiki><</nowiki>CheckOut>)request.getAttribute("checkout");'''



| style="border:1pt solid #000000;padding:0.097cm;"| Here we obtain '''checkout''' from '''request'''.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight 

'''<nowiki><%</nowiki>'''

'''for(CheckOut checkoutInstance:checkout){'''

'''%>'''

'''<nowiki><</nowiki>tr align<nowiki>='</nowiki>center'>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>checkoutInstance.getTransactionId<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>checkoutInstance.getBookId<nowiki>()%></</nowiki>td>'''

'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>checkoutInstance.getUserName<nowiki>()%></</nowiki>td>'''


'''<nowiki></</nowiki>tr>'''

'''<nowiki><%</nowiki>'''

'''}'''

'''%>'''



| style="border:1pt solid #000000;padding:0.097cm;"| We iterate through the '''Checkout''' list.

Here we display the attributes of '''Checkout.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| This is how we display '''Borrowed Books.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the''' browser.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Now, switch back to the''' browser.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Point to the '''list.'''
| style="border:1pt solid #000000;padding:0.097cm;"| In the borrowed books page we also have one more '''list.'''

The '''list '''of '''books '''issued where '''current date '''is more than the '''return date.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to '''IDE '''
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to '''IDE '''to see the code.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| This is done in the same way as we did for '''Borrowed Books.'''




|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''rs = statement.executeQuery("SELECT * FROM Checkout where return_date<nowiki> < </nowiki>now() order by transaction_Id ");'''
| style="border:1pt solid #000000;padding:0.097cm;"| The only difference is in the '''SQL query.'''

In the query we give the condition, '''return_date<nowiki> < </nowiki>now() order by transaction_Id.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| Now I will show you the interface for a normal user.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the '''browser.'''
| style="border:1pt solid #000000;padding:0.097cm;"| So, switch back to the '''browser.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Come back to the '''login page.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Come back to the '''login page.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Type the username as '''mdhusein.'''
| style="border:1pt solid #000000;padding:0.097cm;"| I will login as '''mdhusein.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Type the password as '''welcome.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Type the password as '''welcome.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Click on '''Sign In.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Click on '''Sign In.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Point to '''Success Greeting Page.'''
| style="border:1pt solid #000000;padding:0.097cm;"| We get a '''Success Greeting Page.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''Transaction Id, User Name, Book Id '''and '''Return Date.'''
| style="border:1pt solid #000000;padding:0.097cm;"| It has the '''books '''currently borrowed by the '''user.'''

It has details like '''Transaction Id, User Name, Book Id '''and '''Return Date.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Let us come back to the '''IDE.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Now, let us come back to the '''IDE.'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Go to '''GreetingServlet.java.'''
| style="border:1pt solid #000000;padding:0.097cm;"| Now we go to '''GreetingServlet.java'''

|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| We display the books issued in same way as we did for admin.


Here the difference will be that we have to display books for the logged in user.




|-
| style="border:1pt solid #000000;padding:0.097cm;"| 
| style="border:1pt solid #000000;padding:0.097cm;"| So I get the username from this line.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''stmt = con.prepareStatement("select * from Checkout where username <nowiki>= ? </nowiki>order by return_date");'''

'''stmt.setString(1, username);'''

'''rs = stmt.executeQuery();'''
| style="border:1pt solid #000000;padding:0.097cm;"| Then we fetch the details of borrowed books.

With the condition username is equal to the logged in user. 

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Show '''successGreeting dot jsp'''
| style="border:1pt solid #000000;padding:0.097cm;"| So, we get the list of books issued for the corresponding user.

Then in '''successGreeting ''dot ''jsp '''we will display the list. 


This is how your '''successGreeting dot jsp '''will look.

|-
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 8

Summary
| style="border:1pt solid #000000;padding:0.097cm;"| In this tutorial we have learnt to:

* Modify the login page to redirect to admin page

* Fetch all the book details 
* Fetch borrowed book details
* To display the books borrowed by logged in user



|-
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 9

About slide



| style="border:1pt solid #000000;padding:0.097cm;"| Watch the video available at the following link.

* It summarizes the Spoken Tutorial Project
* If you do not have good bandwidth you can download and watch it



|-
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 10

About slide
| style="border:1pt solid #000000;padding:0.097cm;"| The Spoken Tutorial Project Team

* Conducts workshops using spoken tutorials
* Gives certificates for those who pass an online test
* For more details please write to contact at spoken hyphen tutorial dot org



|-
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 11

Acknowledgement
| style="border:1pt solid #000000;padding:0.097cm;"| Spoken Tutorial Project is a part of the Talk to a Teacher Project

* It is supported by the National Mission on Education through ICT, MHRD, Government of India
* More information on this mission is available at
* http://spoken-tutorial.org/NMEICT-Intro



|-
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 12

Contributor Slide
| style="border:1pt solid #000000;padding:0.097cm;"| The Library Management System has been contributed by a leading software MNC, through their Corporate Social Responsibility Programme.


They have also validated the content for this spoken tutorial.


This is Arya Ratish from IIT Bombay signing off.


Thank you for joining.

|}