Model View Controller Film Site Project

Week 8 Homework for SkillDistillery

By: Gabriel Inzurriaga and Neal Savant

Overview

Building upon the week 7 project, we have developed a Spring application that updates the database from a website. A user can find film by ID and keyword. The user can also create a film. Deletions and Updates to the list of films are only possible on user created films. This preserves the integrity of the database.

Concepts

Prevent SQL Injection using PreparedStatement and bind variables.

Java:
	Interfaces
	Object Encapsulation
	Return Types
	Parameters
	Method Override
	ArrayList

Spring: Bean objects Annotation driven Model View Controller object Command Objects

SQL:
	SELECT
	JOIN ON
	LIKE
	? : bind variable
	Pattern Matching

JDBC:
	Object-Relational Mapping
	PreparedStatement
	ResultSet
	Driver

Technologies Used

Java

SQL

JDBC

Gradle

Spring

CSS

HTML

Bootstrap

Unix Terminal

git

Demo

Display a Film

Insert a new a Film to the Database

Delete or Update a Film