Lecture 10: Using SQL from Java

12 February 2009

SQL as a high-level declarative programming language. Domain-specific languages. Automated creation and manipulation of SQL. Example: SkyServer. Description of HTML injection and SQL injection. Accessing databases from programming languages: ODBC, JDBC, sample Java code for SQL queries. Demotion of SQL queries from structured programming to flat strings.

The lecture described handling SQL queries from Java. If your favourite programming language / framework does it differently (better?) then post details in the comments.

Read the rest of this entry »