실무 : 데이터를 넘기는 방법 - SQLite 이용...

sql이 사용하기 편하다 - 단점은 느리다 ㅡㅡ;

 

https://www.sqlite.org/download.html

1. SQLite 의 SQL 문은 대소문자 구분이 없다.

#import <sqlite3.h> sqlite3 *database; NSString *databaseName = @"audreyDev001.db";;;;;;;;;;;;;;;;;;; NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);;;;;;;;;;;;;;     NSString *documentsDir = [documentPaths objectAtIndex:0];;;;;;;;;;;;;;;;;;;;     NSString *databasePath = [documentsDir stringByAppendingPathComponent:databaseName];;;;;;;;;;;;     NSString *currentProgressString = @"";          if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {         NSString *query = @"select mId \         from table_user;";         const char *sqlStatement = [query cStringUsingEncoding:NSASCIIStringEncoding];         sqlite3_stmt *compiledStatement;         if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) {             // Loop through the results and add them to the feeds array             while(sqlite3_step(compiledStatement) == SQLITE_ROW) {                 currentProgressString = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 0)];                 break;             }         }         sqlite3_finalize(compiledStatement);;;;;;;;;;;;;;;;;;;;;;;;;;     }     sqlite3_close(database);;;;;;;;;;;;;;;;;;;;;;;;;;;;

DFCT_LIST*data=[[DFCT_LISTalloc]init]; data.id_mbil=sqlite3_column_int(compiledStatement,0); data.cd_dong=[NSStringstringWithUTF8String:(char*)sqlite3_column_text(compiledStatement,1)]; data.nohs=[NSStringstringWithUTF8String:(char*)sqlite3_column_text(compiledStatement,2)]; data.id_rgon=sqlite3_column_int(compiledStatement,13);

NSString *col = [NSString stringWithUTF8String:(char *)sqlite3_column_name(compiledStatement, i)];                     NSString *data = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, i)];

 

 

 

SELECT 

select user_id from audrey_user_id;

 

select count(a.myid) from mylist a;

 

 

나머지는 ... 다른 곳이 워낙 잘 나와있어서... 구글링 ㄱ