Originally posted by vgs lemu:
What are the names (and description) of the 4 JDBC drivers?
Paul has already answered
Originally posted by vgs lemu:
What are the types of statements (ex. PreparedStatement)?
There are three types of statements
Statement The use of a Statement in JDBC should be 100% localized to being used for DDL (ALTER, CREATE, GRANT, etc) as these are the only statement types that cannot accept BIND VARIABLES.
PreparedStatement PreparedStatements should be used for EVERY OTHER type of statement (DML, Queries). As these are the statement types that accept bind variables.
This is a fact, a rule, a law -- use prepared statements EVERYWHERE. Use
STATEMENTS almost no where.
CallableStatements This is used to call Stored Procedure ,functions etc.
Shailesh