Using prepared statements
In this recipe, you will learn how to use a prepared statement—a statement template that can be stored in the database and executed efficiently with different input values.
Getting ready
An object of PreparedStatement
—a subinterface of Statement
—can be precompiled and stored in the database and then used to efficiently execute the SQL statement multiple times for different input values. Similar to an object of Statement
 (created by the createStatement()
method), it can be created by the prepareStatement()
method of the same Connection
object. Â
The same SQL statement that was used to generate Statement
can be used to generate PreparedStatement
too. In fact, it is a good idea to consider using PrepdaredStatement
 for any SQL statement that is called multiple times, because it performs better than Statement
. To do this, all we need to change are these two lines in the sample code of the previous section:
try (Statement st = conn.createStatement()) { boolean res = st.execute...