how to insert multiple rows in a database using java code

[emmas4impact]

Hello guys,

I am working on a project that deals with a store. but here is my problem i am having problem inserting multiple record into the database instead my code is summing it up.

Can anyone give me an idea on how to insert multiple record into a database.

Thanks.

[java_programmer]

Following SQL allows to insert multiple records at a time in database -

INSERT ALL
   INTO mytable (column1, column2, column3) VALUES ('val1.1', 'val1.2', 'val1.3')
   INTO mytable (column1, column2, column3) VALUES ('val2.1', 'val2.2', 'val2.3')
   INTO mytable (column1, column2, column3) VALUES ('val3.1', 'val3.2', 'val3.3')
SELECT * FROM dual;

So in java, create a statement as above and then call the execute() method.
I didn't try it, but hope, it will work. Also let us know the result whether it works or not.

[~s.o.s~]

> Can anyone give me an idea on how to insert multiple record into a database.

Search for "Batch insert JDBC". Links which might interest you:
http://www.java2s.com/Code/Java/Database-SQL-JDBC/BatchUpdateInsert.htm
http://www.jguru.com/faq/view.jsp?EID=5079

[emmas4impact]

Thanks i really appreciate it i will try it and let you know the latest update thanks once more