This is an example of the Mid Valley auto database. This database stores and manages auto listings for a dealership. This is just an example so it only has a page that lists all of the current listings and has a form for adding new listings. The full application uploads and manages multiple images for each listing and has administrative features for updating and deleting. The database used for this application contains all of the tables necessary for managing auto listings for a dealership to put their inventory online. The application uses Java Server Pages and a PostgreSQL or MySQL database. Java form beans are used for handling data securely and AJAX is used for filling in the form with information from the database as the user selects different options on the form such as selecting Acura or BMW will bring up a listing of models to select. (Continue Reading)

The Secret Shopper application and database was designed for secret shoppers to post evaluations online so that reps and store owners could access site evaluations electronically. The application is written with PHP and SQL and uses a MySQL database. Access is restricted and secured using JavaScript and 128bit encryption algorithms. You can access a prototype version of this application by clicking on the image and entering guest for username and guest for password. The database is fairly complex for a small application like this. AJAX is used to fill in certain forms so people do not need to enter information to post evaluations. An image of the database logical model is included below. (Continue Reading)

Game Tagg was a group project where I worked with a team of three people. The purpose of the project was to create a social bookmarking website prototype for videogames. The application uses JSP to send data to and receive data from a Java program that makes and executes SQL statements to interact with a PostgreSQL database. The project was somewhat large for a basic prototype with over 35 pages and 11 database tables. The different pages used to auto redirect such as when clicking on user home and logging in previously it would automatically go back to user home. This functionality was removed because of web host issues, and registration and everything has been changed to be completely open so users can test out everything.   (Continue Reading)

Auto Search is a java based web application that uses Google Base to search for cars. It is a basic application that uses HTML and CSS for presentation and Java Server Pages (JSP) to send data to and receive data from a java application. The user enters a query and a java program takes the query, sends it to Google Base, and returns the results. The user interface then accesses the results and returns them ten at a time. (Continue Reading)