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
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: 19544
    
  16

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
Rancher

Joined: Mar 28, 2008
Posts: 526
    
  23

Yes real words are preferable.

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


Tim Driven Development
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29261
    
140

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 ?
 
Similar Threads
Difficulty in Updating database
how to run code in netbeans
noob question about jdbc
preparestatment
MySQL / jdbc + Java Servlet