CS 122B Fall 2024 Project

Team "Firewalker and Icebreaker"

Name	UCInetID
Jacob Moy	jamoy
Joonhyuk Song	joonhys

Contributions

Project 1

Jacob Moy	Joonhyuk Song
Movie List Frontend & Backend	Single Star Frontend & Backend
Single Movie Frontend & Backend	API Debugging
Page Styling (CSS)	AWS Instantiation & Management
Demonstration Filming

Project 2

Jacob Moy	Joonhyuk Song
Login Page	Browse on Main Page
Search on Main Page	Movie Page Sorting/Pagination
Searching Database Functions	Single Movie & Star Page Sorting
Browsing Functionality	Single Star Page Sorting
Styling	Shopping Cart & Payment Page
Demonstration	Shopping Cart & Payment Functionality

Project 3

Jacob Moy	Joonhyuk Song
Add Dashboard	Replace Statements with Prepared Statements
Add HTTPS	XML Parsing
Add reCaptcha	Add Encryption to Passwords
Add Procedures	Performance Tuning

Project 4

Jacob Moy	Joonhyuk Song
Autocomplete Suggestions	Full-text Search
Fuzzy Search (EC)	JDBC Connection Pooling
MySQL Master-Slave Replication	Scaling

Demo Videos

• Project 1 Demo
• Project 2 Demo
• Project 3 Demo
• Project 4 Demo
• Project 5 Demo

Usage of LIKE Predicate:

For most searches, I used: LIKE '%{termHere}%'.

Otherwise, for title browsing, I used: LIKE '{firstLetterHere}%'

Project 3 Performance Tuning

The two strategies that we employ to make our XML parsing a little bit faster are:

• Threads: Threads allow us to simultaneously parse and insert our data into the database as we parse. We believe that the overall running time would be O(n/m), where n is the length of the file and m is the number of threads currently spun up.
• Batch Inserting: We only insert after parsing 1000 lines of XML per thread, so the 1000 inserts only happens every so often to minimize the amount of time going down to the I/O layer. Estimating the time complexity, as such, is a little difficult, but I believe we are making a significant impact on the running time as such.

Project 4

• Connection Pooling

  • Include the filename/path of all code/configuration files in GitHub of using JDBC Connection Pooling.

    • WebContent/META-INF/context.xml

  • Explain how Connection Pooling is utilized in the Fabflix code.

    • The Connection Pooling allows Tomcat to keep a pool of connections that can be provided to servlets on demand rather than creating new ones, which costs additional overhead. PreparedStatements are also cached so that the same instance of PreparedStatements can be returned, so that we do not have to prepare the same statement over and over when connections are returned to the pool.

  • Explain how Connection Pooling works with two backend SQL.

    • Each tomcat server maintains its own pool of connections to the their respective SQLs, where changes and requests are propagated between Master/Slave as necessary, thus benefitting from both load balancing and cutting back on overhead costs of connection creation.

• Master Slave

  • Include the filename/path of all code/configuration files in GitHub of routing queries to Master/Slave SQL.

    • etc/mysql/mysql.conf.d/mysqld.cnf

  • How read/write requests were routed to Master/Slave SQL?

    • Read/write requests were automatically routed to Master/Slave dependent on the type of request. Writes were routed to Master, reads routed to local database, whether on Master or Slave.

• Fuzzy Search

  • include a brief explanation of the design and the implementation of your fuzzy search.

    • The fuzzy search leverages the Levenshtein distance library from the Flamingo library. It gets a few titles with a distance of <= 2, and unions them with the regular LIKE results returned.

Project 5 JMeter Analysis

Specs	Throughput/min
3 Workers + 2 PhilmPhreaks Pods	1,150.477
4 Workers + 3 PhilmPhreaks Pods	1,300.191

Data Report

Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Improperly formatted year!	Movie with no year!	
Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Movie with no id!	Movie Details - Movie id: null, Movie name: Becky Sharp, Movie director: Mamoulian, Movie year: 1935, Genres (0):.	
Movie with no id!	Movie Details - Movie id: null, Movie name: Rings on her Fingers, Movie director: Mamoulian, Movie year: 1942, Genres (0):.	Movie with no id!	Movie Details - Movie id: null, Movie name: Summer Holiday, Movie director: Mamoulian, Movie year: 1948, Genres (1): Musc.	Movie with no id!	Movie Details - Movie id: null, Movie name: Silk Stockings, Movie director: Mamoulian, Movie year: 1957, Genres (1): Musc.	Movie with no id!	Movie Details - Movie id: null, Movie name: Menschen am Sonntag, Movie director: R.Siodmak, Movie year: 1929, Genres (1): Docu.	Movie with no id!	Movie Details - Movie id: null, Movie name: Pi\`eges, Movie director: R.Siodmak, Movie year: 1939, Genres (0):.	Movie with no id!	Movie Details - Movie id: null, Movie name: Son of Dracula, Movie director: R.Siodmak, Movie year: 1943, Genres (1): Horr.	Movie with no id!	Movie Details - Movie id: null, Movie name: Cobra Woman, Movie director: R.Siodmak, Movie year: 1944, Genres (1): Camp.	Movie with no id!	Movie Details - Movie id: null, Movie name: Phantom Lady, Movie director: R.Siodmak, Movie year: 1944, Genres (1): Noir.	Movie with no id!	Movie Details - Movie id: null, Movie name: The Spiral Staircase, Movie director: R.Siodmak, Movie year: 1945, Genres (1): Susp.	Movie with no id!	Movie Details - Movie id: null, Movie name: Nocturne, Movie director: R.Siodmak, Movie year: 1946, Genres (1): Myst.	
Movie with no id!	Movie Details - Movie id: null, Movie name: The Killers, Movie director: R.Siodmak, Movie year: 1946, Genres (2): Susp Noir.	Movie with no id!	Movie Details - Movie id: null, Movie name: The Dark Mirror, Movie director: R.Siodmak, Movie year: 1946, Genres (0):.	Movie with no id!	Movie Details - Movie id: null, Movie name: Criss Cross, Movie director: R.Siodmak, Movie year: 1948, Genres (1): Dram.	Movie with no id!	Movie Details - Movie id: null, Movie name: The Spiral Staircase, Movie director: R.Siodmak, Movie year: 1948, Genres (0):.	Movie with no id!	Movie Details - Movie id: null, Movie name: The Crimson Pirate, Movie director: R.Siodmak, Movie year: 1952, Genres (1): Actn.	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Improperly formatted year!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Movie with no year!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Improperly formatted year!	Movie with no year!	
Improperly formatted year!	Movie with no year!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Improperly formatted year!	Movie with no year!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Improperly formatted year!	Movie with no year!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	
Improperly formatted year!	Invalid genre!	Movie with no year!	
Improperly formatted year!	Movie with no year!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Improperly formatted year!	Movie with no year!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Improperly formatted year!	Movie with no year!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Improperly formatted year!	Movie with no year!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	
Improperly formatted year!	Invalid genre!	Movie with no year!	
Invalid genre!	Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	Invalid genre!	
Improperly formatted year!	Invalid genre!	Invalid genre!	Invalid genre!	Movie with no year!	
Invalid genre!	Invalid genre!	
Improperly formatted year!	Movie with no year!	Invalid genre!	
Improperly formatted year!	Improperly formatted year!	Movie with no year!	Movie with no year!	
Improperly formatted year!	Movie with no year!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Improperly formatted year!	Movie with no year!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Invalid genre!	
Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Improperly formatted year!	Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	
Attempted to insert actor into movie that doesn't exist!	

Usage of PreparedStatements

Files:

• EmployeeDashboardServlet.java
• EmployeeLoginServlet.java
• InsertMovieServlet.java
• InsertStarServlet.java
• LoginServlet.java
• MovieListServlet.java
• PaymentServlet.java
• ShoppingCartServlet.java
• SingleMovieServlet.java
• SingleStarServlet.java