Use nested List in Flex server-side SQL (Ibatis)

The Iterate label of Ibatis can be used to traverse every element of the List cyclically to form an SQL file dynamically. But how can I use Iterate to traverse a nested List, after a lot of experiments, I finally found this method. The Code is as follows:

1. <Iterate Property="CsvData">
2. Insert into $ dbname $. K_XXX (CD, KNO, MSNO, data_no
3. <Iterate Property="EntryMsItem" Close=")">
4. , $ EntryMsItem [] $
5. </Iterate>
6. SELECT # Cd #, # kno #, # msNo #, ZEROIFNULL (MAX (DATA_NO) + 1
7. <Iterate Property="CsvData []" >
8. , # CsvData []. [] #
9. </Iterate>
10. FROM $ dbname $. K_XXX
11. WHERECD= # Cd #
12. ANDKNO= # Kno #
13. ANDMSNO= # MsNo #
14. ;
15. </Iterate>

In the above Code, csvData is a nested List, that is, its content is still a List,

The important points of Iterate traversal methods are as follows:

1. <Iterate Property="CsvData []" >
2. , # CsvData []. [] #
3. </Iterate>

CsvData [] indicates an element of the List, while # csvData []. [] # indicates an element of the List.

In this way, a List object with two layers can be traversed.