aspose file tools*
The moose likes JDBC and the fly likes Statement vs PreparedStatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Statement vs PreparedStatement" Watch "Statement vs PreparedStatement" New topic
Author

Statement vs PreparedStatement

Santosh Kumar
Greenhorn

Joined: Jan 03, 2002
Posts: 28
Hi All,
Can any one list me all the differences between Statement and PreparedStatement.I want to know also one more thing like how PreparedStatement is better than Statement when there is time to save memory space of the database.
thank you
regards
santosh kumar
san19@indiatimes.com


Santoh Kumar<br /> India<br />SCJP 1.4 <br />SCWCD 1.4
John Carnell
Author
Ranch Hand

Joined: Sep 27, 2002
Posts: 71
Originally posted by sare san:
Hi All,
Can any one list me all the differences between Statement and PreparedStatement.I want to know also one more thing like how PreparedStatement is better than Statement when there is time to save memory space of the database.
thank you
regards
santosh kumar
san19@indiatimes.com

Hi Santosh,
A preparedstatement pre-parses and pre-compiles the SQL statement so that when the SQL code is executed multiple times it will not have to be re-parsed each time.
This is more efficient then a Statement object because a statement object will cause the database to re-parse the SQL statement every time a command is executed. This saves times because parsing SQL code does take time on the database side. This might not seem like a lot of a overhead in a low transaction-volume application, but in a high transaction environment, this can represent a significant amount of overhead as the same SQL statements have to be parsed over and over again.
In addition, the PreparedStatement class allows you to "parameterize" your SQL statement so that you do not have to build the SQL statement parameters by "hand." Each parameter is represented by a question mark and can be replaced by calling the appropriate set() method on the PreparedStatement class.
In a Statement object the parameters have to be built as part of the SQL statement.
I hope that helps.
Thanks,
John Carnell


John Carnell<br />Principal Architect<br /> <br />Netchange, LLC<br />1161 HillCrest Heights<br />Green Bay, WI 54313<br /> <br />john.carnell@netchange.us<br /> <br /> <br />Author of <a href="http://www.amazon.com/exec/obidos/ASIN/159059228X/ref=jranch-20" target="_blank" rel="nofollow">Pro Jakarta Struts, Second Edition</a>
Santosh Kumar
Greenhorn

Joined: Jan 03, 2002
Posts: 28
Thank you for prompt reply.
Sir I have again one Question?
Whatever you said i understood but for Statement I have still confusion like whether it compiles and parses everytime for every request or only parses everytime.
And one more question whether on parsing the statement it takes any memory space on the database side or not.
regards
santosh kumar
san19@indiatimes.com
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Statement vs PreparedStatement
 
Similar Threads
Performance using Statement and Prepared Statement
Performance with preparedStatement.
PreparedStatement Vs Statement
Statement v/s PreparedStatement
ejb environment