大家帮帮忙啊,搞不定了,急!!!!

BorlandXBuilder 2004-06-16 02:50:05

我的表里的记录是这样子的：

+--------------------------+
| GID | MID | USED |
+--------------------------+
|1 | 1 | 0 |
+--------------------------+
|1 | 2 | 1 |
+--------------------------+
|1 | 3 | 1 |
+--------------------------+
|1 | 4 | 1 |
+--------------------------+
|2 | 1 | 1 |
+--------------------------+
|2 | 2 | 0 |
+--------------------------+
|2 | 3 | 1 |
+--------------------------+
|2 | 4 | 1 |
+--------------------------+
|2 | 5 | 0 |
+--------------------------+
|3 | 1 | 1 |
+--------------------------+
|3 | 2 | 1 |
+--------------------------+
|3 | 3 | 1 |
+--------------------------+
|3 | 4 | 1 |
+--------------------------+
|3 | 5 | 1 |
+--------------------------+
|3 | 6 | 1 |
+--------------------------+
|3 | 7 | 0 |
+--------------------------+
|4 | 1 | 1 |
+--------------------------+
|4 | 2 | 1 |
+--------------------------+
|4 | 3 | 1 |
+--------------------------+
|4 | 5 | 1 |
+--------------------------+
|5 | 1 | 1 |
+--------------------------+
|5 | 2 | 1 |
+--------------------------+

用SQL筛选：SELECT * FROM MACHINE WHERE USED=1
+------------------------+
| GID | MID | USED |
+------------------------+
|1 | 2 | 1 |
+------------------------+
|1 | 3 | 1 |
+------------------------+
|1 | 4 | 1 |
+------------------------+
|2 | 1 | 1 |
+------------------------+
|2 | 3 | 1 |
+------------------------+
|2 | 4 | 1 |
+------------------------+
|3 | 1 | 1 |
+------------------------+
|3 | 2 | 1 |
+------------------------+
|3 | 3 | 1 |
+------------------------+
|3 | 4 | 1 |
+------------------------+
|3 | 5 | 1 |
+------------------------+
|3 | 6 | 1 |
+------------------------+
|4 | 1 | 1 |
+------------------------+
|4 | 2 | 1 |
+------------------------+
|4 | 3 | 1 |
+------------------------+
|4 | 5 | 1 |
+------------------------+
|5 | 1 | 1 |
+------------------------+
|5 | 2 | 1 |
+------------------------+
现在我要做的是把上面筛选出来的记录写到一个二维数组Machine[256][2]里，但是在写的时候顺序要改变，GID代表的是机组ID，MID代表的是机器的ID，数组的顺序是这个样子的：先取出第一个GID的第一个MID，然后取出第二个GID的第一个MID，然后是第三个GID的第一个MID，一直到第五个GID的第一个MID，接下来取出第一个机组的第二个MID,第二个机组的第二个MID，第三个机组的第二个MID.............上面的数据排序好是这个样子的：
+------------------------+
| GID | MID | USED |
+------------------------+
|1 | 2 | 1 |
+------------------------+
|2 | 1 | 1 |
+------------------------+
|3 | 1 | 1 |
+------------------------+
|4 | 1 | 1 |
+------------------------+
|5 | 1 | 1 |
+------------------------+
|1 | 3 | 1 |
+------------------------+
|2 | 3 | 1 |
+------------------------+
|3 | 2 | 1 |
+------------------------+
|4 | 2 | 1 |
+------------------------+
|5 | 2 | 1 |
+------------------------+
|1 | 4 | 1 |
+------------------------+
|2 | 4 | 1 |
+------------------------+
|3 | 3 | 1 |
+------------------------+
|4 | 3 | 1 |
+------------------------+
|3 | 4 | 1 |
+------------------------+
|4 | 5 | 1 |
+------------------------+
|3 | 5 | 1 |
+------------------------+
|3 | 6 | 1 |
+------------------------+
请问如何实现，我感觉是比较烦的

...全文