The “PRE-OWNED BOOKS MANAGEMENT” system has been developed to override the problems in the manual systems.The application is reduced as much as possible to avoid errors and to provide a reliable and fast management system.The aim is to satisfy the user requirements and have a good user interface.It will help the students in better utilization of resources that are available within the college.The user can either login as a buyer or a seller by entering their college code and their respective USN.The seller can sell their books which can be bought by their juniors who can view the books according to their branches and semesters.Thus trying to eliminate the middleman in the second hand business by connecting the students of the same college,hence making the task easier.

Generally we buy new textbooks and use them for very short time and then sell them to some random second hand book seller.The very same books will be brought by juniors for some extra price.If those same books are required for juniors,why not we exchange right here in college campus itself,rather than getting the same books for extra price. The idea here is simple,that is circulating those textbooks within the college eliminating the middlemen involved in second hand books business. The students after completing their exams/courses can come to a platform where they can sell their textbook providing some details.Anyone can login as seller or buyer and sell/purchase their books.

when these sellers/buyers register themselves,we will send a confirmation message to their gmail. During registration,they have to enter their college code.College code helps to organise books and show the availability of books to their particular college.When the seller posts any book,it should be available to the buyers of same college code so that we dont have to deal with transportation/shipping. The whole idea was to circulate books within campus only,so college code is very important to execute the core idea.

we also added handwritten notes,handwritten notes are getting in demand as they have more readability features.These notes will help students during their course examinations as they contain exactly what to learn and expect in examinations.These handwritten notes are added by sellers,interested buyers can purchase these notes.

Important thing here is since it is a idea of circulating books within college,there is no need of transportation here.

We can organize books according to semester,college,branches so that buyers can find their books easily.

The sellers and buyers are awarded points based on their purchases/sellings.

Sellers and buyers history is recorded and also the available books and sold books are updated after each successful purchase.

• Simple front end using Swing library in java.
• Eclipse IDE
• JDBC
• Database:mySQL server 8.0
• used two triggers and two stored procedures
• javax.mail.jar is used here to send mails to users confirming their login details.
• rs2xml.jar is used here to convert result sets to JTable.

eclipse IDE

mySQL workbench

mySQL server 8.0

mySQL connector jar

javax.mail.jar

rs2xml jar