Is there any advantage to using prepared statements in Java for DML in the following
scenario:
get a connection, prepare a statement, substitute the variable value, execute, close the
statement - repeat this process over and over.
Don’t you need to not close so that you don’t have to re-prepare the statement
in order to gain any performance advantage?