A study in using e-commerce to facilitate the sales of Rhodes Memorabilia

Farisai Mabvudza

Uma Rudraraju

&

George Wells

Greg Foster

&

Presented By… Supervised By…

Benefits of E-commerce

Easy accessibility

24 hour access to shopping from home

Convenience

Secure online credit payment options

Always up to date

Easier maintenance

Delivery of goods to your doorstep!

The Problem

Alumni in the dark

Postage costs and delays

Limited shopping hours

The Solution

An Online Web Store- Housing a central repository of memorabilia for sale- Where customers can view and purchase products- Via secure online payment methods

Affordable and simple to maintain

Dynamic

Inspired by

Goals

Investigation into the development of an affordable, small to medium scaled e-commerce system using Java technologies

A practical system: R.U.M – Rhodes University Memorabilia

Technologies Used

HTML, CSS

Javascript

Java Server Pages and JavaBeans

JavaMail

Apache Tomcat Web Server

Java Database Connectivity

Microsoft Access

JSP’s AdvantageJavaBean Name:

OrderBean.javaProperties:

SName cardType saCost sCountrysAdd1 expiryDate neighbourCost payment sAdd2 cardNumber otherCost ordered sCity ccvsError cardName delivery sPostcode cardNumberLeft cardNumberRight

Recommended Scope:session

Example Usage:<jsp:useBean id = "order" class = "OrderBean" scope = "session"/>

  <jsp:setProperty name = "order" property = "*"/>

Diagram showing the OrderBean Property Sheet used in RUM

RUM Architecture

Client Tier (Thin Client)Web TierBusiness TierData Tier

Development Problems

Cross browser compatibility

Memorabilia out of stock at Rhodes

Tomcat server configuration Problems

Bugs inherent in Tomcat web server

Microsoft Access annoyances

Development Benefits

Reusability afforded by fully object-oriented JavaBean classes

Good knowledge of - Java Technologies - Web design

Teamwork - What the real world needs!

Tour of RUM

Future Extensions

Automatic credit card validation with bank

Wishlist

Automatic stock control

Enforcing customer relationships via marketing and advertising

Questions

RUM !!!