Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and the fly likes Statement for more then one insert quries Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Statement for more then one insert quries" Watch "Statement for more then one insert quries" New topic

Statement for more then one insert quries

ehsan ulhaq dar

Joined: Jun 04, 2008
Posts: 17
In my bean class i execute more then one insert quries. Whether i use only one statement object to execute these quries or i used separate statement object for separate qury? What is sun recommendation?
Jan Cumps

Joined: Dec 20, 2006
Posts: 2497

Hi Ehsan,

You can reuse the object.
Regards, Jan

OCUP UML fundamental and ITIL foundation
youtube channel
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704

Statements can be re-used although unless the queries are strongly related its often a better design to close and finish your first statement and open a new statement elsewhere. In other words, don't keep a single statement for the entire JDBC application, as your likely to have issues with opening/closing it if an exception occurs.

My Blog: Down Home Country Coding with Scott Selikoff
I agree. Here's the link:
subject: Statement for more then one insert quries