Automated Book Bank System: Ordering Books in Engineering Colleges | Essays (university) Journalism

IOSR Journal of Mobile Computing & Application (IOSR-JMCA)

e-ISSN: 2394-0050, P-ISSN: 2394-0042.Volume 4, Issue 2 (Mar. - Apr. 2017), PP 20-25

www.iosrjournals.org

DOI: 10.9790/0050-04022025 www.iosrjournals.org 20 | Page

Book Bank Automation System

Boomija .M.D[1], Sahaya Michel Rosetta .K[2], Priya Dharshini .P[3],

Sree Swarna Laximi .S[4]

[1]Assistant Professor - 1, Department of Information Technology, Prathyusha Engineering College

(Thiruvallur, Tamil Nadu, India), Anna University, India

[2] [3] [4]Department of Information Technology, Prathyusha Engineering College (Thiruvallur, Tamil Nadu,

India), Anna University, India.

Abstract: In this project, the process of ordering books in a book bank by the student is automated. At present,

this project is designed for the engineering colleges following Anna University syllabus, only for a few common

branches of engineering such as IT, CSE, Civil, and Mech.The student has to first register into the system with

the following details: Name, Password, DOB, College, Dept, Semester, Email, Phone number. On registration,

the student will be provided with a unique student registration ID which is auto generated by the system. Using

the name and password, the student can log into the system. In the student profile page, all the details of the

students are displayed. From this page, the student can navigate to the request books page, where he can select

his department the semester, and the books that he needs. Once he chooses the books and submits the request,

the system will reserve the book and send him an automated email regarding the book chosen, and the date of

issue. The administrator can log into the system, add new book details, edit the existing book details, and also

edit the student details. When the student comes personally to receive the books, the admin updates the student

profile that the student has received the books. This application was coded using Java Servelets, JSP, for the

server and client side scripting, MySQL 2005 as the rear end, HTML as the front end.

I. Introduction

What is Web Application?

Web application or web app is an application program that is stored on a remote server and delivered

over the internet. Web applications are accessed over a network connection using HTTP and run on a

compatible browser. In some web applications, a small part of the program is stored in the user’s desktop, but

processing is done over the internet on external server. The main concepts involved are:

 HTTP

 Java Server Pages

HTTP: The Hypertext Transfer Protocol (HTTP) is an application protocol for distributed, collaborative, and

hypermedia information systems. HTTP is the foundation of data communication for the World Wide Web.

Hypertext is structured text that uses logical links (hyperlinks) between nodes containing text.HTTP functions as

a request–response protocol in the client–server computing model. A web browser, for example, may be

the client and an application running on a computer hosting a website may be the server. The client submits an

HTTP request message to the server.The server which provides resources such as HTML files and other

content, or performs other functions on behalf of the client, returns a response message to the client. The

response contains completion status information about the request and may also contain requested content in its

message body.

Partial preview of the text

Download Automated Book Bank System: Ordering Books in Engineering Colleges and more Essays (university) Journalism in PDF only on Docsity!

IOSR Journal of Mobile Computing & Application (IOSR-JMCA)

e-ISSN: 2394-0050, P-ISSN: 2394-0042.Volume 4, Issue 2 (Mar. - Apr. 2017), PP 20-

www.iosrjournals.org

Book Bank Automation System

Boomija .M.D

[1]

, Sahaya Michel Rosetta .K

[2]

, Priya Dharshini .P

[3]

Sree Swarna Laximi .S

[4] [1] Assistant Professor - 1, Department of Information Technology, Prathyusha Engineering College (Thiruvallur, Tamil Nadu, India), Anna University, India [2] [3] [4] Department of Information Technology, Prathyusha Engineering College (Thiruvallur, Tamil Nadu, India), Anna University, India.

Abstract: In this project, the process of ordering books in a book bank by the student is automated. At present,

this project is designed for the engineering colleges following Anna University syllabus, only for a few common branches of engineering such as IT, CSE, Civil, and Mech.The student has to first register into the system with the following details: Name, Password, DOB, College, Dept, Semester, Email, Phone number. On registration, the student will be provided with a unique student registration ID which is auto generated by the system. Using the name and password, the student can log into the system. In the student profile page, all the details of the students are displayed. From this page, the student can navigate to the request books page, where he can select his department the semester, and the books that he needs. Once he chooses the books and submits the request, the system will reserve the book and send him an automated email regarding the book chosen, and the date of issue. The administrator can log into the system, add new book details, edit the existing book details, and also edit the student details. When the student comes personally to receive the books, the admin updates the student profile that the student has received the books. This application was coded using Java Servelets, JSP, for the server and client side scripting, MySQL 2005 as the rear end, HTML as the front end.

I. Introduction

What is Web Application? Web application or web app is an application program that is stored on a remote server and delivered over the internet. Web applications are accessed over a network connection using HTTP and run on a compatible browser. In some web applications, a small part of the program is stored in the user’s desktop, but processing is done over the internet on external server. The main concepts involved are:  HTTP  Java Server Pages HTTP: The Hypertext Transfer Protocol ( HTTP ) is an application protocol for distributed, collaborative, and hypermedia information systems. HTTP is the foundation of data communication for the World Wide Web. Hypertext is structured text that uses logical links (hyperlinks) between nodes containing text.HTTP functions as a request–response protocol in the client–server computing model. A web browser, for example, may be the client and an application running on a computer hosting a website may be the server. The client submits an HTTP request message to the server.The server which provides resources such as HTML files and other content, or performs other functions on behalf of the client, returns a response message to the client. The response contains completion status information about the request and may also contain requested content in its message body.

Java Server Pages: JavaServer Pages ( JSP ) is a technology that helps software developers create dynamically generated web pages based on HTML, XML, or other document types. JSP is similar to PHP, ASP and React's JSX but it uses the Java programming language. To deploy and run JavaServer Pages, a compatible web server with a servlet container, such as Apache Tomcat is required. JSP is a high-level abstraction of Java servlets. JSPs are translated into servlets at runtime, therefore JSP is a Servlet; each JSP servlet is cached and re-used until the original JSP is modified. JSP can be used independently or as the view component of a server-side model–view–controller design, with JavaBeans as the model and Java servlets as the controller. JSP allows Java code and certain pre-defined actions to be interleaved with static web markup content, such as HTML, with the resulting page being compiled and executed on the server to deliver a document. The compiled pages, as well as any dependent Java libraries, contain Java bytecode rather than machine code. Like any other Java program, they must be executed within a Java virtual machine (JVM) that interacts with the server's host operating system to provide an abstract, platform-neutral environment.

JSPs are usually used to deliver HTML and XML documents, but through the use of OutputStream, they can deliver other types of data as well. The Web container creates JSP implicit objects like request, response, session, application, config, page, pageContext, out and exception. JSP Engine creates these objects during translation phase.

Objective And Scope The main objective of this project is to automate the process of registering and ordering books in a book bank by the student. At present, this project is designed for a few common branches (IT, CSE, Mech, and Civil) of the engineering colleges following Anna University syllabus. At present, all the tasks in a book bank are done manually, involving a lot of paper work. The student has to visit book bank for the process of registration and also request for books. Also, it is also difficult for the staff to to find information of a particular student since the data is stored in an Excel spreadsheet. In this Book Bank Automation System the process of registration and ordering books is automated. The students can register online and also view their profile online. The main purpose of developing this book bank automation system is to design an application, which could store student and book data and provide an interface for registering, ordering books online, retrieving student and book related details with 100% accuracy This book bank automation system also allows admin to add and modify the details of a new book, delete account. Using this system admin can also search any individual profile in few seconds. The system will check the user’s existence in the database and provide the set of services.

II. System Analysis

Existing System: The present system is only some book banks are partially automated, that is by storing details in MS Excel Spreadsheets, whereas many other book banks are manual. A student has to visit the book bank personally at least thrice to get a set of the books that are needed. Also only the student has to give the list of books needed along with the exact details of the ordered books, such as author’s name, edition, name of the publication, etc. Only the list of students registered and the books available are stored in the database. Due to this the manual

System Implementation Home Page

Admin Login page

Registration Page

Student Login

Add Book page

Viewing Book Details

Automated Book Bank System: Ordering Books in Engineering Colleges, Essays (university) of Journalism

Related documents

Partial preview of the text

Download Automated Book Bank System: Ordering Books in Engineering Colleges and more Essays (university) Journalism in PDF only on Docsity!

IOSR Journal of Mobile Computing & Application (IOSR-JMCA)

e-ISSN: 2394-0050, P-ISSN: 2394-0042.Volume 4, Issue 2 (Mar. - Apr. 2017), PP 20-

www.iosrjournals.org

Book Bank Automation System

Boomija .M.D

, Sahaya Michel Rosetta .K

, Priya Dharshini .P

Sree Swarna Laximi .S

Abstract: In this project, the process of ordering books in a book bank by the student is automated. At present,

I. Introduction

II. System Analysis