Search USA farmers markets in your area or in an area that you are travelling to. Optionally supply a range in order to narrow your search. This application makes use of pagination to allow the user to iterate forward or backwards through search results.
- Run
build_script.sql
locatdscripts
in order to construct the database. - Place the
mysql-connector-java-8.0.17.jar
file or whatever version you use withinCATALINA_HOME/lib
folder within Tomcat (e.g. Tomcat9/lib). - Run the script
load_database.cmd
located in thescripts
folder in order to load the database. - Copy the WAR file to
CATALINA_HOME/webapps
then copy all remaining files and put them into theROOT
folder within the aforementioned directory. This must be done so theJSP
file can access database credentials incredentials.txt
. - Put your SQL username and password into
credentials.txt
in the form USERNAME:PASSWORD. Also manually enter your username and password inLoader.java
where you see the strings "USERNAME" and "PASSWORD". - Start the Tomcat server.
- For port number 8090, paste
http://localhost:8090/markets/index.jsp
into your browser to run the application locally.
- OS: Windows 10
- Java: jdk1.8.0_191
- Tomcat Port: localhost:8090