smu_mca final year project_complementary auction system
Post on 07-May-2017
217 Views
Preview:
TRANSCRIPT
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
Complementary Auction System
This is to certify that the project report entitled
“COMPLEMENTARY AUCTION SYSTEM”
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
Complementary Auction System
EXAMINER’S CERTIFICATION
The project report of
HHH
“COMPLEMENTARY AUCTION SYSTEM”
Is approved and is acceptable in quality and form
Internal Examiner External Examiners
DECLARATION
3
Complementary Auction System
I here by declare that the project report entitled
“COMPLEMENTARY AUCTION SYSTEM”
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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):
Column Name Data Type Size Constraint Type
Bidderid Varchar2 50 Foreign key
Bamt Number
Itemid Number Foreign key
biddate Date
Status Number
31
Complementary Auction System
dinfo_master(Seller information):
Category_Master(Information of item category):
Column Name Data Type Size Constraint Type
Catid Number Primary key
Cat_name Varchar2 100
Feedback:
Column Name Data Type Size Constraint Type
UName Varchar2 Primary key
Fback Varchar2 100
32
Column Name Data Type Size Constraint Type
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
Complementary Auction System
Item_Master(Details of items):
Column Name Data Type Size Constraint Type
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
Complementary Auction System
10.6 INPUT FORM FORMATS
Home Page:
34
Complementary Auction System
Login page for both buyer and seller:
Registration home page:
35
Complementary Auction System
Buyer Registration form:
Seller Registration form:
36
Complementary Auction System
Seller Post items for Auction form:
Feedback by buyer form:
37
Complementary Auction System
Buyer Bidding for item form:
Admin login:
38
Complementary Auction System
10.7 REPORT FORMS:
Login report form(buyer):
Login report form(seller):
39
Complementary Auction System
Buyer Registration form:
Seller Registration form:
40
Complementary Auction System
Seller Main Page:
Auction Management:
41
Complementary Auction System
Seller Post item form:
42
Complementary Auction System
Update and Delete item page:
Edit Seller information:
43
Complementary Auction System
View FeedBack:
Buyer Main page:
44
Complementary Auction System
View Auction items:
Buyer Bidding Page:
45
Complementary Auction System
Category of items:
46
Complementary Auction System
Edit information:
47
Complementary Auction System
Submit Feedback:
Closing Items:
48
Complementary Auction System
Help Page:
Payment Page:
49
Complementary Auction System
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:
INPUT OBTAINED OUTPUT
ACTUAL OUTPUT DESCRIPTION
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
Complementary Auction System
DETAILS GIVEN BY BUYER:
INPUT OBTAINED OUTPUT
ACTUAL OUTPUT DESCRIPTION
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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
Complementary Auction System
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><!-- ImageReady Slices (Untitled-1) --> <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><!-- End ImageReady Slices --> <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
Complementary Auction System
<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
Complementary Auction System
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
Complementary Auction System
ANNEXURE-2(Sample Reports):
58
Complementary Auction System
59
top related