Use the Statement object for time-critical or dynamic SQL statements
When it comes to executing a SQL statement, you have two choices: you can use a PreparedStatement object or a Statement object. A PreparedStatement parses and compiles a SQL statement once, no matter how many times you reuse it. When you use a Statement, each time a SQL statement is executed, it is again parsed and compiled. This might lead you to think that using a PreparedStatement would be faster than using a Statement; however, my tests show this is not the case on the client side. So, for time-critical SQL operations, unless you are going to batch SQL statements, you should consider using Statements.
http://www.onjava.com/pub/a/onjava/2001/12/19/oraclejdbc.html
Anybody has your voices for/against the points above ? is this statement testable?
Thanks.