Statement vs. PreparedStatement

Statement vs. PreparedStatement A standard Statement is used to create a Java representation of a literal SQL statement and execute it on the database. A PreparedStatement is a pre-compiled  statement. This means that when the PreparedStatement is executed, the RDBMS can just run the PreparedStatement SQL statement without having to compile it first. PreparedStatement offers better execution performance than Statement. Statement has to verify its metadata against the database every time. While a prepared statementh as to verify its metadata against the database only once. If you want to execute the SQL statement once go for Statement. If you want to execute a single SQL statement multiple number of times, then go for PreparedStatement. PreparedStatement objects can be reused with passing different values to the queries.