It's not a secret anymore!*
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 Spring in Action this week in the Spring 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: 2503

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: 3710

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
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Statement for more then one insert quries