Execute MySQL query multiple times with one button click

Question

HI everyone I was wondering if there is a specific way how you can execute multiple INSERT queries with minimum code so I don't repeat the INSERT procedure every time.

For example I'm doing a workout feature for a program and the way it works is a user can select 3 exercises for each muscle group and than I'm having a table in my database where I want to store what the user have selected.

I want to execute all of the inserts by clicking just one button.

Here you can see screenshot of my program for your illustration.

https://i.sstatic.net/GYBny.jpg

Use addBatch & executeBatch commands for executing multiple SQL statment. Good Example — Suzon
– Suzon, Commented Apr 2, 2014 at 17:12
Thanks, I will take a look at this as well and than decide whether I should use this or a loop like rrirower suggested. — user3058242
– user3058242, Commented Apr 2, 2014 at 17:14

Guy Bouallet · Accepted Answer · 2014-04-02 17:12:57Z

1

If you are using JDBC, you should check the addBatch method. Here is a good tutorial for efficient inserts: http://viralpatel.net/blogs/batch-insert-in-java-jdbc/

I would recommend the SQL injection safe mechanism.

answered Apr 2, 2014 at 17:12

Guy Bouallet

2,12512 silver badges16 bronze badges

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

1 Comment

user3058242 Over a year ago

Yes I think the addBatch method is just what I needed, thank you for the nice tutorial

rrirower · Accepted Answer · 2014-04-02 16:59:46Z

0

Depending on how you structure your code, you should be able to construct a loop that collects the necessary data and dynamically creates the sql insert statement. In your example, the loop would execute three times, each time just changing the values of the columns to be inserted.

answered Apr 2, 2014 at 16:59

rrirower

4,5904 gold badges32 silver badges52 bronze badges

2 Comments

user3058242 Over a year ago

Can you just explain a little more what do you mean by "dynamically creates the sql insert statement"

rrirower Over a year ago

You can use prepared statements to accomplish that.

Collectives™ on Stack Overflow

Execute MySQL query multiple times with one button click

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related