Implement Guideline
- Install Apache Netbeans IDE 17 https://netbeans.apache.org/front/main/download/nb17/
- Install MySQL Workbench 8.0 CE https://dev.mysql.com/downloads/workbench/
- Install Apache Tomcat v9.0.69 https://tomcat.apache.org/download-90.cgi Extract the downloaded files to a location of your choice (e.g., C:).
- Install JDK 21 (if you use default jdk version of netbeans its maybe corrupted, so you better uninstall the default and install jdk 21) (https://drive.google.com/drive/folders/1ow05jdqS44_hJSd2tHYLK-q_mFW9ygfy?usp=drive_link)
- Open NetBeans. Go to the Services tab. Right-click on Servers and select Add Server. In the pop-up dialog, choose Apache Tomcat as the server type. Browse to locate your Tomcat server directory (e.g., C:\apache-tomcat-9.0.69). Set a username and password for the manager role (used when logging in to Tomcat via the browser). Click Finish.
- Test Your Tomcat Server: In the Services tab, expand the Servers section. Right-click on Apache Tomcat and click Start. View the logs in the Console tab. Open your web browser (e.g., Chrome) and visit localhost:8080 (the default port for Tomcat). You should see the Tomcat welcome page.
- Download the source code in Github.
- Download library/JAR file (database connector) for MySQL https://drive.google.com/file/d/17Wh6E0cQzG7EqgIOm2ZqsaDjv6OJsLn6/view?usp=sharing. Browse to locate the jar file (e.g., C:\mysql-connector)
- Import project in Netbeans
- Right click "Libraries" choose "Add JAR/Folder" then choose the file you are browsed on step 7. Right click "Libraries" one more time, choose "Add Library" then find and select "JSTL 1.2.1"
- Download database data (https://drive.google.com/drive/folders/1_3y_PVG2N7Go7jsKFCrZI05P3J0Mr1Vd?usp=drive_link). Extract all tables to MySQL workbench. Remember keep the same user data between MySQL and Netbeans (double check file /context/DBContext.java).
- Run project
Documentation: https://docs.google.com/document/d/1rC-IH61aLLHFXwplJB7C7hEE7_GeTVcAT8g-P9i1CRI/edit?usp=sharing