利用alertView 插入数据都数据库
-(void)addItemToList
{
UIAlertView *alter=[[UIAlertViewalloc]initWithTitle:@"ADD"message:@"please input"delegate:selfcancelButtonTitle:@"cancel"otherButtonTitles:@"sure", nil];
alter.alertViewStyle=UIAlertViewStylePlainTextInput;
[alter show];
}
-(void)alertView:(UIAlertView *)alertView clickedButtonAtIndex:(NSInteger)buttonIndex
{
NSString* chooseTitle = [alertView buttonTitleAtIndex:buttonIndex];
if([chooseTitle isEqualToString:@"cancel"])
{
return;
}
else{
NSString *str=[[alertView textFieldAtIndex:0] text];
if (str.length == 0) {
UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"提示"
message:@"请输入name"
delegate:nil
cancelButtonTitle:@"好"
otherButtonTitles:nil];
[alert show];
return;
}
//数据库插入
//调用封装好的数据库插入函数
if ([dbexecuteUpdate:@"INSERT INTO ClassList(ClassName) VALUES(?)",str])
{
UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"提示"
message:@"插入数据成功"
delegate:nil
cancelButtonTitle:@"好"
otherButtonTitles:nil];
[alert show];
[self.classNameItems removeAllObjects];
//从ClassList表取得数据
FMResultSet *classInfo=[dbexecuteQuery:@"SELECT ClassName FROM ClassList"];
while ([classInfo next]) {
[self.classNameItems addObject:[classInfo stringForColumn:@"ClassName"]];
}
[self.tableViewList reloadData];
}
else {
UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"提示"
message:@"插入数据失败"
delegate:nil
cancelButtonTitle:@"好"
otherButtonTitles:nil];
[alert show];
}
}
}