一个完整的SQLite的应用DEMO

原文地址：一个完整的SQLite的应用DEMO 作者：殷昭

自己写了一个iphone应用sqlite的DEMO;

涉及到添加，查询和事务管理

关键代码

 

if (sqlite3_open([[self databasePath] UTF8String],&database) != SQLITE_OK) {

 

sqlite3_close(database);

 

NSAssert(0,@"open database faild!");

 

}

char *erroMsg;

NSString *createSQL = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(ROW INTEGER PRIMARY KEY,NAME TEXT,AGE TEXT,SEX TEXT)",TableName];

if (sqlite3_exec(database, [createSQL UTF8String], NULL, NULL, &erroMsg) != SQLITE_OK) {

 

sqlite3_close(database);

 

NSAssert1(0,@"create table %@ faild",TableName);

 

NSAssert1(0,@"the error is %s",erroMsg);

 

}

NSString *insertUser = [NSString stringWithFormat:@"INSERT INTO %@(NAME,AGE,SEX) VALUES('%@','%@','%@')",TableName,new_user.name,new_user.age,new_user.sex];

NSLog(@"%@",insertUser);

if (sqlite3_exec (database, [insertUser UTF8String], NULL, NULL, &erroMsg) != SQLITE_OK)

{

 

NSAssert1(0, @"Error updating tables: %s", erroMsg);

 

}

User *user = [[User alloc] init];

NSString *countSQL = [NSString stringWithFormat:@"SELECT ROW,NAME,AGE,SEX FROM UserTable WHERE ROW = %i",id];

sqlite3_stmt *statement;

if (sqlite3_prepare_v2(database, [countSQL UTF8String], -1, &statement, nil) == SQLITE_OK) {

 

 

 

while (sqlite3_step(statement)==SQLITE_ROW) {

user.id = [NSString stringWithFormat:@"%d",sqlite3_column_int(statement,0)];

user.name = [NSString stringWithFormat:@"%s",sqlite3_column_text(statement,1)];

user.age =[NSString stringWithFormat:@"%s",sqlite3_column_text(statement,2)];

user.sex = [NSString stringWithFormat:@"%s",sqlite3_column_text(statement,3)];

}

 

sqlite3_finalize(statement);

 

return user;

}

 

希望对大家有用：SQLiteDEMO