122B- PROJECT 1 + 2

Readme document for Derek Adlai Trujillo & Hoa Ta. Student IDs: 66456950 & 13506664

URL

Project 1 URL: https://youtu.be/JTTP5FPP6ew

Project 2 URL: https://youtu.be/69HNnC-mfoA

Project 3 URL: https://youtu.be/iCrWqTFTa_g

Substring Matching Design

When user enter to search form, we take the input and search based on the input they pass in. (case sensitive).

whereClause:

... where movies.title LIKE %aa%
... AND movies.director LIKE %aa%
AND stars.name LIKE %aa%
(should not support substring search)

Contributions

**Hoa Ta: ** Wrote movie list page, single movie page structure, link pages together, add Icons and css for files. Implement Login page, search page, filter, front end **Derek Adlai Trujillo: ** Fixed single movie page and star page, wrote and optimized SQL queries. Debugging SingleMovieServet and StarsServlet. Screen recorded and uploaded Project 1 Video to Youtube. Created AWS Instance. Implement shopping cart, payment page, pagination, prev/next button

Special Instructions

mysql -u mytestuser-p < create_table.sql altered to mysql -u mytestuser -p < createtable.sql since our sql file has a slightly different name. cp ./target/*.war /var/lib/tomcat10/webapps/ altered to sudo cp ./target/*.war /var/lib/tomcat10/webapps/ to bypass permission restrictions

Parsing Optimizations

• Implemented a 3 pool threader to execute multiple SQL queries at the same time
• Implemented parallelization to divide the data into smaller chunks

List filenames with Prepared Statements

• EmployeeLoginServlet.java
• GenresSearchServlet.java
• GenresServlet.java
• LoginServlet.java
• MetadataServlet.java
• MoviesServlet.java
• PaymentServlet.java
• SalesServlet.java
• SingleMovieServlet.java
• SingleStarsServlet.java
• UpdateCustomerSecurePassword.java
• UpdateSecurePassword.java