
CS536 J2EE/EJB TERM PROJECT : Auction House

Instructor: Mr. Tom Xian

team member : Huang, Hao (2860A)  huangh99@yahoo.com
              Shen, Enyi (2845A)

Date: Apr. 18, 2003


How to run:
-----------

open d:\bea\wlserver6.1\config\mydomain\startWebLogic.cmd
add a deploy directory of d:\proj in classpath 

unzip proj.zip under d:\

go to d:\proj

d:\proj> setEnv                     (set Env. for EJB)

d:\proj> setexpenv                  (set Env. for validation)

d:\proj> build_item                 (build AuctionItemEJB.jar)

d:\proj> build_regist               (build RegistrationEJB.jar)

d:\proj> build_seller               (build SellerEJB.jar)

d:\proj> build_bidder               (build BidderEJB.jar)

d:\proj> build_ui                   (build Auction.war)


cteate 3 tables in Oracle on npu25.npu.edu:

CREATE TABLE SALE_ITEM(
ITEMID 	    NUMBER(38),
SUMMARY     VARCHAR2(50),
DESCRIPTION VARCHAR2(500),
ITEMNUMBER  NUMBER(10),
STARTDATE   DATE,
CLOSEDATE   DATE,
STARTPRICE  NUMBER(38,2),
INCREMENTAL NUMBER(38,2),
SELLER      VARCHAR2(40),
HIGHESTBID  NUMBER(38,2),
HIGHBIDDER  VARCHAR2(40),
BIDCOUNT    NUMBER(38),
SOLDSTATUS  NUMBER(10),
NOTE        VARCHAR2(20)
);

CREATE TABLE REGISTRATION(
USERID      VARCHAR2(40),
PASSWORD    VARCHAR2(40),
NAME        VARCHAR2(40),
EMAIL       VARCHAR2(80),
CREDITCARD  VARCHAR2(20),
BALANCE     NUMBER(38,2),
ADDRESS     VARCHAR2(60),
PHONE       VARCHAR2(30),
NOTE        VARCHAR2(20)
);

CREATE TABLE BIDS(
BIDID    NUMBER PRIMARY KEY,
BIDDER   VARCHAR2(40),
ITEMID   NUMBER(38),
BID      NUMBER(38,2),
BIDDATE  DATE,
COUNTER  NUMBER(38),
NOTE     VARCHAR2(20)
);


Start WebLogic Server

ConnectionPool : OraclePool
     JNDI Name : Auction

other weblogic env. refor to d:\proj\Env\config.xml


Run the "Auction House" :

http://localhost:7001/Auction


