What are the advantages of using PreparedStatement over Statement?

devquora
devquora

Posted On: Feb 22, 2018

 

There are some advantages of the PreparedStatement over Statement which are given below: -

  • The PreparedStatement's performance is far better than the Statement as it compiled once and then perform only on the runtime which is not like Statement which compiled every time at the time of running the code.
  • Another important benefit of PreparedStatement is that it is able to execute the Parameterized query while Statement is able to run static queries.
  • The query that is used in PreparedStatement is believed to similar every time. By this, a database is able to reuse the previous access plan while the Statement inlines the parameter into the string, Because of it, the query does not seem the same every time which obstruct the reuse of cache.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    JDBC interview questions

    What is the full form of JDBC and what is its purpose?

    JDBC stands for Java Database connectivity which is an application that helps in connection for the programming of Java language...

    JDBC interview questions

    What do you understand by JDBC driver and explain its types?

    JDBC drivers are software that enables the Java application to connect with the database..