| Author |
static vs dynamic sql
|
tarik el berrak
Greenhorn
Joined: Oct 06, 2006
Posts: 29
|
|
Hi all,
What's the difference between static and dynamic sql ? which must be used and why ?
Thanks
|
SCJP 1.5<br />New Target (SCWCD 5)
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26496
|
|
Tarik,
IBM has a good comparison. From a Java perspective, it is good to use PreparedStatements to handle your binding variables so you don't have to worry about things like date formats and SQL injection.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
 |
|
|
subject: static vs dynamic sql
|
|
|
0
