SQLITE3 运用

SQLITE3 使用

一：USING SQLITE3

1.add libsqlite3.dylib library to your project

2.#import "sqlite3.h"

3.declare a variable of type sqlite3 ,like this "sqlite3 *db"

4.openDB

-(void) getAllRowsFromTableNamed: (NSString *) tableName {//---retrieve rows---NSString *qsql = @“SELECT * FROM CONTACTS”;sqlite3_stmt *statement;if (sqlite3_prepare_v2( db, [qsql UTF8String], -1, &statement, nil) ==SQLITE_OK) {while (sqlite3_step(statement) == SQLITE_ROW) {char *field1 = (char *) sqlite3_column_text(statement, 0);NSString *field1Str = [[NSString alloc] initWithUTF8String: field1];char *field2 = (char *) sqlite3_column_text(statement, 1);NSString *field2Str = [[NSString alloc] initWithUTF8String: field2];NSString *str = [[NSString alloc] initWithFormat:@“%@ - %@“,field1Str, field2Str];NSLog(str);[field1Str release];[field2Str release];[str release];}//---deletes the compiled statement from memory---sqlite3_finalize(statement);}}

?

?

?

?

?

?

?

?

?

?