Results 1 to 4 of 4

Thread: insert records

  1. 01-02-2010, 09:12 AM #1
    rudravaram
    rudravaram is offline Member
    Join Date
    Jan 2010
    Posts
    1
    Rep Power
    0

    Default insert records

    Hi every body ,
    am having small doubt how can we send 10000 records at atime to database plzz send the code if possible , i need it very urgently
    Reply With Quote Reply With Quote
  2. 01-02-2010, 12:04 PM #2
    Fubarable's Avatar
    Fubarable
    Fubarable is offline Moderator
    Join Date
    Jun 2008
    Posts
    19,252
    Blog Entries
    1
    Rep Power
    24

    Default

    Ah, if it's extremely urgent, I must be too late to help you. Sorry.
    Reply With Quote Reply With Quote
  3. 01-02-2010, 08:02 PM #3
    Steve11235's Avatar
    Steve11235
    Steve11235 is offline Senior Member
    Join Date
    Dec 2008
    Posts
    1,046
    Rep Power
    6

    Default

    Create a PreparedStatement and use addBatch(), executeBatch().

    Fubarable, still a bit grumpy after New Year's Eve?
    Reply With Quote Reply With Quote
  4. 01-03-2010, 05:54 PM #4
    raqman
    raqman is offline Member
    Join Date
    Sep 2009
    Posts
    37
    Rep Power
    0

    Default

    Hi.
    In my opinion, you can refer to the url below:
    SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL « Journey to SQL Authority with Pinal Dave
    Regards,
    raqman.
    RAQ Report: free Java reporting tool.
    Reply With Quote Reply With Quote
« Difference between JDBC Statement and PreparedStatement | netbeans database problem »

Similar Threads

  1. Insert text records from text file into a DB
    By nicedad in forum JDBC
    Replies: 8
    Last Post: 11-06-2009, 06:52 AM
  2. How to insert large data into database using one insert query
    By sandeepsai39 in forum New To Java
    Replies: 3
    Last Post: 02-28-2009, 09:17 AM
  3. how to fetch 20,000 records from excel sheet & insert into access database using Java
    By santosh_tamse in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 02-22-2009, 10:24 AM
  4. How to delete the records
    By kiran kumar in forum Java Servlet
    Replies: 6
    Last Post: 11-09-2008, 01:16 PM
  5. Getting number of records (JDBC 2.0)
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-11-2008, 08:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules