In Progress

Library Site

I need an online library website built using servlets and jsp or struts and beans, basically J2EE. the database is mysql and tomcat is the server

The site should have a database of books and users and a review table for book reviews(can be merged together with the book table). There would be different features for administrator of the site and of normal users.

A normal user can search for a book and reserve a book online, which would be reflected onto the database as the book being unavailable. Now since the library is online this reservation is like a ticket which is valid for 5 hours after which if the book hasnt been checked out from the actual library the ticket would then expire and the book becomes available again online. These above features have to have sessions associated with it.

A user should be able to do advanced search as well which could be on isbn, author name, book title.

Other than these a user when he logs in to the site he can see the books he has checked out along with the date it was checked out and when it is due. Also there should be a field called notifications wherein the administrator of the site can send him some messages.

He can click on books that he has checked out and be able to get an extension on the book. Also he should be able to write a review on the book as to how he found the book. This review feature would be used when someone searches for a book there would be a reviews link next to it which when clicked would display all the reviews that that particular book has recieved along with the name of the user who gave the review.

The administrator should be able to add/delete/update books/users on to the site. Also the administrator should be able to message particular users which would show up as notifications on the users home page once he logs in. One more thing the admin should be able to do is add news/alerts related to the website which would show up on the home page of the website.

One last feature, not really a feature but like a future enhancement would be to store all book searches(just the keyword searched for) along with the username which searched for the book in a table.

Finally the UI of the site need not be too fancy, a simple consisten background color would do.

I would need a database diagram, a simple ER diagram will be sufficient, or a diagram giving all the tables along with the column names. Also a list of all the classes along with the methods and variables.(sorry about this but need it to get a hang of the flow of the whole thing)

Skills: J2EE

See more: write like an author, used to write a book on, struts online, how to write out a book, how to write a book online, how to get online reviews, how get reviews, how can i get online reviews, get online reviews, get found now, ui-date, how to do title search, how to delete searches, delete searches, write book online, write an online book, i need an author, how to write an online book, tomcat, ticket reservation, struts, site server unavailable, servlets, online library, online book store

About the Employer:
( 2 reviews ) Boston, United States

Project ID: #297121

Awarded to:


Hi, plz chk PMB.

$250 USD in 10 days
(10 Reviews)

8 freelancers are bidding on average $238 for this job


We are having lot of experience in designand development of web application. Please let us know if you are interested.

$200 USD in 8 days
(1 Review)

I have more than 6 yrs experience having worked for multinational corporations. I can show you samples of my previous work if you want.

$250 USD in 10 days
(0 Reviews)

I have implemented the library system for my company that served up to 3000 peoples. All the functions, including material maintainence, borrowing and reservation, has been done by me. If you are interested, I can send More

$250 USD in 10 days
(0 Reviews)

I have two years experience of working in a bank mostly on J2EE, JSP, AJAX , Multimedia applications, Linux based applications etc., I can handle your project easily, will provide you with all the initials like functio More

$250 USD in 15 days
(0 Reviews)

This project looks pretty easy! It's my first experience with getafreelancer and I'm really patient about getting my first project on It. I would be glad to you if you gave me that chance, And therefore will do my best More

$200 USD in 10 days
(0 Reviews)

Hi,I have this project and i just need to made little change in the code

$250 USD in 15 days
(0 Reviews)

I have more than 10 years Experience in WEB DESIGNING,WEB DEVELOPMENT and SEARCH ENGINE OPTIMIZATION(SEO).I will Provide you the solution.

$250 USD in 25 days
(0 Reviews)