|
Java™
by example!
|
|
|
How do I use a PreparedStatement?
If you need to execute a certain SQL statement a number of times, you can have it optimized by the underlying DBMS by using a PreparedStatement. A PreparedStatement is called a precompiled SQL statement, but can still be parametrized. In other words, it can accept certain input parameters.
So:
will have the same result as:
The latter one does take somewhat more time to set up (precompilation), but if you need to insert a lot of rows, it is beneficial cause you can reuse insertStmt and change its parameters.
executeUpdate returns the number of rows that were affected.
You can do the same thing for SELECT statements with executeQuery. It returns a ResultSet containing the rows that match your query.
If you need to clear the parameters that were set, invoke the method clearParameters.
Main.java:
Further Information
Author of answer: Joris Van den Bogaert
Comments to this answer are only viewable by members. Login or become a member!
|
|
|
|
|
In-house 
