//创建表@H_403_3@

-(void)createTable@H_403_3@

{@H_403_3@

//准备sql语句@H_403_3@

NSString *createTablesql = @"CREATE TABLE IF NOT EXISTS 'student' ('number' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE,'name' TEXT NOT NULL,'age' INTEGER NOT NULL,'gender' TEXT NOT NULL DEFAULT male)";@H_403_3@

@H_403_3@

//c语言里的函数sqlite3_exec,为什么用NULL不用nil，因为nil属于OC，NULL属于c@H_403_3@

int result = sqlite3_exec(db,createTablesql.UTF8String,NULL,NULL);@H_403_3@

@H_403_3@

if (sqlITE_OK == result) {@H_403_3@

NSLog(@"成功");@H_403_3@

}else@H_403_3@

{@H_403_3@

NSLog(@"失败");@H_403_3@

}@H_403_3@

@H_403_3@

}@H_403_3@