Five-table joint check SQL and check box additions and deletions

This is a five-table joint check, if this is not obvious, then add the speech

This makes it obvious that the

This delivery time and place, are a one-to-many, then this menu is many to many, in fact, for the veteran, there is no big deal, but for the novice, I hope it can be a little help, this is written with MyBatis

First of all, we give the SQL to contribute, perhaps some ugly, but this is also to write their own essays do not matter

Select A.*,b.fname from
(Select A.*,c.aname from (select A.*,b.name tname from
T_order A,t_time b where a.time_id=b.id) a,t_address c where a.address_id =
C.aid
Limit #{index},#{limit}
) A
Left Join
(select Order_id,group_concat (f.name) fname from T_order_foot a LEFT join
T_foot F
On a.foot_id = F.id GROUP by order_id) b on a.id = b.order_id ORDER BY
a.ID ASC

That's it, too.

This is the five tables are linked, the rest of how to show how to show on it, for the time being do not watch

So the following is the Add method, the added drop-down is not a table

Write it out in the service

This is the method in the controller.

Delete to delete two times, is to delete the main table, and then delete the multi-table (multi-table is a many-to-many relationship table)

When invoking the FA, the ID of the main table is passed directly to the

So when you modify the echo, because he is multi-table, the ID of a primary table may have multiple foot table IDs so, to traverse

In front of the reception also need to cycle

This can be echoed, of course, do not forget to write in the entity class to traverse the IDs, I give the definition of the string format

Then the formal modification of the method is much simpler, the main table for normal modification can be, but, many tables you have to delete and then add, you have to modify the main table of the illusion, the main table here is the main role of the check box,

I am a novice, I This essay is also for myself to see, of course, can help and I like the small white, it is also my honor, hope that the great God saw not it, thank you!

Five-table joint check SQL and check box additions and deletions