smu_mca final year project_complementary auction system

Complementary Auction System

SCHOOL OF BUSINESS

INSTITUTE OF TECHNOLOGY

CENTRE CODE: 007

“COMPLEMENTARY AUCTION SYSTEM”

BY

HHHReg. No.: CAS007

A project report submitted in partial fulfillment of the requirements for

Master of Computer Applications

Of Sikkim Manipal University, INDIA

NOVEMBER 2012 Sikkim Manipal University of Health, Medical and Technological

Sciences Distance education wing, Syndicate house, Manipal-576119

1


This is to certify that the project report entitled


Submitted in partial fulfillment of the requirements for the degree of

Master of Computer Applications ofSikkim-Manipal University of Health, Medical and technological Sciences

HHH

has worked under my supervision and guidance and that no part of this

report has been submitted for the award of any other Degree, Diploma,

Fellowship or other similar titles or prizes and that the work has not been

published in any journal or Magazine.

(Reg.No. : CAS007 ) Certified

Stephanie M

(GUIDE NAME WITH QUALIFICATIONS)

2


EXAMINER’S CERTIFICATION

The project report of

HHH


Is approved and is acceptable in quality and form

Internal Examiner External Examiners

DECLARATION

3


I here by declare that the project report entitled


Submitted in partial fulfillment of the requirements for the degree of

Master of Computer Applications

To Sikkim-Manipal University, India, is my original work and not submitted

for the award of any other degree, diploma, fellowship, or any other similar

title or prizes

Place: Name: HHHDate: Reg. No.: CAS007

4


ACKNOWLEDGEMENT

I would, first and foremost, like to thank God Almighty for his perpetual blessings

and guidance through out this project.

I express my deep sense of gratitude to the Director of Prof. Kioski, School of

Business, for providing me an opportunity and continuous encouragement for

doing this project. His suggestions benefited immensely. Further he also provided

me with valuable inputs and guidance in writing this project.

I also thanks to Mrs. Stephanie M for her valuable guidance, co-operation and

support with out which this project would not have been successful.

Last but not the least, I thank my family and well wishers for their encouragement

and support with which this report would not have materialized.

HHH

Table of contents

5


S.No Title Page No1. Abstract 72. Introduction 73. Brief history of Internet auctions 94. Types of On-line Auction Markets 115. Benefits of On-line Auctions 136. Economic Effects of On-line Auctions 147. Limitations of On-line Auctions 158. Scope 169. Requirement Specifications 17

9.1 Business Requirements 179.2 System Requirements 179.3 User Requirements 189.4 Software and Hardware Requirements 18

10. Design Details 1910.1 E-R Diagram 1910.2 Usecase Diagram 2010.3 Class Diagram 2410.4 Interaction Diagrams 2610.5 Database Tables 31

10.6 Input Forms Formats 3410.7 Report Formats 37 11. Test Plans 50 12. Future Enhancements 5213. Conclusion 5314. Bibliography And 5415. References 54 ANNEXURE-1(Sample code) 55 ANNEXURE-2(Sample Reports) 58

1. ABSTRACT:

6


Many auctions involve the sale of variety of distinct assets. Examples are airport time

slots, delivery routes and furniture. Because of complementarities between the different assets,

bidders have their own preferences. For this reason, economic efficiency is enhanced.

When an auction of items is performed, it is often desired to allow bids on particular

item. Such an auction is often called “Complementary” auction.

This application involves the sellers who post the items that are to be kept for auction,

buyers bid for the item in the auction; admin monitors the details of auction. Finally, application

declares the winning bid by providing maximum economic efficiency to the seller.

Seller has to provide all the required details of the item (amount, year of manufacturing,

category, and minimum increment in the price) and the buyer will consider all the details and

bid for the item. Admin has to take care of posting the items according to the date intimated by

the seller and close the auction on the end date.

2. INTRODUCTIONInternet auctions appeared on the scene in the mid 1990s, and quickly became one of the most

successful applications of electronic commerce. EBay, the premier consumer-to-consumer

(C2C) Internet auction site is generally held up as an exemplar for the industry. However, it is

widely predicted that the potential transaction volume in business-to-business (B2B) auctions

will be much greater than in the C2C channel.

In the B2B marketplace, auctions were initially pressed into service as tools to dispense with

excess inventory. One-time market leaders like Onsale helped companies, primarily consumer

electronics manufacturers, sell products near the end of their lifecycle. The current wave of B2B

integration represents a much deeper integration of auction technology into the day-to-day

operations of many businesses. In particular, companies are using auctions in many

procurement situations in an effort to extract better prices from their suppliers. This move

toward more formal and rigorous negotiation with suppliers folds neatly into the need to better

manage the supply chain and make operations more efficient. The third wave of integration will

7


involve the use of dynamic pricing through the entire product lifecycle, on both the sales and

procurement sides. We are already starting to see evidence that products are being sold by

auction earlier in their lifecycles; IBM and Sun regularly sell relatively new products via a

distribution channel on eBay.

Though eBay sets the standard for features and performance in C2C markets, the potential

applications of auctions to B2B markets requires more varied and complex systems, and places

different burdens on the auction administrators. On the one hand, B2B auctions may require

more elaborate and sophisticated auction processes, such as combinatorial auctions (Rothkopf,

1998). On the other hand, B2B markets tend to have well known and authenticated bidders and

lower overall communication loads.

Auction systems have three distinct sets of users: the bidders, the auction initiator, and the

auction system administrator. Each class of users requires different core and complementary

features of an auction system. Note that we do not treat sellers and buyers separately; in the

general case they are both bidders and have the same needs. On most consumer-to-consumer

sites, the seller is the auction initiator, and places his one and only bid, to establish the reserve

price, during the creation of the auction, if at all. The auction system administrator is the

person (or group of people) who installs, configures, and maintains the auction site.

This article discusses many of the issues related to Internet auctions for B2B, B2C, and C2C

marketplaces. The discussion is framed by a brief history of auctions on the Internet, followed

by an introduction to some central concepts. The rest of the article is divided into two parts: a

description of the core features of auction systems, followed by a discussion of features that

are complementary and commonly impact the design or selection of an auction system.

3. BRIEF HISTORY OF INTERNET AUCTIONS

8


It is difficult to pinpoint the earliest auction held on the Internet, but it is clear that auctions

were conducted via e-mails and newsgroups as early as 1988. As the Web developed in the

early 1990s, it was only a matter of time before people began using this new technology to

enhance their online auctions. At first, sellers simply provided a static source of multimedia

information (i.e., text and images) about the products being auctioned and continued to collect

bids via e-mail. Later, sellers used Web forms to actually collect and process bids. EBay,

founded in 1995, was among the earliest known auction services available on the Internet.

However, within a year eBay had many competitors, including uBid, Onsale, Z-auctions, and

more. In the B2B arena, Fastparts.com was an early market maker, having bulletin board based

systems as early as 1991, and launching a Web-based system around 1996.4 Internet auction

platforms were also being developed in research laboratories in 1996, including the Michigan

Internet AuctionBot (Wurman, Wellman, and Walsh, 1998), the FishMarket system

(Rodriguez,Noriega, Sierra, and Padget, 1997), and GEM (Reich and Ben-Shaul, 1998).

The need to rapidly build hundreds of electronic auction sites in a wide variety of industries

created opportunities for packaged and hosted software systems. In order to satisfy the

demand, several companies built and marketed auction software. Among the best known of the

auction service providers were OpenSite, Trading Dynamics, Moai, and FreeMarkets.

FreeMarkets was founded in 1995 and Moai formed in 1996. OpenSite began life as Web Ducks,

Inc. around the same time, while Trading Dynamics was founded in 1998. OpenSite and Trading

Dynamics were acquired in 2000 by, respectively, Siebel Systems and Ariba. Around the same

time, IBM was building its own auction engine (Kumar and Feldman, 1998), and CommerceOne

acquired CommerceBid to obtain auction technology. Moai and FreeMarkets both remain

independent companies. Though these more established companies remain the leaders, the

field has become crowded with new ventures, such as i2, ProcureNet, Frictionless, and ICG

Commerce, and procurement solutions introduced by multinational companies like SAP,

General Electric, and IBM.

In the early days of e-commerce, it was logical for auction software companies to design

flexibility into their products so that they could be employed in many application markets. Thus,

these products are typically designed to allow customization, to some degree. The amount and

9


type of customization depends on the particular details of the target market, and whether the

auction engine was slanted more towards B2B, B2C, or C2C applications. Today, most major

ecommerce vendors have an auction product targeted at B2B procurement, though these

products vary widely in features and customizability.

More recently, there has been growing interest in advanced auction formats. These advanced

formats include combinatorial auctions–auctions that allow bidders to place offers on sets of

items. Several companies have recently begun offering systems that manage combinatorial

trading. Another type of advanced auction that is starting to appear in electronic systems is the

multi-attribute auction, in which the object (or contract) being negotiated has several

negotiable parameters in addition to price. An oft-cited example is a negotiation between a

manufacturer and a supplier in which product quality (or purity) and delivery date are

negotiable. In a multi-attribute auction, different suppliers will offer contracts that differ in the

promised product quality or delivery schedule, and the buyer needs a well-defined method for

selecting among the contracts and (optionally) generating the equivalent of price quotes.

It is also important to note that Internet auctions were not the first auctions facilitated by

electronic networks. NASDAQ’s Small Order Execution SystemSM began operation in 1984, and

many of the stock exchanges now incorporate electronic trading or electronic support systems.

Historically, financial systems ran on closed networks, with custom trading stations at

designated, access-controlled locations. Operating markets on the public networks raises new

concerns, such as security, privacy, identify verification, and network availability. In addition,

the much wider variety of products and services being negotiated on the Internet requires

versatile trading systems.

10


4. Types of On-line Auction MarketsPerhaps the most striking aspect of on-line auctions is their diversity and their potential

applications to a great number of markets. There are many ways in which one can classify on-

line auctions currently on the Internet: by the types of products offered; method of operation;

and geographical coverage. The types of products sold in on-line auctions may be divided into

two general categories:

a) Products in excess supply - On-line auctions may be used in the case of products that

have a greater supply than demand for them. Many such products are considered

perishable whose value may decrease significantly or drop to zero if they are not sold in

time. For example, Cathay Pacific features on-line sealed-bid auctions for airline tickets

on a daily basis. The reason for such auctions is that the value of airline seats drops to

zero if they remain empty as soon as the plane takes off. Travel bid is another example

of an on-line auction Web site in the travel industry. The lots featured by this Web site

are travel packages- The site uses what it calls a 'reverse auction" where a buyer posts

the price that he or she is prepared to pay and travel package suppliers post their

potential offers. The lowest offer or the closest one to the buyer's price wins the

auction.

b) Products in excess demand - shortages in the availability of certain products could also

lead to the creation of on-line auction markets. Many such markets feature products

that are considered rare and have buyers ready to bid up the price. For example,

Currans Select Auction is a Web site that is dedicated to the auction of sports

memorabilia. Cyberhorse.com is an on-line auction where one many purchase all things

equestrian ranging from live horses to stud breeding services. Special used equipment

could be found at PlanetTest.com, which is a market catering to the testing and

scientific industries. Much of the equipments sold are used machinery that would be

quite expensive if bought brand new. Even guns have found a market in on-line auctions

such as those conducted by Gunbroker.com. Finally, new items that do not have a

market in the physical world may be traded in online auctions. A good example is

DomainAuction.com, which is an on-line auction for internet domain names.

11


The second type of classification for on-line auction markets is their Method of Operation. This

may be described as the 'business model' which the on-line auction adopts. There are a number

of varieties here:

a) Intermediary - In this method of operation, products are not consigned to the on-line

auction. The market acts as a meeting space for traders who are interested in disposing

of or buying products. For example, any person who wished to sell a particular item may

post it on eBay where it is sold under the English Auction rules. Another intermediary

on-line auction is BidnAsk, which is modeled after a stock exchange using the Double

Auction methodology.

b) Supplier Affiliated - In this type of on-line auction; products are procured or consigned

to the on-line auction. In other words, the on-line auction does not act simply as an

agent but acquires title to the goods and resells them by means of an auction. On Sale

uses this method to sell a variety of refurbished computer and electronic equipment.

Another example is the BrentWood Wine Company, which uses on-line auctions to sell

fine wine from affiliated producers'.

Finally, on-line auction markets could be divided according to their geographical coverage. This

may appear to be an irrelevant point since on-line auctions are held on the internet and,

therefore, may be accessed from any part of the world. However, certain products are not

suited for a global market. For example, in the case of used automobiles, the overseas shipping

expenses may greatly increase the overall cost. Such products as used automobiles and used

computers are more cost-effective in local on-line auction markets.

5. Benefits of On-line Auctions

12


The questions that come to mind, at this point, are what are the attractions or advantages

behind on-line auctions over other modes of selling goods? What are the reasons that have

propelled these Web sites to such popularity on the Internet? Naturally the many buyers and

sellers of on-line auctions have their own reasons for conducting this type of e-Commerce. The

main reasons for using on-line auctions are summarized as:

a) Interactivity - on-line auctions, unlike fixed price e-commerce, offer a unique type of

'shopping experience'. The nature of the on-line auction Web sites offer e-Commerce

combined with the interactive features of the Internet. These interactive features include

the ability to buy and sell products, chat with others etc. In a sense, the on-line auction may

be viewed in many ways as an on-line e-Commerce 'game' that includes the excitement of

winning and shopping at the same time.

b) Bargaining hunting - on-line auctions may be regard as a very effective way to find a

bargain. Sellers can simply post products to an essentially worldwide audience, earn extra

money, clear excess inventories etc. In other words, the on-line auction provides an

inexpensive and efficient channel to display and sell a product. From the buyers point of

view the prices achieved in on-line auctions are often very much discounted from regular

prices. This channel allows traders a greater chance of obtaining a bargain than in the case

of the fixed price system

c) Product variety - on-line auctions give buyers the ability to have access to a variety of

goods that may, otherwise be essentially impossible to reach. The breadth of goods may

include collectibles, used computers, real estate, cars and so on. What is interesting is that

one observes that many of the items that have not found success though fixed price e-

Commerce have enjoyed much more success with auction pricing e-Commerce. Part of this

reason may well lie behind the parties' inability to put a "fair" price on such items as a

Beanie doll, an antique or an autographed baseball. In any case, on-line auctions have also

enjoyed success with "traditional' products sold by fixed price e-Commerce such as books,

hardware and software.

d) Community - Another feature that is quite different form fixed price e-Commerce is the

appearance of virtual 'trading communities' whose members have become quite fiercely

13


loyal to them. Although there are many similarities between on-line auctions, each has

developed their own set of market rules and mechanisms that are tailored towards the

products and services they feature. The development of these on-line auction communities

goes hand in hand with the virtual community structure that has been adopted by internet

users especially over the last few years. Such structures include discussion groups, mailing

lists and chat rooms tailored towards specific types of products and traders

e) Charity - this is a relatively new, yet more and more frequent motivation behind on-line

auctions. Many of the on-line auctions Web sites are conducting Charity Auctions to raise

money for various global causes.

6. Economic Effects of On-line Auctions

As mentioned, on-line auctions represent a major portion of e-Commerce activities and are

forecasted to experience significant growth. It is thus imperative that there is a clear

understanding of the economic impacts that this form of commerce may have. Due to the

relatively recent introduction of on-line auctions, it is hard to predict what their impact may be-

However, a number of possible effects are:

a) Profitability - on-line auctions give traders, both individuals and companies, access to a

relatively inexpensive channel that allows them to sell their goods in an efficient manner

requiring little effort besides entering the appropriate information. This could represent

a significant reduction in the costs previously incurred in selling these products.

Moreover, a greater range of potential buyers could be attracted due to the global

nature of the on-line auction. This translates into extra cash and increases in revenues.

b) Distribution channels - on-time auctions could represent a new distribution channel for

a variety of products and services. This channel could have the effect of supporting

other channels or competing with them. For example, certain distribution channels may

remain intact while the on-line auction is used solely as an efficient method for

specialized sales such as last minute offerings or overstocked items. On the other hand,

14


on-line auctions may act as substitutes to certain distribution channels and completely

or partially replace them.

c) Pricing - on-line auctions could place pricing pressures on the same or similar products

being sold using other distribution channels 1121. The lower prices and deals that can

be potentially created by on-line auctions can lead to price erosion in the overall

market.

d) Specialized markets - on-line auctions may support markets with distinct product

segmentations. The reason for this is that this type of commerce can enable sellers to

approach a global buying presence that has very specific interests. As opposed to other

channels, on-line auctions have the potential to generate high volume sales even for a

much segmented product. On-line auctions can thus become the basis for many new

specialized markets.

7. Limitations of On-line Auctions

In addition to their benefits and effects, it is important to look at some of the limitations of on-

line auction markets. Perhaps the most prominent of these limitations are:

a) Product Access - On-line auctions do not usually allow one to physically see the lots that

are being placed for sale. Instead, many on-line auctions provide photographs and other

multi-media representations of these lots.

b) Fraud - On-fine auctions provide a better opportunity for fraudulent when compared

with traditional physical auctions. Such activities may involve lot misrepresentation,

insecure trading settlements, auction rings etc. Popular on-line auctions have attempted

to address fraud by means of setting rigorous institutional policies and the use of

various secure technologies. However, even the most successful on-line auctions face a

certain amount of fraud.

c) Downtime - The reliance of on-line auctions on Information Technology make it

susceptible to any malfunctioning or glitches in the system. Good examples here are the

recent series of crashes of the e-Bay system. Such downtimes tend to cause trader

15


frustration and reduce their belief in the reliability of the on-line auction as a sales

channel.

d) Auction Time - Unlike a physical auction, which is usually over in a short period of tirne,

an on-line auction may take a few days or even weeks. This naturally slows down the

market lifecycle and may not be useful for products that require immediate liquidation.

Another concern is that the competitive environment in an on-line auction may become

less dynamic than their traditional counterparts due to these extended auction periods.

One finds that typical on-line auctions feature very little activity for the majority of the

auction until the termination time nears and the traders begin to bid up or down the

price in a rapid manner. On-line auction market activity could be therefore limited, in

practical terms, to a short period of time. This means that unless one is available for that

period of time and has a fairly quick internet connection. he or she may not be able to

place their bids properly. In short, on-line auctions can become dependent on a very

short interval of time although they are conducted over a much longer period.

8. SCOPE:

The process of an online auction is much the same as a live auction. This means that

users place bids for items, and the goods get sold to the highest bidder. You are notified

through email on the status of your bids, which is when you place a bid, when you've been

outbid and when you've won an item.

Our system aims to provide powerful functionalities to the user by making use of simple

easy-to-easy interface.

This application reduces the stress on sellers and buyers where the seller can conduct

the auction without any constrains, buyers can gain the item just by providing their details in

the application.

9. REQUIREMENT SPECIFICATION

16


9.1 Business Requirements

A requirement is a documented condition or capability to which the product, service,

or system must conform in meeting project objectives. Requirements management is a

systematic approach to eliciting, organizing, and documenting the requirements of the product,

service, or system. The Business Requirements Definition document serves as the project

baseline that explains, in business terms, what is to be accomplished during the Project Design

Stage. Because requirements are dynamic, the BRD is a progressive document in that the

objective is to record what is known at the time and then build on it as the project progresses.

9.2 System Requirements

MODULES:

Admin:

Complementary Auction System provides the complete information related to products

for sale and the buyers can bid for the products and can own them all this has to be provided

and maintained by the admin, because the complete auction process is to be kept under

control till the product sale gets confirmed. It has to verify the details given by the buyer and

seller then it has to confirm all the things furnished by the both buyer and seller.

Seller:

Sellers want a place where he can sale his products at a higher price and get maximum

benefit out of that. This is the place where seller can display all his products and sell them.

Seller can display all the possible products for sale and can call the people for the auction then

after receiving the final bidding whichever is the highest that the highest bidder owns the

product. Seller can have the benefits directly without any third people involvement.

Buyer:

17


The people always want different things to purchase but in some situations the buyer

may need the essentials for time being that is for temporary purpose where he likes to go for

an auction. For this buyer has to just furnish his details and can participate in the bidding to

acquire the product, which is for sale.

9.3 User Requirements User requirements typically describe the needs, goals, and tasks of

the user. “Typically” here means that often these user requirements don’t reflect the actual

person who will be using the software; projects are often tailored to the needs of the project

requestor, and not the end-user of the software. User requirements document define and

describe the end-user, and that any measurements of quality or success be taken with respect

to that end-user.

User requirements are usually defined after the completion of task analysis, the

examination of the tasks and goals of the end-user.

9.4 Software and Hardware RequirementsSoftware requirements:

Operating System : Windows XP.

Languages : JDBC, JSP, HTML.

Data Base : Oracle10g express edition.

Server : Tomcat 6.0.

Hardware Requirements:

Processor : PIV and successors

RAM : 256 MB

Hard Disk : 40 GB

10. DESIGN DETAILS.

18


10.1 E-R Diagrams

It represents the entire application where buyer, seller registers then logins. Seller posts the

items; buyers bid the item and pay for it. Finally the application declares the winning bid.

UML Diagrams:

19

USER

LOGIN

REGISTRATION

CURRENT BID ITEMS

USERID

PASSW ORD

USER

BUYER SELLER

BUY ITEMS

BID ON ITEMS

SELL ITEMS

POST ITEMS

PAY TO


10.2 Use case diagrams:

Login Page:

SELLER BUYER

check id and pwd

DatabaseRegister

USER

Login

logout

ADMIN

Homepage

In Login page, User (Seller, Buyer) will be provided Registration form to be filled with all

mandatory details and then will be given access to the application through the id and password

given by him at the time of registration. Whereas admin can login directly without any

registration required. The database of the application verifies the user id and password each

time they login.

20


SELLER MODULE:

update and delete items

seller 1

Register items

Post (add) items

seller n

edit information

view feedback

Item is posted

current bid items list

Provide Details of Winning bid

Database

view today and tomorrow details

Seller

view help page

Once the seller logins, registers the items which he wanted to put for the auction, then he posts

the items into the application through database. Even he can insert, delete also edit the

information regarding the items he had posted. Database then provides details of current bid

item list, items held for that and the next day. Finally after implementation of the application

database provides the details of winning bid to the seller.

BUYER MODULE:

21


Buyer 1 Buyer n

verify the creditcard no

Pay for the bid

Provide amount for bid

Provide feedback

View Item Details

Confirms the bid

view prices

edit information

Declare winning bid

view help page

BuyerDatabase

view today and tomorrow details

Once the buyer logins, he will be provided with the details of the items kept for auction, then

buyer choose the bid of his interest and provide the amount he can afford for the bid. Now, the

application confirms the bid and stores it in database. Also the buyer will have the option of

editing his details. Once the commencement of end date of auction appears, application

provides the details of winning bid by that the user has to pay for the bid. Database will then

validates the credit card details of the buyer and confirms the winning bid. Finally the buyer can

provide the feedback to the seller.

ADMIN MODULE:22


view sellers

view buyers

delete bid items which ends

ADMIN

all privileges like seller

DATABASE

all privileges like buyer

Admin will view the sellers, buyers, monitors the details of items by editing, deleting the items.

23


10.3 Class diagramsLogin Page:

Buyer

viewDetailsofItems()buy()provideFeedback()

SelleritemName : String

sell()postItems()viewFeedback()

Userfirst name : Stringlast name : StringAddress : SingleZIP : IntegerTel : StringBank : Stringid : String

login()logout()

HomePage

onClick()1* 1*

login

Databaseuinfo_master : Tabledinfo_master : Tablebidding_info : tablecategory_master : tableclientlist : tableitem_master : table

insertuser()getPwd()insertAuction()deleteAuction()insertProduct()addLog()getAuction()getProduct()

validate id,password

Registrationregistrationformname : stringformNumber : number

getRequest()generateforms()setinfotodatabase()

request form

loads info

24


BUYER MODULE:

EditInfosellerid : stringpassword : stringfirstName : stringlastName : stringaddress : stringitemdetails : string

storeData()

Biddingcreditcardno : integeramount : integer

bidItems()buyItems()payamount()

BuyerFirstName : StringLastName : StringBank : Stringid : Stringtel : StringAddress : StringZip : Integer

createBid()viewItemDetails()payment()

Databaseuinfo_master : tableitem_master : tablecategory_master : tabledinfo_master : tableclientlist : tablebidding_info : table

insertAuction()deleteAuction()insertUser()getPwd()getProduct()insertProduct()addLog()getAuction()

1

*

bid for items

stores into database

provide feedback

update info

stores details

*

1

25


10.4 Interaction Diagrams

Sequence diagrams:Login Page:

SELLER / BUYER

ADMIN HomePage DatabaseRegistration

login request

login page

submit detailsvalidate

success and open main page

enter homepagereq for registration page

send the reg page

submit details

login request

login page

submit detailsvalidate

success and open main page

26


Seller Module:

Seller current bid items

NewAuction items today

AuctionItems end today

registration login postitems sold items edit profile Logout

Display current bid details

display new Auction details today

display end auctions today

registration

check username and passwordvalidate

post item to system

display already sold items

update profile

logout

27


Buyer Module:

Buyer Current bid items

New Auction items today

Auction items end today

Registration login Buy items Edit profile Logout

Display Current bid details

Display new Auction today

Auction items end today details

registration

provide username and passwordvalidate

bid amount on the item

provide credit card number

validates

update profile

provide feedback

logout

ADMIN MODULE:

Admin current bid items

New Auction today

Auctions end today

Admin login view details of bid items

view details of the user

logout

display current bid items

display new Auctions

display current date end auction

check adminname and password

validate

display all current bid items

display the result of the user

logout

28


Collaboration diagrams:Login Module:

ADMIN

SELLER / BUYER

HomePage

Database

Registration

1: login request

2: login page

3: submit details

4: validate

5: success and open main page

6: enter homepage

7: req for registration page

8: send the reg page

9: submit details

10: login request

11: login page

12: submit details

13: validate

14: success and open main page

Seller Module:

Seller

current bid items

NewAuction items today

AuctionItems end today

registration

login

postitems

sold items

edit profile Logout

6: validate

1: Display current bid details

2: display new Auction details today

3: display end auctions today

4: registration

5: check username and password

7: post item to system

8: display already sold items

9: update profile10: logout

29


BUYER MODULE:

Buyer

Current bid items

New Auction items today

Auction items end today

Registration

login

Buy items

Edit profile

Logout

6: validate

9: validates

1: Display Current bid details

2: Display new Auction today

3: Auction items end today details

4: registration5: provide username and password

7: bid amount on the item8: provide credit card number 10: update profile

11: provide feedback

12: logout

ADMIN MODULE:

Admin

current bid items

New Auction today

Auctions end today

Admin login

view details of bid items

view details of the user

logout

5: validate

1: display current bid items

2: display new Auctions

3: display current date end auction

4: check adminname and password

6: display all current bid items

7: display the result of the user

8: logout

30


10.5 Database tables

Uinfo_Master:(Buyer information):

Column Name Data Type Size Constraint Type

Uname Varchar2 50 Primary key

Pwd Varchar2 50

fname Varchar2 50

lname Varchar2 50

email Varchar2 50

Phno Varchar2 50

Address Varchar2 200

City Varchar2 50

State Varchar2 50

Pin Varchar2 50

Bidding_Info(Information of bidding):


Bidderid Varchar2 50 Foreign key

Bamt Number

Itemid Number Foreign key

biddate Date

Status Number

31


dinfo_master(Seller information):

Category_Master(Information of item category):


Catid Number Primary key

Cat_name Varchar2 100

Feedback:


UName Varchar2 Primary key

Fback Varchar2 100

32


Uname Varchar2 50 Primary key

Pwd Varchar2 50

phone Varchar2 50

Email id Varchar2 50

Addr1 Varchar2 50

Addr2 Varchar2 50

City Varchar2 50

State Varchar2 50

Pin Varchar2 50

Country Varchar2 50


Item_Master(Details of items):


Itemid Number Primary key

Catid Number Foreign Key

Itemname Varchar2 50

Desc Varchar2 50

Summary Varchar2 50

Startprice Number

Incrprice Number

Stdate Date

Enddate Date

Seller Varchar2 50

Bidcnt Number

33


10.6 INPUT FORM FORMATS

Home Page:

34


Login page for both buyer and seller:

Registration home page:

35


Buyer Registration form:

Seller Registration form:

36


Seller Post items for Auction form:

Feedback by buyer form:

37


Buyer Bidding for item form:

Admin login:

38


10.7 REPORT FORMS:

Login report form(buyer):

Login report form(seller):

39


Buyer Registration form:

Seller Registration form:

40


Seller Main Page:

Auction Management:

41


Seller Post item form:

42


Update and Delete item page:

Edit Seller information:

43


View FeedBack:

Buyer Main page:

44


View Auction items:

Buyer Bidding Page:

45


Category of items:

46


Edit information:

47


Submit Feedback:

Closing Items:

48


Help Page:

Payment Page:

49


11. TEST PLANSLOGIN PAGE FOR SELLER AND BUYER:

INPUT OBTAINED OUTPUT

ACTUAL OUTPUT DESCRIPTION

1)user ID,password success success Login to the system should be matched with the username assigned to the seller along with the correct password

2a) User ID,password(incorrect)

2b) User ID,password (null,null)

Invalid user success Login to the system has failed due to wrong user name and password (or)both

DETAILS GIVEN BY SELLER:



1)Registration details success success If all mandatory field are filled

2)Registration details failure success If some mandatory field are empty

3)number of items, selected items …

success success If number of items is equal to selected items.

4) number of items, selected items..

failure success If number of items is not equal to selected items.

50


DETAILS GIVEN BY BUYER:



1)selection of item, amount assigned for bid …

success success If all the details are filled

2) selection of item failure success If amount is not assigned for the bid.

3)credit card number success success If card number is valid

4)credit card number failure success If Card number is not valid

51


12. Future Enhancement

It is not possible to develop a system that makes all the requirements of the user. User

requirements keep changing as the system is being used. Some of the future enhancements

that can be done to this system are:

As the technology emerges, it is possible to upgrade the system and can be adaptable to

desired environment

Because it is based on object-oriented design, any further changes can be easily

adaptable

Based on the future security issues, security can be improved using emerging

technologies

Buyers can be notified the end date of auction by sms or mail through the details he had

provided

Advance payment can be taken from buyer so as to make the auction more effective

This application may be extended for the combination of goods as a single bid also

52


13. CONCLUSION

This application software has been computed successfully and was also tested successfully by

taking “test cases”. It is user friendly, and has required options, which can be utilized by the

user to perform the desired operations.

The software is developed using Java as front end and Oracle as back end in Windows

environment. The goals that are achieved by the software are:

Instant access.

Improved productivity.

Optimum utilization of resources.

Efficient management of records.

Simplification of the operations.

Less processing time and getting required information.

User friendly, Portable and flexible for further enhancement.

53


14. Bibliography

1. Herbert Schildt ,The Complete Reference,Tata McGrw-Hill(2002) Java 2, 5 th Edition ,

Publishing Company Ltd.

2. George Koch, ORACLE,Tata McGrw-Hill (1997),Kevin Lone,The Complete Reference

Publishing Company Ltd,3rd Edition.

3. Ivan Bayross, SQL, PL/SQL, BPB Publications ( 2002)The Programming Language Of Oracle,

2nd Edition .

4. James A. O’Brien ,Management Information, Irwin/McGrw-Hil( 1999),Systems. 4th Edition.

15. REFERENCEShttp://www.w3schools.com

http://www.javabeginner.com

http://www.jsptut.com

http://programmingtutorials.com

http://geekmantra.com

http://www.freewebschools.com

http://www.javaworld.com

http://www.j2ee.masslight.com

http://www.littletutorials.com

http://www.java2s.com

54

http://www.java2s.com/

http://www.littletutorials.com/

http://www.j2ee.masslight.com/

http://www.javaworld.com/

http://www.freewebschools.com/

http://geekmantra.com/

http://programmingtutorials.com/

http://www.jsptut.com/

http://www.javabeginner.com/

http://www.w3schools.com/

ANNEXURE-1(SAMPLE CODE):Seller.jsp<%@page import="java.io.*" %><%@page import="java.util.*" %><%@page import="java.sql.*" %><%@page import="javax.naming.*" %><%@page import="java.rmi.*" %>

<BODY bgColor=#a3d881 leftMargin=0 topMargin=0 MARGINHEIGHT=0 MARGINWIDTH=0> <DIV id=Layer1 style='Z-INDEX: 1; LEFT: 410px; WIDTH: 328px; POSITION: absolute; TOP: 65px; HEIGHT: 35px'> <FORM name=form1 action='search.jsp' method=post ><INPUT name=sstring> <select size="1" name="category">

<option value="Select">Select Category</option><option value="Car">Car</option><option value="Truck">Truck</option><option value="Jeep">Jeep</option><option value="Tractor">Tractor</option><option value="Lorry">Lorry</option><option value="Auto4">Auto(4 Seater)</option><option value="Auto7">Auto(7 Seater)</option></select> <INPUT type=submit value=Go >

</FORM></DIV> <TABLE cellSpacing=0 cellPadding=0 width=781 border=0> <TBODY> <TR> <TD width=340 rowSpan=5><IMG height=100 alt='' src='./auto1.JPG' width=340></TD> <TD colSpan=2 rowSpan=3><IMG height=69 alt='' src='./name-copy_02.gif' width=81></TD> <TD colSpan=12><IMG height=39 alt='' src='./name-copy_03.gif' width=359></TD> <TD width=20><IMG height=39 alt='' src='./spacer.gif' width=1></TD></TR> <TR> <TD width=51><A href='./home.htm'><IMG height=12 alt='' src='./name-copy_04.gif' width=51 border=0></A></TD> <TD width=4><IMG height=12 alt='' src='./name-copy_05.gif' width=4></TD> <TD width=55><A href='./login.htm'><IMG height=12 alt='' src='./name-copy_06.gif' width=55 border=0></A></TD> <TD width=4><IMG height=12 alt='' src='./name-copy_07.gif' width=4></TD> <TD width=65><A href='./registration.htm'><IMG height=12 alt='' src='./name-copy_08.gif' width=65 border=0></A></TD> <TD width=7><IMG height=12 alt='' src='./name-copy_09.gif' width=7></TD> <TD width=40><A href='./sell.htm'><IMG height=12 alt='' src='./name-copy_10.gif' width=40 border=0></A></TD> <TD width=5><IMG height=12 alt='' src='./name-copy_11.gif' width=5></TD> <TD width=46><A href='./help.htm'><IMG height=12 alt='' src='./name-copy_12.gif' width=46 border=0></A></TD> <TD width=6><IMG height=12 alt='' src='./name-copy_13.gif' width=6></TD> <TD width=64><IMG height=12 alt='' src='./name-copy_14.gif' width=64></TD>

55


<TD width=12><IMG height=12 alt='' src='./name-copy_15.gif' width=12></TD> <TD><IMG height=12 alt='' src='./spacer.gif' width=1></TD></TR> <TR> <TD colSpan=12 rowSpan=3><IMG height=49 alt='' src='./name-copy_16.gif' width=359></TD> <TD><IMG height=18 alt='' src='./spacer.gif' width=1></TD></TR> <TR> <TD width=60><IMG height=16 alt='' src='./name-copy_17.gif' width=60></TD> <TD width=21 rowSpan=2><IMG height=31 alt='' src='./name-copy_18.gif' width=21></TD> <TD><IMG height=16 alt='' src='./spacer.gif' width=1></TD></TR> <TR> <TD><IMG height=15 alt='' src='./name-copy_19.gif' width=60></TD> <TD><IMG height=15 alt='' src='./spacer.gif' width=1></TD></TR></TBODY></TABLE><br><br>

<%!Connection con; Statement st; ResultSet rs;String seller="",pwd="",itemname="",catname="",desc="",summary="";int startprice=0,incrprice=0,acDays=0;%><%seller=request.getParameter("seller");pwd=request.getParameter("password");itemname=request.getParameter("itemname");catname=request.getParameter("vehtype");desc=request.getParameter("description");summary=request.getParameter("summary");startprice=Integer.parseInt(request.getParameter("startprice"));incrprice=Integer.parseInt(request.getParameter("incrprice"));acDays=Integer.parseInt(request.getParameter("auctiondays"));Class.forName("oracle.jdbc.driver.OracleDriver");con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","auction","auction");st=con.createStatement();rs=st.executeQuery("select pwd from dinfo_master where uname='"+seller+"'");boolean bol=rs.next(); if(bol==true){

String password=rs.getString(1);if(password.equals(pwd)){

session.setAttribute("seller",request.getParameter("seller")); session.setAttribute("password",request.getParameter("password")); PreparedStatement ps1=con.prepareStatement("select catid from category_master where cat_name like ?");

ps1.setString(1,catname); ResultSet rs=ps1.executeQuery(); String catid="";

if(rs.next()) catid=rs.getString(1);

char cword=catid.charAt(0);String ss2="select max(itemid) from item_master where itemid like

'"+cword+"%' ";PreparedStatement ps2=con.prepareStatement(ss2);

56


ResultSet rs2=ps2.executeQuery();rs2.next();String temp="";int titemid=0;

temp=""+rs2.getString(1); if(temp.equals("null"))

titemid=0;elsetitemid=Integer.parseInt(temp.substring(1));String itemid="";titemid++;itemid=""+(char)cword+"000"+titemid;String sss="insert into item_master

values('"+itemid+"','"+catid+"','"+itemname+"','"+desc+"','"+summary+"',"+startprice+","+incrprice+",to_date(sysdate),to_date(sysdate+"+acDays+"),'"+seller+"',0) ";

int i=st.executeUpdate(sss); out.println("<CENTER><FONT FACE=\"Comic Sans Ms, Times, Arial\" COLOR=\"#B179B9\" SIZE=\"5\">");

out.println("<b> U have Sucessfully posted u r item to Automotive online</b><br>"); out.println("</FONT>");

out.println("<br><center><FONT FACE=\"Comic Sans Ms\" SIZE=\'3\'>u r item id is: "+itemid); out.println("</FONT>");

rs.close();ps1.close();rs2.close();ps2.close();con.close();

}else{

out.println("<br><br>wrong password");}

}else{ out.println("<CENTER><FONT FACE=\"Comic Sans Ms, Times, Arial\" COLOR=\"#B179B9\" SIZE=\"5\">");

out.println("<b> User name does not exist</b><br>"); out.println("</FONT>");}

%>

57


ANNEXURE-2(Sample Reports):

58


59

smu_mca final year project_complementary auction system

Documents