A prepared statement is an SQL
statement that is precompiled by the database. Through precompilation,
prepared statements improve the performance of SQL commands that are
executed multiple times (given that the database supports prepared
statements). Once compiled, prepared statements can be customized prior
to each execution by altering predefined SQL parameters.
PreparedStatement pstmt = conn.prepareStatement("UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?"); pstmt.setBigDecimal(1, 153833.00); pstmt.setInt(2, 110592);
Here:
conn
is an instance of the Connection class and "?"
represents parameters.These parameters must be specified before execution.
No comments:
Post a Comment