/message-board

Message board web app built with Java Servlet, JSP and MySQL.

Primary LanguageJavaMIT LicenseMIT

message-board

Message board web app built with Java Servlet and JSP.

Setup

Java

This project is developed using Java 8 update 261 jre-8u261

  1. Download the Java Runtime Environment (JRE) from Oracle for your operating system

Tomcat

Tomcat is needed to run the Java servlets and launch the web app locally. This project uses Tomcat 9.0

  1. Go to Tomcat's download page
  2. For macOS, download the tar.gz, unzip it and save the folder somewhere (you will need it later)

IntelliJ IDEA

  1. Clone this repo using HTTPS, SSH, GitHub Desktop or any other method

  2. Open IntelliJ IDEA, select Open Project and choose ~/message-board/pom.xml. When the dialog box appears select Open as project. This will make IntelliJ automatically build the project for you.

  3. On IntelliJ's topbar, go to Run -> Edit Configurations

Add Tomcat Server and set the following options:

  • Application Server: Find the path of the Tomcat server you previously downloaded. If do not have Tomcat installed, read the section above so you are able to finish your setup
  • URL: http://localhost:8080/message_board_war/

Before you hit apply, above this button there will be a message in red saying No artifacts marked for deployment. Click on Fix and select message-board:war

  1. Run the new Tomcat configuration and navigate away!

Properties

  1. Go to ~/src/main/webapp/WEB-INF/classes/example-MessageBoard_en_US.properties
  2. Copy the contents of this file, create another file in the same directory called MessageBoard_en_US.properties, and paste the keys you coped in this new file
  3. Fill the values for the keys

Database

This project uses MySQL as its database management system.

To have a local instance of the database, do the following steps:

  1. Install the pre-requisites:

  1. Open your terminal and log into your MySQL command-line client: mysql -u root -p

  2. Run schema found in db/schema.sql

  3. Replace DB_PASSWORD in src/main/java/db/DBConnection.java with the password you set for your MySQL Server in the installation process

For more help or information, check out this resource with SQL demos.

Team Information

Member @GitHub
Dina Sadirmekova @dinasadir
Miguel Jimenez @mjimenez98
Nicolas Zito @z1to
Saima Syed @CoBatool