multiple insert in mysql database

Question

I've a table Categories which has Skins and which has Images

Categories : id, Name
Skin :  id, name
CategorySkins : CategoryID, SkinID
Images : id, name
SkinImages: Skinid, ImageID

my question is to save a single Category instance with a few Skins and those Skins with a few Images. I've tried to build insert string dynamically, but I don't like this approach.

P.S. Is it possible to pass data like this: Catogory with list of skins and with list of images. as list to mysql procedure? Or simple is it possible to pass array as a parameter to procedure? Any suggestions about other way of solving this problem?

I want to insert this data together and I don't know how to pass it to mysql procedure. — JiboOne
– JiboOne, Commented Dec 5, 2012 at 20:49
Why are you skipping thinking about using stored procedures when you have yet to even define the basic means for inserting this data in to the database? You really need to think about how you are going to map that data structure to your database and what individual queries would need to be done to perform the entire data insert before you even worry about whether you need a stored procedure for this. — Mike Brant
– Mike Brant, Commented Dec 5, 2012 at 20:53

JiboOne · Accepted Answer · 2012-12-13 09:36:31Z

3

I've used Statement for this issue.

stmnt = conn.createStatement();
conn.setAutoCommit(false);

stmnt.addBatch("insert statement for categories");
stmnt.addBatch("insert statement for skins");
stmnt.addBatch("insert statement for CategorySkins");
...

stmnt.executeBatch();
conn.commit();

answered Dec 13, 2012 at 9:36

JiboOne

1,5584 gold badges25 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

multiple insert in mysql database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related