我开发了一个应用程序，在其中我需要从数组以及数据库中删除行。 我也想从数据库和数组中删除该行。在编辑方法中，我编写如下代码
MoneyAppDelegate *mydelegate=(MoneyAppDelegate *)[[UIApplication sharedApplication]delegate];
if (editingStyle == UITableViewCellEditingStyleDelete)
{
database *objdata=[[database alloc]init];
[app deleteCategory:objdata];
[self.mytableview deleteRowsAtIndexPaths:[NSArray arrayWithObject:indexPath] withRowAnimation:UITableViewRowAnimationFade];
}
但这行不通。在deletecategory方法中，我有类似的代码
-(void)deleteCategory:(database *)databaseObj
{
[databaseObj deleteCategory];
[myarray removeObject:databaseObj];
}
-(UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath
{
MoneyAppDelegate * app =(MoneyAppDelegate *)[[UIApplication sharedApplication] delegate];
静态NSString * CellIdentifier = @“Cell”;
UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:CellIdentifier];
if (cell == nil) {
cell = [[[UITableViewCell alloc] initWithStyle:UITableViewCellStyleDefault reuseIdentifier:CellIdentifier] autorelease];
cell.accessoryType=UITableViewCellAccessoryDisclosureIndicator;
}
cell.textLabel.text = [app.myarray4 objectAtIndex:indexPath.row];
return cell;}
deletecategory是从数据库中删除记录的方法。
我如何从数据库中删除所选行，我知道它非常简单，但是我却很困惑..thnanx :)
最佳答案
尝试这样-
- (UITableViewCellEditingStyle)tableView:(UITableView *)tableView editingStyleForRowAtIndexPath:(NSIndexPath *)indexPath
{
return UITableViewCellEditingStyleDelete;
}
-(void) tableView:(UITableView *)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath
{
[self delBtnPressed:indexPath.row];
}
//在这里放置代码-
-(void)delBtnPressed:(int)sender
{
NSString *titleStr=@"";
NSString *table=@"";
NSString *attribute=@"";
sqlite3 *database;
if(![titleStr isEqualToString:@""])
{
//-------------------------------deletion-------------------------
if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK)
{
NSString * sqlStatement = [NSString stringWithFormat:@"delete from %@ where %@='%@' ",table,attribute,titleStr];
if (sqlite3_exec(database, [sqlStatement cStringUsingEncoding:NSUTF8StringEncoding], NULL, NULL, NULL) == SQLITE_OK)
{
[yourArr removeAllObjects];
[self fetchAgain]; //here you need to fetch all records from DB and fill the yourArr again.
[tblView reloadData];
}
sqlite3_close(database);
}
}
else
{
NSLog(@"Error while deleting please try again");
}
}
关于objective-c - 从数组和数据库中删除行，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/10291802/