ios - 为什么在IOS的sqlite中插入数据时数据库被锁定？

为什么在sqlite中插入数据时为什么数据库被锁定？我已经打开并关闭所有数据库代码了吗？我有以下代码：

-(void)insertDataIn_tbl_selectItem_data: (NSString *)empID ProdId: (NSString *)prodId ProdName: (NSString *)prodName  GenName: (NSString *)genName ComputeType: (NSString *)computeType UOM: (NSString *)uom ListPrice: (NSString *)listPrice UOMQty: (NSString *)uomqty{

    const char *query = "insert into tbl_selectItem_data (femployeeid,fproductid,fname,fgeneric_name,fcompute_type,fuom,flist_price,fuomqty) values (?,?, ?, ?, ?, ?, ?, ?)";
    sqlite3_stmt *stmt;

    if (sqlite3_open([sqLiteDb UTF8String], &(_database)) == SQLITE_OK) {
        if (sqlite3_prepare_v2(_database, query, -1, &stmt, nil) == SQLITE_OK) {

            sqlite3_bind_text(stmt, 1, [empID UTF8String], -1, SQLITE_TRANSIENT);
            sqlite3_bind_text(stmt, 2, [prodId UTF8String], -1, SQLITE_TRANSIENT);
            sqlite3_bind_text(stmt, 3, [prodName UTF8String], -1, SQLITE_TRANSIENT);
            sqlite3_bind_text(stmt, 4, [genName UTF8String], -1, SQLITE_TRANSIENT);
            sqlite3_bind_text(stmt, 5, [computeType UTF8String], -1, SQLITE_TRANSIENT);
            sqlite3_bind_text(stmt, 6, [uom UTF8String], -1, SQLITE_TRANSIENT);
            sqlite3_bind_text(stmt, 7, [listPrice UTF8String], -1, SQLITE_TRANSIENT);
            sqlite3_bind_text(stmt, 8, [uomqty UTF8String], -1, SQLITE_TRANSIENT);

            if(sqlite3_step(stmt) == SQLITE_DONE){
                NSLog(@"Insert Successful");
                sqlite3_finalize(stmt);
            }else{
                NSLog(@"insertDataIn_tbl_selectItem_data error: %s", sqlite3_errmsg(_database));
            }
        }
    }

    sqlite3_close(_database);
}

最佳答案

首先，...即使有错误，也要尝试“完成”您的陈述...因此您的方法：

if(sqlite3_step(stmt) == SQLITE_DONE){
            NSLog(@"Insert Successful");
            sqlite3_finalize(stmt);
        }else{
            NSLog(@"insertDataIn_tbl_selectItem_data error: %s", sqlite3_errmsg(_database));
        }
    }
}
sqlite3_close(_database);

最好是：

if(sqlite3_step(stmt) == SQLITE_DONE){
            NSLog(@"Insert Successful");
        }else{
            NSLog(@"insertDataIn_tbl_selectItem_data error: %s", sqlite3_errmsg(_database));
        }
    }
 sqlite3_finalize(stmt);
}

sqlite3_close(_database);

第二...

您可以尝试使用sqlite3_open_v2代替sqlite3_open有关此内容的更多信息：http://www.sqlite.org/c3ref/open.html

所以与其：

if (sqlite3_open([sqLiteDb UTF8String], &(_database)) == SQLITE_OK) {...}

将是：if (sqlite3_open_v2([sqLiteDb UTF8String], &(_database), SQLITE_OPEN_READWRITE, NULL) == SQLITE_OK) {....}

关于ios - 为什么在IOS的sqlite中插入数据时数据库被锁定？，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/21597925/