Question

虽然“制片声明”可以做一切事情, 即DDL、DDL相关询问的性能优于“声明”。

Answer 1

因为有些询问没有任何参数,所以编写并随后执行声明实际上可能比直接执行声明效率低。在这种情况下,使用单一声明(并可能重新使用)也更容易读和直截了当。

http://docs.oracle.com/javase/6/docs/api/java/sql/Connection. html#create statement%28%29" rel=“nofollow” >the javadoc 说:

SQL statements without parameters are normally executed using Statement objects. If the same SQL statement is executed many times, it may be more efficient to use a PreparedStatement object.

友情链接