1.导入数据库包libsqlite3.dylib
2.代码中:
1).h文件中加入:#import <sqlite3.h>
2).m文件中
-(NSMutableArray*)selectStudentInfoTableByIDFromdb:(NSInteger)sid {
//打开检测链接
[self open];
NSMutableArray*studentArray=[[NSMutableArray alloc]init];
NSLog(@" Yes,BeginReading info");
NSString*SQLString=@"SELECT sid,name,sex,age FROM student where sid=?";
sqlite3_stmt *stmt;
if(sqlite3_prepare_v2(database, [SQLString UTF8String], -1, &stmt,nil)==SQLITE_OK) {
//设置参数
sqlite3_bind_int(stmt,1, sid);
while(sqlite3_step(stmt)==SQLITE_ROW) {
NSInteger sid=sqlite3_column_int(stmt, 0);
char *name=(char *)sqlite3_column_text(stmt, 1);
char *Sex=(char *)sqlite3_column_text(stmt, 2);
NSInteger Age=sqlite3_column_int(stmt, 3);
//设置接受信息,进行数据格式转换
NSString *sidStri=[[NSString alloc]initWithFormat:@"%d",sid];
NSString *NameStr=[[NSString alloc]initWithUTF8String:name];
NSString *SexStr=[[NSString alloc]initWithUTF8String:Sex];
NSString *AgeStr=[[NSString alloc]initWithFormat:@"%d",Age];
//加载信息
[studentArray addObject:sidStri];
[studentArray addObject:NameStr];
[studentArrayaddObject:SexStr];
[studentArray addObject:AgeStr];
}
}
else{
NSLog(@"数据读写错误,数据库访问错误!!");
}
return studentArray;
}