Results 1 to 4 of 4

Thread: insert records

  1. #1
    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

  2. #2
    Fubarable's Avatar
    Fubarable is offline Moderator
    Join Date
    Jun 2008
    Posts
    19,316
    Blog Entries
    1
    Rep Power
    25

    Default

    Ah, if it's extremely urgent, I must be too late to help you. Sorry.

  3. #3
    Steve11235's Avatar
    Steve11235 is offline Senior Member
    Join Date
    Dec 2008
    Posts
    1,046
    Rep Power
    7

    Default

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

    Fubarable, still a bit grumpy after New Year's Eve?

  4. #4
    raqman is offline Member
    Join Date
    Sep 2009
    Posts
    37
    Rep Power
    0

Similar Threads

  1. Replies: 8
    Last Post: 11-06-2009, 06:52 AM
  2. 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

Posting Permissions

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