I want to know which is a better approach of inserting multiple rows in database:
for( int x = 0; x < y.length; x++ ) { insertRowsIntoDatabase( valuesHere ); }My data is consist about 8 columns and 50 rows.
A better way would be to do a batch insert, instead of inserting rows 1 by 1.
for (String query : queries) {
statement.addBatch(query);
}
statement.executeBatch();
You can use bulk insert
save all values in a txt file and use.
BULK INSERT STUDENT
FROM ‘D:\STUDENTS_LIST.txt’
WITH ( FIELDTERMINATOR = ‘,’, ROWTERMINATOR = ‘\n’ )
Always use one query when you can. This has multiple advantages:
Anyway, 8 columns and 50 rows is very fast and easy to handle for any DBMS, but your data may grow later, so you want to use the best approach.
yes you can write only one query to insert all values:
String query="insert into table1 (First,Last) values";
for(; ;)
{
query=query+"('Fred','Smith'),";
}
-----You can write your database insertion code here----
Or you can use addBatch() and executeBatch(); method also......
Consider using a single Prepared Statement Batch, with multiple data sets as batch.
(Note: Not all JDBC drivers may support this and exactly follow the spec.)
