我正在尝试读/写到SQLite数据库,但我不断收到错误消息。我已验证该数据库存在于... iPhone Simulator / Applications / 5.1 / app#/ Documents / kipSQLDB.db中

我已经从Terminal完成了INSERT和SELECT的选择。

但是从应用程序中它只会出错。 (另一个问题-sqlite是否有办法在mysql中获取诸如mysql_error之类的信息性错误消息?当我在应用程序中出错时,除了一些符号外,我什么也没得到。

这是我的代码:

。H

#import <Foundation/Foundation.h>
#import <sqlite3.h>

@interface SQLiteController : NSObject {

//file management
NSFileManager *fileManager;
NSString *documentsDirectory;

//sqlite data
sqlite3* databaseHandle;

}

- (void) initSQLiteDB;

- (void) insertData : (NSString* ) fName : (NSString* ) lName : (NSString* ) companyName;

- (NSArray* ) getData;

@end


.m

- (void) insertData : (NSString* ) fName : (NSString* ) lName : (NSString* ) companyName {

NSString* insertStatement = [NSString stringWithFormat:@"INSERT INTO nameList (userFName, userLName, userCompany) VALUES (\"%@\", \"%@\", \"%@\")", fName, lName, companyName];
NSLog(@"%@", insertStatement);

char *error;
if ( sqlite3_exec(databaseHandle, [insertStatement UTF8String], NULL, NULL, &error) == SQLITE_OK) {

    int recordID = sqlite3_last_insert_rowid(databaseHandle);
    NSLog(@"A record was inserted into the database %@ with the id of %i", databaseHandle, recordID);
} else {
    NSLog(@"Error: %s", error);
}
}

- (NSArray* ) getData {

NSMutableArray* dataArray = [[NSMutableArray alloc] init];

NSString* getStatement = @"SELECT * FROM nameList";

sqlite3_stmt *statement;
if (sqlite3_prepare_v2(databaseHandle, [getStatement UTF8String], -1, &statement, NULL) == SQLITE_OK){

    // Iterate over all returned rows
    while (sqlite3_step(statement) == SQLITE_ROW) {

        int recordID = sqlite3_column_int(statement, 0);
        NSString* fNameFromDB = [NSString stringWithUTF8String:(char*)sqlite3_column_text(statement, 1)];
        NSLog(@"%@", fNameFromDB);
    }
} else {
    NSLog(@"No soup for you!");
}

return 0;

}
@end

最佳答案

使用Try catch格式并捕获sql的错误类型

关于ios - iOS SQLite插入并选择不起作用?,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/11082479/

10-14 13:40
查看更多