Did you try searching on web this first hit on
web both have different purpose and this is written on asktom
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.
PreparedStatements or CallableStatements 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.
about the maximum number of queries there is no practicle limit
Shailesh
[ June 19, 2006: Message edited by: Shailesh Chandra ]