个人中心
gpt4 book ai didi

ios - 'NSUnknownKeyException'，原因 : '[ setValue:forUndefinedKey:]:

转载 作者：搜寻专家 更新时间：2023-10-30 22:22:24 25 4
gpt4 key购买 nike

<分区>

当我在 iPhone 模拟器上运行我的第一个“sqlite”应用程序时出现此错误。 xcode 说没问题，但是当我点击我的应用程序时，它会在调试窗口中抛出错误。我在这里放置了所有必要的代码，请帮助我连接“sqlite”并删除这些错误。

错误如下:

Terminating app due to uncaught exception 'NSUnknownKeyException', reason: '[<ViewController 0x8a45930> setValue:forUndefinedKey:]: this class is not key value coding-compliant for the key departmentbox.'
*** First throw call stack:
(0x2091012 0x119ee7e 0x2119fb1 0xc4b711 0xbccec8 0xbcc9b7 0xbf7428 0x3030cc 0x11b2663 0x208c45a 0x301bcf 0x1c6e37 0x1c7418 0x1c7648 0x1c7882 0x116a25 0x116dbf 0x116f55 0x11ff67 0xe3fcc 0xe4fab 0xf6315 0xf724b 0xe8cf8 0x1fecdf9 0x1fecad0 0x2006bf5 0x2006962 0x2037bb6 0x2036f44 0x2036e1b 0xe47da 0xe665c 0x233d 0x2265)
libc++abi.dylib: terminate called throwing an exception
(lldb)

数据库管理器.m:

//
//  DBManager.m
//  sqlite
//
//  Created by Techinfiniti on 14/05/14.
//  Copyright (c) 2014 Techinfiniti. All rights reserved.
//

#import "DBManager.h"
#import <sqlite3.h>

static DBManager *sharedInstance = nil;
static sqlite3 *database = nil;
static sqlite3_stmt *statement = nil;



@implementation DBManager

+(DBManager*)getSharedInstance{

    if(!sharedInstance){
        sharedInstance = [[super allocWithZone:NULL]init];
        [sharedInstance createDB];
    }
    return sharedInstance;
}

-(BOOL)createDB{

    NSString *docsDir;
    NSArray *dirPaths;

        dirPaths = NSSearchPathForDirectoriesInDomains(NSDocumentationDirectory, NSUserDomainMask, YES);
    docsDir = dirPaths[0];
    databasePath = [[NSString alloc] initWithString:[docsDir stringByAppendingPathComponent:@"student.db"]];
    BOOL isSuccess = YES;
    NSFileManager *filemgr = [NSFileManager defaultManager];

    if([filemgr fileExistsAtPath:databasePath]== NO)
    {
        const char *dbpath = [databasePath UTF8String];
        if(sqlite3_open(dbpath,&database)== SQLITE_OK )
        {
            char *errMsg;
            const char *sql_stmt = "create table if not exists studentsDetail (regno integer primary key, name text, department text, year text)";

            if(sqlite3_exec(database,sql_stmt,NULL,NULL,&errMsg)!= SQLITE_OK)
            {

                isSuccess = NO;
                NSLog(@"failed to open create table");
            }
            sqlite3_close(database);
            return isSuccess;
        }
        else{
            isSuccess = NO;
            NSLog(@"Failed to open/create database");
        }
    }return isSuccess;

}

-(BOOL)saveData:(NSString*)registerNumber name:(NSString*)name
     department:(NSString *)department year:(NSString *)year;
{
    const char *dbpath = [databasePath UTF8String];
    if(sqlite3_open(dbpath,&database)== SQLITE_OK )
    {
        NSString *insertSQL = [NSString stringWithFormat:@"insert into studentDetail(regno,name,department,year)values(\"%d\",\"%@\",\"%@\",\"%@\")",[registerNumber integerValue],name,department,year];
        const char *insert_stmt = [insertSQL UTF8String]; sqlite3_prepare_v2(database, insert_stmt,-1,&statement,NULL);



    if(sqlite3_step(statement) == SQLITE_DONE)
{
    return YES;
}
else{
    return NO;
}
sqlite3_reset(statement);
}
return NO;

}

-(NSArray*) findByRegisterNumber:(NSString *)registerNumber
{

    const char *dbpath = [databasePath UTF8String];
    if(sqlite3_open(dbpath,&database)== SQLITE_OK)
    {
        NSString *querySQL = [NSString stringWithFormat:@"select name, department,year from studentDetail where regno=\"%@\"",registerNumber];

        const char *query_stmt = [querySQL UTF8String];
        NSMutableArray *resultArray = [[NSMutableArray alloc]init];
        if(sqlite3_prepare_v2(database,query_stmt,-1,&statement,NULL)== SQLITE_OK)
        {
            if(sqlite3_step(statement) == SQLITE_ROW)
            {
                NSString *name = [[NSString alloc] initWithUTF8String:(const char *) sqlite3_column_text(statement, 0)];
                [resultArray addObject:name];

                NSString *department = [[NSString alloc]initWithUTF8String:(const char*) sqlite3_column_text(statement,1)];
                [resultArray addObject:department];
                return resultArray;

                 NSString *year = [[NSString alloc]initWithUTF8String:(const char*) sqlite3_column_text(statement,2)];
                [resultArray addObject:year];
                return resultArray;


            }
            else{
                NSLog(@"Not Found");
                return nil;
            }
            sqlite3_reset(statement);
        }

    }
    return nil;
}

@end

ViewController.h:

//
//  ViewController.h
//  sqlite
//
//  Created by Techinfiniti on 14/05/14.
//  Copyright (c) 2014 Techinfiniti. All rights reserved.
//

#import <UIKit/UIKit.h>
#import "DBManager.h"

@interface ViewController : UIViewController<UITextFieldDelegate>
{
    IBOutlet UITextField *regNoTextField;
    IBOutlet UITextField *nameTextField;
    IBOutlet UITextField *departmentTextField;
    IBOutlet UITextField *yearTextField;
    IBOutlet UITextField *findByRegisterNumberTextField;
    IBOutlet UIScrollView *myScrollView;
}

-(IBAction)saveData:(id)sender;
-(IBAction)findData:(id)sender;


/*
- (IBAction)find:(id)sender;

- (IBAction)save:(id)sender;


@property (weak, nonatomic) IBOutlet UITextField *findbox;

@property (weak, nonatomic) IBOutlet UITextField *regnobox;

@property (weak, nonatomic) IBOutlet UITextField *namebox;

@property (weak, nonatomic) IBOutlet UITextField *departmentbox;

@property (weak, nonatomic) IBOutlet UITextField *year;
*/

@end

ViewController.m:

//
//  ViewController.m
//  sqlite
//
//  Created by Techinfiniti on 14/05/14.
//  Copyright (c) 2014 Techinfiniti. All rights reserved.
//

#import "ViewController.h"

@interface ViewController ()

@end

@implementation ViewController

- (id)initWithNibName:(NSString *)nibNameOrNil bundle:(NSBundle *)nibBundleOrNil
{

    self = [super initWithNibName:nibNameOrNil bundle:nibBundleOrNil];

    if(self)
    {


    }
    return self;
}

- (void)viewDidLoad
{
    [super viewDidLoad];
    // Do any additional setup after loading the view, typically from a nib.
}

- (void)didReceiveMemoryWarning
{
    [super didReceiveMemoryWarning];
    // Dispose of any resources that can be recreated.
}

/*
- (IBAction)find:(id)sender {
}

- (IBAction)save:(id)sender {
}

 */

-(IBAction)saveData:(id)sender{
    BOOL success = NO;
    NSString *alertString = @"Data Insertion falied";
    if(regNoTextField.text.length>0 && yearTextField.text.length>0 && departmentTextField.text.length>0 && yearTextField.text.length>0)
    {

        success = [[DBManager getSharedInstance]saveData:regNoTextField.text name:nameTextField.text department:departmentTextField.text year:yearTextField.text];
    }
    else
    {
        alertString = @"Enter all fields";
    }

    if(success == NO)
    {

        UIAlertView *alert = [[UIAlertView alloc]initWithTitle:alertString message:nil delegate:nil cancelButtonTitle:@"OK" otherButtonTitles:nil];
        [alert show];
    }

}

-(IBAction)findData:(id)sender{

    NSArray *data = [[DBManager getSharedInstance]findByRegisterNumber:findByRegisterNumberTextField.text];

    if(data == nil)
    {

        UIAlertView *alert = [[UIAlertView alloc]initWithTitle:
                              @"Data Not Found" message:nil delegate:nil cancelButtonTitle:@"OK" otherButtonTitles:nil];
        [alert show];
        regNoTextField.text = @"";
        nameTextField.text = @"";
        departmentTextField.text = @"";
        yearTextField.text = @"";

    }
    else{

        regNoTextField.text = findByRegisterNumberTextField.text;
        nameTextField.text = [data objectAtIndex:0];
        departmentTextField.text = [data objectAtIndex:1];
        yearTextField.text = [data objectAtIndex:2];
    }


}


#pragma mark - Text field delegate

-(void)textFieldDidBeginEditing:(UITextField *)textField{

    [myScrollView setFrame:CGRectMake(10,50,300,200)];

}

-(BOOL) textFieldShouldReturn:(UITextField *)textField
{

    [textField resignFirstResponder];
    return YES;
}
@end

25 4 0
文章推荐： arrays - 具有特定类型的对象数组
文章推荐： database - 使用 Sqlite 数据填充 Tcl Treeview
文章推荐： sql - 向数据库添加 n 个条目的复杂性
文章推荐： 没有getter的Swift实现setter
搜寻专家
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com