问题描述
我想尝试将一些数据插入sqlite数据库表，但是出现错误像这样:
I want to try insert some data in to sqlite database table but I got an error like this:
***Assertion failure in -[ViewController buttonClick:],/Users/ds/Desktop/SqliteDeneme/SqliteDeneme/ViewController.m:57
我的代码在这里:
- (IBAction)buttonClick:(id)sender {
NSString *str1 =@"1";
NSString *str2 =@"1";
NSString *str3 =@"0.1";
NSString *str4 =@"0.1";
NSString *str5 =@"0.1";
NSString *str6 =@"0.1";
NSString *str7 =@"deneme";
NSString *str8 =@"1";
NSString *str9 =@"1";
NSString *str10=@"deneme";
NSArray *pathsArray=NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask,YES);
NSString *doumentDirectoryPath=[pathsArray objectAtIndex:0];
destinationPath=[doumentDirectoryPath stringByAppendingPathComponent:@"SqliteTestDb.sqlite"];
NSLog(@"database path %@",destinationPath);
if (sqlite3_open([destinationPath UTF8String], &cruddb)==SQLITE_OK)
{
NSLog(@"dataBaseOpen");
// leak happens here, do stuff then call sqlite3_close(database), or move it out of the if/else block.
if(stmt == nil) {
const char *sql = "INSERT INTO LabUpdate (IsSuccess, ProducerId, Latitude, Longitude, Altitude, Slope, SampleDate, PackageNo, Status, Description) VALUES (?,?,?,?,?,?,?,?,?,?)";
if(sqlite3_prepare_v2(cruddb, sql, -1, &stmt, NULL) == SQLITE_OK){
//sqlite3_prepare_v2(cruddb, sql, 1, &stmt, NULL);
sqlite3_bind_int(stmt, 1, [str1 integerValue]);
sqlite3_bind_int(stmt, 2, [str2 integerValue]);
sqlite3_bind_double(stmt, 3, [str3 floatValue]);
sqlite3_bind_double(stmt, 4, [str4 floatValue]);
sqlite3_bind_double(stmt, 5, [str5 floatValue]);
sqlite3_bind_double(stmt, 6, [str6 floatValue]);
sqlite3_bind_text(stmt, 7, [str7 UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_int(stmt, 8, [str8 integerValue]);
sqlite3_bind_int(stmt, 9, [str9 integerValue]);
sqlite3_bind_text(stmt, 10, [str10 UTF8String], -1, SQLITE_TRANSIENT);
}
else
NSAssert1(0, @"Error while creating add statement. '%s'", sqlite3_errmsg(cruddb));
}
if(SQLITE_DONE != sqlite3_step(stmt))
NSAssert1(0, @"Error while inserting data. '%s'", sqlite3_errmsg(cruddb));
else
//SQLite provides a method to get the last primary key inserted by using sqlite3_last_insert_rowid
recordID = sqlite3_last_insert_rowid(cruddb);
//Reset the add statement.
sqlite3_reset(stmt);
}
else {
sqlite3_close(cruddb);
NSLog(@"dataBaseNotOpen");
NSAssert1(0, @"Error while opening database '%s'", sqlite3_errmsg(cruddb));
}
}
我该如何解决这个问题?我放了一个断点，但我没看到它在此行之后输入:
How can I solve this problem? I put a breakpoint and I saw it is not entered after this line:
if(sqlite3_prepare_v2(cruddb, sql, -1, &stmt, NULL) == SQLITE_OK){
这是我的数据库表和列:
this is my database table and colums:
推荐答案
我可以建议您使用其他技术来绑定列吗?
Can I suggest you use a different technique to binding columns:
NSString* SQL = [NSString stringWithFormat:@"INSERT INTO table1(col1,col2,col3) VALUES(%i,'%@',%i)",number,Surname,age];
其中数字和年龄是int的，姓是NSString *(请注意格式中字符串的引号).
where number and age are int's and surname is an NSString* (notice the quotes around strings in the format).
您可以使用以下代码执行此命令:
You can execute this command with code like this:
sqlite3_stmt *queryHandle = [self prepare:SQL];
if (sqlite3_step(queryHandle) != SQLITE_DONE)
{
NSLog(@"ExecuteNonQuery has error");
NSLog( @"Failed from sqlite3_step. Error is: %s", sqlite3_errmsg(database) );
}
else
{
int rowsaffected = sqlite3_changes(database);
}
常规准备功能如下所示:
The general prepare function would look like this:
-(sqlite3_stmt*)prepare:(NSString*)query
{
sqlite3_stmt *queryHandle;
const char *sqlStatement = (const char *) [query UTF8String];
if(sqlite3_prepare_v2(database, sqlStatement, -1, &queryHandle, NULL) != SQLITE_OK)
{
int error = sqlite3_prepare_v2(database, sqlStatement, -1, &queryHandle, NULL);
NSLog( @"Failed from sqlite3_prepare_v2. Error is: %s", sqlite3_errmsg(database) );
NSLog(@"Compiled Statement has error code:%i:%@",error,query);
}
return queryHandle;
}
这是我使用的方法，并且很快，可以推广到诸如prepare之类的子功能上.
This is the way I use and is quick, can be generalised to sub functions like the prepare.
希望这会有所帮助.
这篇关于我无法在目标C中将数据插入SQlite数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！