Full Stack · Java · SQL
SJSU Burning Questions
A full-stack Q&A forum built to replace the terrible app SJSU students actually use.
JavaJSPSQL
TomcatHTML/CSS/JSMySQLTeam of 3
Demonstration Video
Concept & Inspiration
My group for a relational databases course at San Jose State University needed a project idea to learn SQL, JSP, and Tomcat. Our idea: a forum application to replace the terrible app our school currently uses for students to ask faculty and other students questions. Think Quora, but built for a university context.
Team
Team of three, each coding different aspects of the project: Lexin Ma, Nimra Naveed, and myself.
Design Goals & Challenges
Goals
- Post and answer questions
- Create an account, sign in, and log out
- Moderate questions with proper privileges
- Proper database design for questions and user data
- Multiple pages organized by question category
- Keyword search bar
- Live question fetching and updating from the database
- Unique user IDs to differentiate posters and repliers
Challenges
- Learning how to use JSP files with Java to query the database
- Page design that looked professional
- Proper user privilege levels and error checking
Tools & Technologies
- Java
- HTML / CSS / JavaScript
- JSP
- Tomcat Server
- SQL
- MySQL Workbench 8.0 CE