我正在尝试读/写到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/