simple Web project to search games from a database.
- using Servlets, JSP, Java and MySQL
A user can login, register, search games and see their description
| Web Pages | Servlet/Java code | Model/Java code | View/JSP |
|---|---|---|---|
| Login | Login.java | LoginForm.java | login.jsp |
| Registration | Register.java | RegisterForm.java | register.jsp |
| Search | Search.java | SearchParse.java | search.java |
| Search Result | SearchResult.java | N/A | searchResult.jsp |
| Specials | specials.java | N/A | specials.jsp |
| Details | Details.java | N/A | Details.jsp |
The java file Database.java is using the .xml files to create a database called a1_soen387 and tables called gameData and user important: if the database is already created, you can't run this file again ( or you can update the code to make it work )
If you need to change the user and password to access your database, you need to change USER and PASSWORD static String in several files.
- line 86 and 87 in LoginForm.java
- line 225 and 226 in RegisterForm.java
Information is from the open source website GameDB API
each folder contain information for 5 games
- zelda
- fish
- mario
- miami
- myst
- rabbit
- red
- sky
- tokyo
- batman
- boy
- car
- creed
- diablo
In each folder there are 5 full descriptions and 5 artifacts description
Cheers!