The Online Product Catalog consists of a GUI that displays product lines, product sublines and individual product information. Each one of these is data queried from a mySQL database using prepared SQL statements with a JDBC connection.
A login interface exists for customers so they can access their account information online. The GUI was designed to be highly usable in terms of logging in and creating a new account. Links are provided to allow customers to retrieve lost/forgoten login information.
Product data is stored in a mySQL database using indexed tables. Each product line, product subline and product is associated with a primary key so each item can be queried uniquely. The search results GUI was developed with usability in mind by listing out the search results outcome. This includes number of results found, alphabetical listing of results, hyperlinks to results and a keyword modification link to perform a new search. The search functionality exists in a simplified textbox persistant on all web pages and also in an advanced search web page.
