IPhone MySQL数据库操作代码例子

核心提示：while (sqlite3_step(statement) ==SQLITE_ROW) {//char* cid = (char*)sqlite3_column_text(statement, 1);char* stime = (char*)sqlite3_column_text(statement,1);char*

while (sqlite3_step(statement) ==SQLITE_ROW) {

//char* cid = (char*)sqlite3_column_text(statement, 1);

char* stime = (char*)sqlite3_column_text(statement,1);

char* stitle =(char*)sqlite3_column_text(statement,2);

char* scal = (char*)sqlite3_column_text(statement,3);

char* sruntime= (char*)sqlite3_column_text(statement,4);

//NSString *tmp = [NSString stringWithCString:stitle encoding:1];

myreportitem* ri = [[myreportitemalloc]init];

ri.mytime= [NSString stringWithCString:stime encoding:1];