sqlite 數(shù)據(jù) 格式轉(zhuǎn)化

    sqlite3 * db = [Database openDB];
    sqlite3_stmt * stmt = nil
   int result = sqlite3_prepare_v2(db, "select * from Student", -1, &stmt, NULL);
    NSMutableArray * studentArray = [NSMutableArray array];
    if (result == SQLITE_OK)
    {
      while (sqlite3_step(stmt) == SQLITE_ROW) //存在一行數(shù)據(jù)
        {
        

從數(shù)據(jù)庫中取出NSInteger 格式的數(shù)據(jù)

            int ID = sqlite3_column_int(stmt, 0);
           

從數(shù)據(jù)庫中取出 text  格式的數(shù)據(jù)      

   const unsigned char * name =  sqlite3_column_text(stmt, 1);
    const unsigned char * gender = sqlite3_column_text(stmt, 2);
           
            
 blob 類型的獲取
          

1. 獲取長度
            int length = sqlite3_column_bytes(stmt, 4);
          

2. 獲取數(shù)據(jù)
            const void * photo = sqlite3_column_blob(stmt, 4);
            
           

3.轉(zhuǎn)換成NSData
            
            NSData * photoData = [NSData dataWithBytes:photo length:length];
         

4.轉(zhuǎn)成 UIImage
            
            UIImage * p_w_picpath =  [UIImage p_w_picpathWithData:photoData];
            
            
           

封裝Student模型
            Student * student = [[Student alloc]init];
            student.ID = ID;
            student.name = [NSString stringWithUTF8String:(const char*)name];
            student.age = age;
            student.gender = [NSString stringWithUTF8String:(const char *)gender];
            student.photo = p_w_picpath;
            
           

添加到數(shù)組中
            [studentArray addObject:student];
        }
    }