Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What are the advantages and limitations of JDBC PreparedStatement?
Following are the advantages of the prepared statement:
By avoiding multiple compilation and execution of statements, prepared statements perform faster.
Using prepared statements, we can insert values to advanced datatypes such as BLOB, CLOB, OBJECT easily with the help of the setter methods provided by the PreparedStatement interface.
By providing setter method to set values prepared statement avoids the use of quotes and other special characters with in the query, and thereby it escapes the SQL injection attacks
Following are the limitations of prepared statements:
Since a PreparedStatement object represents only one SQL statement at a time, we can execute only one statement by one prepared statement object.
To prevent injection attacks it does not allow more than one value to a place holder.
2K+ Views
