aspose file tools*
The moose likes JDBC and the fly likes How to execute insert ,select and delete statemeents at once in JDBC ? 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 "How to execute insert ,select and delete statemeents at once in JDBC ?" Watch "How to execute insert ,select and delete statemeents at once in JDBC ?" New topic
Author

How to execute insert ,select and delete statemeents at once in JDBC ?

Raghavendra ReddyI
Greenhorn

Joined: Sep 10, 2012
Posts: 8
This is a code snippet





plzz suggest me the right coding
Thanks in advance
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19718
    
  20

Raghavendra ReddyI wrote:plzz suggest me the right coding

Please UseRealWords.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Tim Cooke
Bartender

Joined: Mar 28, 2008
Posts: 1128
    
  59

Yes real words are preferable.

But also, "right coding" for what? I don't see a question.


Tim Driven Development
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30753
    
156

The question is in the subject. (Try not to do that, as you noticed - people miss it)

For the last two, you can use executeBatch() to do them in one trip to the database. The first query doesn't go together - you do a query and ignore the results?


[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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to execute insert ,select and delete statemeents at once in JDBC ?