https://script.spoken-tutorial.org/index.php?title=Java-Business-Application/C2/Creating-and-viewing-inventories/English&feed=atom&action=history
Java-Business-Application/C2/Creating-and-viewing-inventories/English - Revision history
2024-03-28T10:08:42Z
Revision history for this page on the wiki
MediaWiki 1.23.17
https://script.spoken-tutorial.org/index.php?title=Java-Business-Application/C2/Creating-and-viewing-inventories/English&diff=12137&oldid=prev
PoojaMoolya at 09:58, 25 June 2014
2014-06-25T09:58:20Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 09:58, 25 June 2014</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 4:</td>
<td colspan="2" class="diff-lineno">Line 4:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'''Keywords: video, tutorial,fetch book details, fetch borrowed book details'''</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'''Keywords: video, tutorial,fetch book details, fetch borrowed book details'''</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{| style="border-spacing:0;"</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{| style="border-spacing:0;"</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| style="border:1pt solid #000000;padding:0.097cm;"| <center>'''Visual Cue'''</center></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| style="border:1pt solid #000000;padding:0.097cm;"| <center>'''Visual Cue'''</center></div></td></tr>
</table>
PoojaMoolya
https://script.spoken-tutorial.org/index.php?title=Java-Business-Application/C2/Creating-and-viewing-inventories/English&diff=12136&oldid=prev
PoojaMoolya at 09:57, 25 June 2014
2014-06-25T09:57:30Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 09:57, 25 June 2014</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 4:</td>
<td colspan="2" class="diff-lineno">Line 4:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'''Keywords: video, tutorial,fetch book details, fetch borrowed book details'''</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'''Keywords: video, tutorial,fetch book details, fetch borrowed book details'''</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{| style="border-spacing:0;"</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{| style="border-spacing:0;"</div></td></tr>
</table>
PoojaMoolya
https://script.spoken-tutorial.org/index.php?title=Java-Business-Application/C2/Creating-and-viewing-inventories/English&diff=5937&oldid=prev
Arya Ratish: Created page with ''''Title of script''': Creating and viewing inventories '''Author: arya ''' '''Keywords: video, tutorial,fetch book details, fetch borrowed book details''' {| style="border-…'
2013-09-06T05:02:41Z
<p>Created page with ''''Title of script''': Creating and viewing inventories '''Author: arya ''' '''Keywords: video, tutorial,fetch book details, fetch borrowed book details''' {| style="border-…'</p>
<p><b>New page</b></p><div>'''Title of script''': Creating and viewing inventories<br />
<br />
'''Author: arya '''<br />
<br />
'''Keywords: video, tutorial,fetch book details, fetch borrowed book details'''<br />
<br />
<br />
<br />
{| style="border-spacing:0;"<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <center>'''Visual Cue'''</center><br />
| style="border:1pt solid #000000;padding:0.097cm;"| <center>'''Narration'''</center><br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 1<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Welcome to the spoken-tutorial on''' Creating and viewing inventories.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 2<br />
| style="border:1pt solid #000000;padding:0.097cm;"| In this tutorial we will learn to:<br />
<br />
* Modify the login page to redirect to admin page<br />
<br />
* Fetch all the book details <br />
* Fetch borrowed book details<br />
* To display the books borrowed by logged in user<br />
<br />
<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.106cm;"| Slide 3<br />
<br />
Software Requirements<br />
| style="border:1pt solid #000000;padding:0.106cm;"| Here we are using<br />
<br />
* Ubuntu Version 12.04<br />
* Netbeans IDE 7.3<br />
* JDK 1.7<br />
* Firefox web-browser 21.0<br />
<br />
You can use any web-browser of your choice.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.106cm;"| Slide 4<br />
<br />
Prerequisites<br />
| style="border:1pt solid #000000;padding:0.106cm;"| To follow this tutorial you must have knowledge of<br />
<br />
<br />
* Basics of '''Java Servlets '''and '''JSPs'''<br />
* Database and validation of fields<br />
<br />
If not, for relevant tutorials please visit our website.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.106cm;"| Switch to '''NetBeans IDE '''<br />
| style="border:1pt solid #000000;padding:0.106cm;"| Now, let us switch to '''NetBeans IDE '''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Point to the '''Books table.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| I have created the '''Books table.'''<br />
<br />
You can see the different fields in the table<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| I have inserted '''10 books '''into this '''table.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Point to '''Checkout table.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| I have created '''Checkout''' table to store borrowed books.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| I have inserted 5 entries into Checkout table.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| I have also created a '''model '''for '''Book '''and '''Checkout.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Open '''Book.java '''and '''Checkout.java.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| '''Book.java '''is a book model.<br />
<br />
And '''Checkout.java '''is a checkout model.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch to the browser.<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now, come to the browser.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| Let us login as the '''admin.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Type the username as '''admin '''and password as '''admin.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| So I will type the username and password''' as admin. '''Then click on '''Sign In.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Point your mouse on the '''Admin Section Page.'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| We can see that we come to the '''Admin Section Page.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch to '''Netbeans IDE.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| We will come back to this page. Now let us switch to '''Netbeans IDE. '''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| We will see we how we modified the '''GreetingServlet '''to redirect to '''Admin Page.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Open '''GreetingServlet.java.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Let us see the '''GreetingServlet.java.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''if(username.equals("admin") && password.equals("admin")) {'''<br />
<br />
'''RequestDispatcher view = request.getRequestDispatcher("adminsection.jsp");'''<br />
<br />
'''view.forward(request, response);'''<br />
<br />
'''return<nowiki>;</nowiki>'''<br />
<br />
''' '''<br />
<br />
'''}'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Here we check if '''username''' and '''password '''equals '''admin.'''<br />
<br />
If yes,''' '''then we redirect to '''adminsection.jsp.'''<br />
<br />
<br />
We have already seen how to forward to another page using '''RequestDispatcher.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch to '''browser.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now, switch back to the '''browser.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| We have two options here.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Click on the radio button for '''List Books.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| We will click on the '''radio button '''for '''List Books.''' <br />
<br />
Then click on '''Submit button.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Point to the '''list '''of all the '''books.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Here, we can see that we have the '''list '''of all the '''Books.'''<br />
<br />
It has all the details like '''Book Id, BookName,Author Name, Publisher, ISBN, Total Copies and Available copies.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now I will show you how this is done..<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the '''IDE.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the '''IDE.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Open '''adminsection.jsp.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now, let us come to the '''adminsection '''''dot '''''jsp.'''<br />
<br />
|-<br />
| 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>'''<br />
<br />
'''<nowiki><</nowiki>input type<nowiki>="</nowiki>radio" name<nowiki>="</nowiki>menuselection" value<nowiki>="</nowiki>listborrowedbooks">List Borrowed Books<nowiki> <</nowiki>br>'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Here we have two '''radio buttons.'''<br />
<br />
|-<br />
| 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>'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| The first one is to '''list '''all the '''books.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''form action<nowiki>=</nowiki>AdminSection.java.'''<br />
| 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'''''.''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Open '''AdminSection '''''dot '''''java.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Open '''AdminSection '''''dot '''''java.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''if(menuSelection.equals("listbooks")){'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| This checks the option that we click on.<br />
<br />
We clicked on List Books.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''rs = statement.executeQuery("SELECT * FROM Books");'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| So this part of code is executed.<br />
<br />
We execute query to fetch books from '''Books table.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight <br />
<br />
'''List<nowiki><</nowiki>Book> books = new ArrayList<nowiki><</nowiki>Book>();'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Next we create '''ArrayList''' to store the details of books<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''while(rs.next()){'''<br />
<br />
'''Book book = new Book();'''<br />
<br />
'''book.setBookId(rs.getInt("id"));'''<br />
<br />
'''book.setBookName(rs.getString("bookName"));'''<br />
<br />
'''book.setAuthorName(rs.getString("authorName"));'''<br />
<br />
'''book.setISBN(rs.getString("ISBN"));'''<br />
<br />
'''book.setPublisher(rs.getString("publisher"));'''<br />
<br />
'''book.setTotalCopies(rs.getInt("totalcopies"));'''<br />
<br />
'''book.setAvailCopies(rs.getInt("availablecopies"));'''<br />
<br />
'''books.add(book);'''<br />
<br />
'''}'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Then we iterate through the '''result set'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''Book book = new Book();'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| We create '''Book''' object<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''book.setBookId(rs.getInt("id"));'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| We set '''BookId '''into the '''Book '''object<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''book.setBookName(rs.getString("bookName"));'''<br />
<br />
'''book.setAuthorName(rs.getString("authorName"));'''<br />
<br />
'''book.setISBN(rs.getString("ISBN"));'''<br />
<br />
'''book.setPublisher(rs.getString("publisher"));'''<br />
<br />
'''book.setTotalCopies(rs.getInt("totalcopies"));'''<br />
<br />
'''book.setAvailCopies(rs.getInt("availablecopies"));'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Similarly we set other attributes of book into '''Book '''Object<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''books.add(book);'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Then we add '''book '''object into the '''books '''list.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''req.setAttribute("books", books);'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Then we set '''ArrayList books''' into the '''request.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''RequestDispatcher requestDispatcher = req.getRequestDispatcher("listBooks.jsp");'''<br />
<br />
'''requestDispatcher.forward(req, resp);'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| We forward the '''request '''to '''listBooks.jsp '''using '''RequestDispatcher'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now we come to '''listBooks.jsp'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><</nowiki>p>'''<br />
<br />
'''This form allows you to view the list of books.'''<br />
<br />
'''<nowiki></</nowiki>p>'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| In this page '''admin '''can view list of books.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight<br />
<br />
'''<nowiki><%</nowiki>'''<br />
<br />
'''List<nowiki><</nowiki>Book> books = (ArrayList<nowiki><</nowiki>Book>)request.getAttribute("books");'''<br />
<br />
'''%>'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Here, first we obtain '''books''' from '''request'''.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><</nowiki>table width<nowiki>='100%' </nowiki>border<nowiki>='1'></nowiki>'''<br />
<br />
'''<nowiki><</nowiki>thead align<nowiki>='</nowiki>center'>'''<br />
<br />
'''<nowiki><</nowiki>th>Book Id<nowiki></</nowiki>th>'''<br />
<br />
'''<nowiki><</nowiki>th>Book Name<nowiki></</nowiki>th>'''<br />
<br />
'''<nowiki><</nowiki>th>Author Name<nowiki></</nowiki>th>'''<br />
<br />
'''<nowiki><</nowiki>th>ISBN<nowiki></</nowiki>th>'''<br />
<br />
'''<nowiki><</nowiki>th>Publisher<nowiki></</nowiki>th>'''<br />
<br />
'''<nowiki><</nowiki>th>Total Copies<nowiki></</nowiki>th>'''<br />
<br />
'''<nowiki><</nowiki>th>Available Copies<nowiki></</nowiki>th>'''<br />
<br />
'''<nowiki></</nowiki>thead>'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| This '''HTML table''' will display details of books. <br />
<br />
<br />
<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><%</nowiki>'''<br />
<br />
'''for(Book book:books){'''<br />
<br />
'''%>'''<br />
<br />
'''<nowiki><</nowiki>tr align<nowiki>='</nowiki>center'>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><</nowiki>%=book.getBookId<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getBookName<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getAuthorName<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getISBN<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getPublisher<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getTotalCopies<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getAvailCopies<nowiki>() %></</nowiki>td>'''<br />
<br />
<br />
'''<nowiki></</nowiki>tr>'''<br />
<br />
'''<nowiki><%</nowiki>'''<br />
<br />
'''}'''<br />
<br />
'''%>'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| So we will iterate through the book list.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getBookId<nowiki>()%></</nowiki>td>'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Here we display '''BookId''' of book.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getBookName<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getAuthorName<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getISBN<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getPublisher<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getTotalCopies<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>book.getAvailCopies<nowiki>() %></</nowiki>td>'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Similarly we display other attributes of book.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| This is how we display the list of books.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the '''browser'''.<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now, switch back to the '''browser'''.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| click on '''List of Borrowed Books.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now, click on '''List of Borrowed Books.'''<br />
<br />
'''Click on Submit button.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Point to the '''list '''of the '''books '''issued.<br />
| style="border:1pt solid #000000;padding:0.097cm;"| We see a '''list '''of all the '''Books '''issued.<br />
<br />
It has details like '''Transaction Id, Book Id '''and '''Username.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the '''IDE.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now,I will switch back to the '''IDE.'''<br />
<br />
And show you the code for same.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Go to '''AdminSection.java.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Go to '''AdminSection.java.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''if(menuSelection.equals("listborrowedbooks")){'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| We had clicked on '''List Borrowed Books.'''<br />
<br />
So''' menuSelection '''is equal to '''List Borrowed books.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''rs = statement.executeQuery("SELECT * FROM Checkout order by transaction_Id");'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| The steps are similar to what we saw for '''List Books.'''<br />
<br />
We execute the query to fetch borrowed books details from '''Checkout table.'''<br />
<br />
<br />
<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''List<nowiki><</nowiki>CheckOut> checkOut = new ArrayList<nowiki><</nowiki>CheckOut>();'''<br />
<br />
'''while(rs.next()){'''<br />
<br />
'''CheckOut checkOutInstance = new CheckOut();'''<br />
<br />
'''checkOutInstance.setBookId(rs.getInt("book_Id"));'''<br />
<br />
'''checkOutInstance.setTransactionId(rs.getInt("transaction_Id"));'''<br />
<br />
'''checkOutInstance.setUserName(rs.getString("username"));'''<br />
<br />
'''checkOut.add(checkOutInstance);'''<br />
<br />
'''}'''<br />
<br />
'''req.setAttribute("checkout", checkOut);'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Then we iterate through borrowed books.<br />
<br />
And set it into '''request''' as '''checkout '''attribute.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now we come to '''listBooks.jsp'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| '''List<nowiki><</nowiki>CheckOut> checkout = (ArrayList<nowiki><</nowiki>CheckOut>)request.getAttribute("checkout");'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Here we obtain '''checkout''' from '''request'''.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight <br />
<br />
'''<nowiki><%</nowiki>'''<br />
<br />
'''for(CheckOut checkoutInstance:checkout){'''<br />
<br />
'''%>'''<br />
<br />
'''<nowiki><</nowiki>tr align<nowiki>='</nowiki>center'>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>checkoutInstance.getTransactionId<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>checkoutInstance.getBookId<nowiki>()%></</nowiki>td>'''<br />
<br />
'''<nowiki><</nowiki>td<nowiki>><%=</nowiki>checkoutInstance.getUserName<nowiki>()%></</nowiki>td>'''<br />
<br />
<br />
'''<nowiki></</nowiki>tr>'''<br />
<br />
'''<nowiki><%</nowiki>'''<br />
<br />
'''}'''<br />
<br />
'''%>'''<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| We iterate through the '''Checkout''' list.<br />
<br />
Here we display the attributes of '''Checkout.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| This is how we display '''Borrowed Books.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the''' browser.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now, switch back to the''' browser.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Point to the '''list.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| In the borrowed books page we also have one more '''list.'''<br />
<br />
The '''list '''of '''books '''issued where '''current date '''is more than the '''return date.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to '''IDE '''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to '''IDE '''to see the code.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| This is done in the same way as we did for '''Borrowed Books.'''<br />
<br />
<br />
<br />
<br />
|-<br />
| 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 ");'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| The only difference is in the '''SQL query.'''<br />
<br />
In the query we give the condition, '''return_date<nowiki> < </nowiki>now() order by transaction_Id.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now I will show you the interface for a normal user.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Switch back to the '''browser.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| So, switch back to the '''browser.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Come back to the '''login page.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Come back to the '''login page.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Type the username as '''mdhusein.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| I will login as '''mdhusein.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Type the password as '''welcome.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Type the password as '''welcome.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Click on '''Sign In.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Click on '''Sign In.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Point to '''Success Greeting Page.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| We get a '''Success Greeting Page.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''Transaction Id, User Name, Book Id '''and '''Return Date.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| It has the '''books '''currently borrowed by the '''user.'''<br />
<br />
It has details like '''Transaction Id, User Name, Book Id '''and '''Return Date.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Let us come back to the '''IDE.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now, let us come back to the '''IDE.'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Go to '''GreetingServlet.java.'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Now we go to '''GreetingServlet.java'''<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| We display the books issued in same way as we did for admin.<br />
<br />
<br />
Here the difference will be that we have to display books for the logged in user.<br />
<br />
<br />
<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| <br />
| style="border:1pt solid #000000;padding:0.097cm;"| So I get the username from this line.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Highlight '''stmt = con.prepareStatement("select * from Checkout where username <nowiki>= ? </nowiki>order by return_date");'''<br />
<br />
'''stmt.setString(1, username);'''<br />
<br />
'''rs = stmt.executeQuery();'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Then we fetch the details of borrowed books.<br />
<br />
With the condition username is equal to the logged in user. <br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Show '''successGreeting dot jsp'''<br />
| style="border:1pt solid #000000;padding:0.097cm;"| So, we get the list of books issued for the corresponding user.<br />
<br />
Then in '''successGreeting ''dot ''jsp '''we will display the list. <br />
<br />
<br />
This is how your '''successGreeting dot jsp '''will look.<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 8<br />
<br />
Summary<br />
| style="border:1pt solid #000000;padding:0.097cm;"| In this tutorial we have learnt to:<br />
<br />
* Modify the login page to redirect to admin page<br />
<br />
* Fetch all the book details <br />
* Fetch borrowed book details<br />
* To display the books borrowed by logged in user<br />
<br />
<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 9<br />
<br />
About slide<br />
<br />
<br />
<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Watch the video available at the following link.<br />
<br />
* It summarizes the Spoken Tutorial Project<br />
* If you do not have good bandwidth you can download and watch it<br />
<br />
<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 10<br />
<br />
About slide<br />
| style="border:1pt solid #000000;padding:0.097cm;"| The Spoken Tutorial Project Team<br />
<br />
* Conducts workshops using spoken tutorials<br />
* Gives certificates for those who pass an online test<br />
* For more details please write to contact at spoken hyphen tutorial dot org<br />
<br />
<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 11<br />
<br />
Acknowledgement<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Spoken Tutorial Project is a part of the Talk to a Teacher Project<br />
<br />
* It is supported by the National Mission on Education through ICT, MHRD, Government of India<br />
* More information on this mission is available at<br />
* http://spoken-tutorial.org/NMEICT-Intro<br />
<br />
<br />
<br />
|-<br />
| style="border:1pt solid #000000;padding:0.097cm;"| Slide 12<br />
<br />
Contributor Slide<br />
| 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.<br />
<br />
<br />
They have also validated the content for this spoken tutorial.<br />
<br />
<br />
This is Arya Ratish from IIT Bombay signing off.<br />
<br />
<br />
Thank you for joining.<br />
<br />
|}</div>
Arya Ratish