For DML (Data Manipulation Language) statements like update, insert, delete we use the method executeUpdate.
For select statement we use executeQuery which returns a ResultSet instance.
posted 9 years ago
Sort of yes.
There are times and ways you could use execute() instead, but for beginners (and for most of general purpose code), that's the way to do it.
Beginners should also start with using PreparedStatement, instead of Statement. Many people have the idea that Statement is easier, and therefore should be learned first, but Statement has all sorts of problems and really shouldn't be used much at all...