- (IBAction)load:(id)sender {

sqlite3_stmt *statement;

NSString *databasePath=[self databasePath];

const char *dbpath = [databasePath UTF8String];

if (sqlite3_open(dbpath,&db)==sqlITE_OK) {

@H_404_43@ NSString@H_404_43@ *querysql = [NSString@H_404_43@ stringWithFormat@H_404_43@:@"SELECT classname,name from info where num=\"%@\""@H_404_43@,num@H_404_43@.text@H_404_43@]; //================这里就实现了用号码查询，其他的可以另外实现

const char *querystatement = [querysql UTF8String];

if (sqlite3_prepare_v2(db,querystatement,-1,&statement,NULL)==sqlITE_OK) {

if (sqlite3_step(statement)==sqlITE_ROW) {

/*

//做个小测试(原来版本）

NSString *classnameField = [[NSString alloc] initWithUTF8String:(const char *)sqlite3_column_text(statement,0)];

NSString *nameField = [[NSString alloc] initWithUTF8String:(const char *) sqlite3_column_text(statement,1)];

classname.text = classnameField;

name.text = nameField;

*/

@H_404_43@ //=======测试部分=====================

NSMutableArray *such =[[NSMutableArray alloc]initWithCapacity:30];

for (int i=0; i<2; i++) {

NSString *tab=[[NSString alloc] initWithUTF8String:(const char *)sqlite3_column_text(statement,i)];

[such addObject:tab];

}

classname.text=[such objectAtIndex:0];

name.text=[such objectAtIndex:1];

@H_404_43@ //=======================================

@H_404_43@ //status.text = @"find~~~";

}

sqlite3_finalize(statement);

}

@H_404_43@ sqlite3_close@H_404_43@(db@H_404_43@);

}}