How to insert large data into database using one insert query
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.