7. --SQLite 专属的条件查找

//查询单个学生

-(Student *)selectStudentWithName:(NSString *)name

{

Student *student = nil;

//伴随指针

sqlite3_stmt *stmt = nil;

//准备查询语句

NSString *selectSQL = [NSString stringWithFormat:@"select * from student where name = '%@'",name];

//查询

int result = sqlite3_prepare(db,selectSQL.UTF8String,-1,&stmt,NULL);

if (SQLITE_OK == result) {

while (SQLITE_ROW == sqlite3_step(stmt)) {

student = [Student new];

student.number = sqlite3_column_int(stmt, 0);

student.name = [NSString stringWithUTF8String:(const char *)sqlite3_column_text(stmt,1)];

student.age = sqlite3_column_int(stmt, 2);

student.gender = [NSString stringWithUTF8String:(const char *)sqlite3_column_text(stmt,3)];

NSLog(@" %@",student);

}

}else

{

NSLog(@"查询失败");

}

//释放指针

sqlite3_finalize(stmt);

return student;

}

（编辑：李大同）

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