How to insert large data into database using one insert query

[sandeepsai39]

hi,iam working with JDBC . I face a sitution like this,

Statement stmt=con.createStatement();
-------
for(int i=0;i<1000;i++)
{
stmt.executeUpdate("insert into Sample.sampletable(col1,col2,col3) values(value1i,value2i,value3i)";
);
-----
}
-----
'con' is Connection object,I am not inserting same values each time for three columns that means value1,value2,value3 changes with each iteration.

This code takes numerous amount of time ,because 1000 times
"stmt.executeUpdate(query)" should communicate with database.

Now I want a alternative for above code in such a way that all values should be inserted with a insertion query that executes only once.
please help me.

[emceenugget]

if you're using mysql as your database, i recommend using a load data file. i don't know if other databases have an equivalent.

MySQL :: MySQL 5.1 Reference Manual :: 12.2.6 LOAD DATA INFILE Syntax

[sandeepsai39]

thank u,but iam iam not inserting data from my any external file.
For example i am inserting data from a jtabel of 1000 rows.I am getting the values from jtable and then i am inserting into database

[emceenugget]

you can always create the file from data you have...