sqlite的简单示例
保存- (void)save {
if () {
return;
}
User *new_user = [ init];
new_user.name = txt1.text;
new_user.age = txt2.text;
new_user.sex = txt3.text;
if (sqlite3_open([ UTF8String],&database) != SQLITE_OK) {
sqlite3_close(database);
NSAssert(0, @"open database faild!");
}
char *erroMsg;
NSString *createSQL = ;
if (sqlite3_exec(database, , NULL, NULL, &erroMsg) != SQLITE_OK) {
sqlite3_close(database);
NSAssert1(0, @"create table %@ faild", TableName);
NSAssert1(0, @"the error is %s", erroMsg);
}
NSString *insertUser = ;
NSLog(@"%@",insertUser);
if (sqlite3_exec(database, , NULL, NULL, &erroMsg) != SQLITE_OK) {
NSAssert1(0, @"Error updating tables: %s", erroMsg);
}
txt1.text = @"";
txt2.text = @"";
txt3.text = @"";
}
查询
- (User *)getUser:(int)id {
if (sqlite3_open([ UTF8String],&database) != SQLITE_OK) {
sqlite3_close(database);
NSAssert(0, @"open database faild!");
return nil;
}
User *user = [ init];
NSString *countSQL = ;
sqlite3_stmt *statement;
if (sqlite3_prepare_v2(database, , -1, &statement, nil) == SQLITE_OK) {
while (sqlite3_step(statement) == SQLITE_ROW) {
user.id = ;
user.name = ;
user.age = ;
user.sex = ;
}
sqlite3_finalize(statement);
return user;
}
return nil;
}
具体的使用示例请参考附件。
页:
[1]