Skip to content

Online Auction System for selling and buying different gadgets

Notifications You must be signed in to change notification settings

ChavaVennela/online-auction-system

Repository files navigation

Introduction

This project involves designing and implementing a relational database system for an online auction website called OAS/BuyMe. The system is intended to support users buying and selling items in an online auction similar to eBay.

The project requires the implementation of a user interface using HTML, CSS, a MySQL database server, and connectivity between the user interface and the database server using Java, Javascript, and JDBC.

Installation

To use the system, a local web server that will host the web application (Tomcat) as well as a MySQL server must be installed.

OAS

Online Auction System lets users buy and sell items in an online auction. This site will be restricted to a specific category of items with at least 3 hierarchical subcategories(in our case gadgets such as Laptops, Mobiles, Accessories), which require specific fields to be filled for those kinds of items.

Features

The online auction system will have three classes of users: end-users, customer representatives, and administrative staff members.

End-users

End-users can create and delete accounts, search for items on auction, set alerts for items they are interested in, view auction histories, and participate in auctions by placing their bids. They should also be able to view the list of auctions a specific buyer or seller has participated in and the list of "similar" items on auction in the preceding month.

Customer representatives

Customer representatives can answer questions and modify information as long as it is reasonable, including resetting passwords and removing bids. They must be able to perform such actions as well as removing illegal auctions.

Administrative staff member

Administrative staff members can create accounts for customer representatives and generate summary sales reports, including total earnings, earnings per item, earnings per item type, and best-selling items and end-users.

Auctions

Auctions involve a seller posting an item for sale, starting an auction, which will close at a specified date and time. The seller also posts an initial price, an minimum increment for bids, and a secret minimum price(reserve). Potential buyers post bids as part of the auction, and the user with the highest bid greater than reserve at closing time gets to buy the item. The system also incorporates Automatic bidding, which enchances the bidding process by allowing buyers to place bids without actively monitoring the auction. This feature empowers the buyer to set a secret upper limit, indicating how much they are willing to pay for the item.

Requirements

To use this system, you need to have a web server (Tomcat), MySQL server, Java, Javascript, and JDBC installed. You also need to clone the project repository and set up the database schema and tables.

Sample Login Details

Admin Credentials:
username: admin
password: admin

Customer Representative Credentials:

Customer Representative 1:
username: cr
password: cr

Customer Representative 2:
username: cr1
password: cr1

About

Online Auction System for selling and buying different gadgets

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •