What I've done so far:

1. Installed MySQL server

2. Installed JDBC for MySQL

3. Installed Apache Tomcat Server

4. Created MySQL database named "search_db" and created table with some data
   This is temporary, we will need to populate with real data
   • mysql> CREATE DATABASE search_db;

   • mysql> CREATE TABLE Search_Database(URL TEXT, PELENNOR INTEGER, ROHIRRIM INTEGER, ORCS INTEGER);

   • mysql>INSERT INTO Search_Database VALUES ('http://www.pelennor.net', 1, 1, 1);

   • mysql>INSERT INTO Search_Database VALUES ('http://www.glyphweb.com/arda/p/pelennor.html', 3, 0, 0);

   • mysql>INSERT INTO Search_Database VALUES ('http://homepages.pavilion.co.uk/users/rdowning/gloss/lrohan.htm', 3, 1, 6);

   • mysql>INSERT INTO Search_Database VALUES ('http://www.metrowargamers.com/mt-archives/games/battle_of_pelennor_fields_part_3.php', 2, 9, 8);

   • mysql>SELECT * FROM Search_Database;
     

     +-------------------------------------------------------------------------------
     -------+----------+----------+------+
     | URL  | PELENNOR | ROHIRRIM | ORCS |
     +-------------------------------------------------------------------------------
     -------+----------+----------+------+
     | http://www.pelennor.net
            |        1 |        1 |    1 |
     | http://www.glyphweb.com/arda/p/pelennor.html
            |        3 |        0 |    0 |
     | http://homepages.pavilion.co.uk/users/rdowning/gloss/lrohan.htm
            |        3 |        1 |    6 |
     | http://www.metrowargamers.com/mt-archives/games/battle_of_pelennor_fields_part
      _3.php |        2 |        9 |    8 |
     +-------------------------------------------------------------------------------
     -------+----------+----------+------+
     4 rows in set (0.03 sec)
        

5. Setup main search page & jsps.
   • Save these files in C:\jakarta-tomcat-5.0.19\webapps\searchengine
        index.html   searchengine.jsp

   • Save this file in C:\jakarta-tomcat-5.0.19\webapps\searchengine\WEB-INF
        web.xml

   • Save these files in C:\jakarta-tomcat-5.0.19\webapps\searchengine\WEB-INF\classes\searchengine
        SearchResultBean.java   DataSourceBean.java
     Don't forget to COMPILE the *.java files!

   • The program takes in as input a URL and checks to see if it is a valid URL. If it is, it will save it to a text file named inputpage.txt. (Stored in C:\jakarta-tomcat-5.0.19\bin) It then connects to the database and extracts the pages (urls) there.
     It does NOT at this point parse the input document and search for similar pages or sort the database.