This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes where can we use prepared statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "where can we use prepared statement" Watch "where can we use prepared statement" New topic
Author

where can we use prepared statement

prakash narkodu
Greenhorn

Joined: May 23, 2003
Posts: 5
I haerd that Prepared Statements are precomiled ones , so they are not compiled everytime whereas with createStaement same is not the case. But once jsp program compiled then next time it will not compile so how does only prepared Statement is precompiled one ?

Please give suggestion where to use prepared statement and where to use statement
Thanking you
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1138
    
    1

Hi Prakash,
In case you haven't already read it, perhaps this article may be helpful:
http://www.onjava.com/pub/a/onjava/excerpt/oraclejdbc_19/index.html
Good Luck,
Avi.
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

I also like this article from TheServerSide: Why Prepared Statements are important and how to use them "properly"
Dave
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: where can we use prepared statement
 
jQuery in Action, 3rd edition