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

关键代码

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

@H_301_37@

sqlite3_close(database);

@H_301_37@

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

@H_301_37@

}

@H_301_37@

@H_301_37@

char*erroMsg;

@H_301_37@

NSString*createsql = [NSStringstringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(ROW INTEGER PRIMARY KEY,NAME TEXT,AGE TEXT,SEX TEXT)"301_37@
sqlite3_exec(database,[createsqlNULL,&erroMsg) !=sqlITE_OK) {

@H_301_37@

sqlite3_close(database);

@H_301_37@

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

@H_301_37@

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

@H_301_37@

}

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

@H_301_37@

NSLog(@"%@",insertUser);

@H_301_37@
sqlite3_exec(database,[insertUsersqlITE_OK)

@H_301_37@

{

@H_301_37@

NSAssert1(301_37@

}

@H_301_37@

User *user = [[Useralloc]init];

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

@H_301_37@
sqlite3_stmt*statement;

@H_301_37@
sqlite3_prepare_v2(database,[countsql1,&statement,162);">nil) ==sqlITE_OK) {

@H_301_37@

@H_301_37@

@H_301_37@

while(sqlite3_step(statement)==sqlITE_ROW) {

@H_301_37@

@H_301_37@

@H_301_37@

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

@H_301_37@

@H_301_37@

@H_301_37@

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

@H_301_37@

}

@H_301_37@

sqlite3_finalize(statement);

@H_301_37@

returnuser;

}

希望对大家有用：sqliteDEMO