Statement Interface

Once you have a live Connection, the next thing you do is send SQL through it. Statement is the simplest way to do that. It takes a SQL string, ships it to the database, and gives you back either a result set or a row count. This lesson covers how to create a Statement, the three execute methods and when each one fits, how to read back auto-generated keys, how to send several statements in a single batch, and the security hole that string-concatenated SQL opens up.