一个完整的SQLite的应用DEMO

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

sqlite3_close(database);

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

}

char*erroMsg;

NSString*createSQL = [NSStringstringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(ROW INTEGER PRIMARY KEY,NAME TEXT,AGE TEXT,SEX TEXT)"
sqlite3_exec(database,[createSQLNULL,&erroMsg) !=SQLITE_OK) {

sqlite3_close(database);

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

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

}

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

NSLog(@"%@",insertUser);

sqlite3_exec(database,[insertUserSQLITE_OK)

{

NSAssert1(

}

User *user = [[Useralloc]init];

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

sqlite3_stmt*statement;

sqlite3_prepare_v2(database,[countSQL1,&statement,162);">nil) ==SQLITE_OK) {

while(sqlite3_step(statement)==SQLITE_ROW) {

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

name@"%s"1 user.age =[2 user.sex = [3)];

}

sqlite3_finalize(statement);

returnuser;

}

希望对大家有用：SQLiteDEMO

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!