CS 374: Database Systems
James Madison University, Spring 2022

Mar 24: Intro to JDBC / SQL Injection

Lesson Outline

10 min HW5 Q&A
* Running flask and psycopg
* Working with Jinja templates
* commit, flash, redirect
25 min Lecture #1
JDBC Example
25 min Lecture #2
Hack Example
15 min Group Time
* Create webapp in git repo

Before Tuesday

  1. Textbook: Read PDBM 15.3.4--5 (8 pages).

  2. Homework: Finish HW5 (due Sunday).

  3. Project: Work on GP4 (automate GP3).