Difference between revisions of "Java-Business-Application/C2/Issuing-and-Returning-a-book/English-timed"

|  Welcome to the spoken-tutorial on '''Issuing and returning a book.'''

| In this tutorial, we will learn how to :

| Fetch all the user details

| To Issue a book

| To return a book

| Here we are using

|'''Ubuntu Version''' 12.04

| '''Netbeans IDE''' 7.3

| '''JDK''' 1.7

| '''Firefox''' web-browser 21.0

| To follow this tutorial you must have knowledge of

| Creating and viewing inventories  

| Here, in this tutorial we have added more functionalities to the '''Admin Section.'''

|  So, Let us switch to the '''browser.'''

|  Let us login again as the '''admin.'''

| We can see that we have two more options in the '''Admin Section Page - List Users '''and '''Checkout/Return Book.'''

| We can see that in the '''adminsetion.jsp''' there are two more '''radio buttons.'''

|Now, switch back to the '''browser.'''

|It has all the details like '''First Name, Surname, Age, Gender and Username.'''

|The steps are similar to the earlier two options.

| We saw them in the previous tutorial.

| We get a '''form '''which allows you to '''checkout '''as well as '''return book.'''

| So '''menuselection '''is equal to '''checkoutbook'''

| Now, let us come to '''checkOut ''' '''dot ''' '''jsp.'''

| This page is similar to that of '''listBooks '''''dot '''''jsp.'''

| Except that we have a '''radio button '''against each '''book.'''

| So that we can '''Checkout/Return ''' that '''book.'''

| We also have a '''username field '''to get the '''username '''of the '''user '''who has to '''checkout''' the book.

| We set the return date as one week from current date.

| This is done using the class '''Calendar.'''

| The add function of this class takes two parameters.

| The First is the present day of the year.

| Now note that  '''form action '''is equal to '''CheckoutServlet.'''

| Now, let us come back to the '''browser.'''

| We will now click on '''BookId 1.'''

| Type the '''username '''as '''arya. '''

| We see that the''' return date '''is one week from today’s date.

| Click on '''Checkout Book.'''

| We will click on '''here '''to come back to '''Admin Section Page.'''

| Go to '''CheckoutServlet.java.'''

|We have set the '''errorMsgs''' list

| Similarly we get  '''checkout_book, return_book '''and '''book id.'''

| Next, we parse the '''BookId '''as '''Integer '''from the '''Id.'''

| We validate the '''username '''and '''book id.'''

|  We also validate if '''Checkout_book '''and '''Return_Book '''is '''null.'''

|Then, we validate if either of them is not '''null.'''

|First we execute the query to check if the '''username '''exists in the '''table.'''

|  So, if the '''method '''returns 0 then, it means the '''user '''does not exist in the system.

| ''' else''', If user exists then we call  '''bookAlreadyIssued method.'''

| We execute the query to check if a '''book '''with the same '''bookid '''is issued by the same '''user.'''

| We get '''bookid '''from '''Checkout '''table.

| If '''BookId '''exists then, set the variable '''bookAlreadyIssued '''to '''1.'''

| We then return the value of '''bookAlreadyIssued.'''

| So, If the '''method '''returns '''1 '''then it means the same user has already borrowed this book.

|Now, come back to the '''browser.'''

| Now, Let us now try to '''checkout '''the same book by the same '''user.'''

|Click on the radio button against '''BookId 1.'''

|  We see that we get '''error message '''that''' the same user has already borrowed this book.'''

|Here, we get the '''availablecopies '''for corresponding '''id.'''

| We check if '''availableCopies '''is greater than '''0 '''and '''bookIssued '''''is equal to '''''0.'''

|  We get the '''dateofreturn '''from the '''request '''and store in the '''returndate.'''

| We then, call  '''insertIntoCheckout.'''

| Here, we execute the query to decrement the '''availablecopies '''in the''' Books table '''by '''1. '''

| Let us come to this method.

|  Then we we forward the '''request '''to '''successCheckout.jsp '''using '''RequestDispatcher.'''

| If '''availableCopies '''is '''0, '''then we print '''There are no copies of the requested book available.'''

|  Now, let us come to '''successCheckout '''''dot '''''jsp.'''

| We then, display the success message for successful '''Checkout.'''

| You can try out the different errors by yourself.

| Now, let us return the book.  So switch to the '''browser'''

| Click on '''bookId 1 '''and type the username as '''arya.'''

|  We can see that the number of available copies has been incremented.

|  Open '''CheckoutServlet '''''dot '''''java.'''

| We check if '''userExists '''''is equal to '''''1 '''and '''return_book '''''is not equal to '''''null.'''

| Let us come to this method.

| Here, we select the '''totalcopies '''and '''availablecopies '''from '''Books''' table for the '''book id.'''

| We store the '''totalcopies '''and '''availablecopies '''to '''totcopies '''and '''availcopies.'''

| Then we check if '''available copies '''exceed the '''totalcopies.'''

| Let us come back to the browser.

| Type the username as '''mdhusein.'''

| Click on  '''book id 1.'''

| Then click on '''Return Book.'''

| We can see that we get the '''error message''' '''The given user has not borrowed this book!!'''

| Let us come to this method.

| Here, we execute the query to delete from '''Checkout table '''the entry which has returned the book.

| Let us come to this method.

|Here, we increment the '''availablecopies '''by 1.

| We execute the query to update in the '''Books table.'''

| Now, come back to the browser. Come back to the login page.

| We can see that we have a link called '''Visitor’s Home Page. '''

| So, In this tutorial we have learnt:

| To list all the users

| 12:12

| To fetch a book

 

| 12:15

| To know more about spoken tutorial project, 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

| The Spoken Tutorial Project Team

|  Conducts workshops using spoken tutorials

|  Gives certificates to those who pass an online test

|  For more details please write to contact at spoken hyphen tutorial dot org

| 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

| The Library Management System has been contributed by a leading software MNC, through their Corporate Social Responsibility Programme.

| This is Arya Ratish from IIT Bombay signing off.  Thank you for joining.