[問題] 讀取NSMutableArray特定位置的值、修正輸出順序消失
已先使用FMDB讀取sqlite的某一table J的值
程式：
NSMutableArray* JData = [NSMutableArray arrayWithCapacity: 0];
FMResultSet *rs = [db executeQuery: @"SELECT uid, uidY, uidH, uidT, uidO from J"];
while ([rs next]) {
int uid = [rs intForColumn: @"uid"];
int uidY = [rs intForColumn: @"uidY"];
int uidH = [rs intForColumn: @"uidH"];
int uidT = [rs intForColumn: @"uidT"];
int uidO = [rs intForColumn: @"uidO"];
[JData addObject: [NSDictionary dictionaryWithObjectsAndKeys:
[NSNumber numberWithInt: uid], @"uid",
[NSNumber numberWithInt: uidY], @"uidY",
[NSNumber numberWithInt: uidH], @"uidH",
[NSNumber numberWithInt: uidT], @"uidT",
[NSNumber numberWithInt: uidO], @"uidO",
nil]];
}
NSLog(@"%@", JData[2]);
結果：
uid = 3;
uidH = 0;
uidO = 3;
uidT = 0;
uidY = 98;
程式設計的目的：
讀取table J的值轉成二維陣列
以便直接讀取特定位置的值進行運算
請問：
1. 輸出結果順序與讀取順序不同，應如何修正？
讀取sqlite的table J欄位順序：uid, uidY, uidH, uidT, uidO
但顯示讀取後的欄位值順序卻是：uid, uidH, uidO, uidT, uidY
2. 如何讀取特定位置的值？
資料庫就像二維陣列
雖然可以讀取某列的值（如：JData[2]列出uid, uidH, uidO, uidT, uidY）
但要如何讀取某列某行的值（如：JData[2][2]）
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 60.245.65.133
※ 文章網址: https://www.ptt.cc/bbs/MacDev/M.1456629808.A.99A.html
推
02/28 11:28, , 1F
02/28 11:28, 1F
→
02/28 11:28, , 2F
02/28 11:28, 2F
推
02/28 13:25, , 3F
02/28 13:25, 3F
→
02/28 13:26, , 4F
02/28 13:26, 4F
→
02/28 13:27, , 5F
02/28 13:27, 5F
→
02/28 23:20, , 6F
02/28 23:20, 6F