如何在Sqlite中插入记录? [英] How to insert a record in Sqlite?
本文介绍了如何在Sqlite中插入记录?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请有人告诉我如何通过目标c在sqlite中插入记录吗?
please anybody tell me how to insert records in sqlite through objective c?
推荐答案
你可以使用像这样的代码块这个
You can use a block of code like this
-(NSString*) GetDatabasePath {
NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,
NSUserDomainMask, YES) ;
NSString *documentsDirectory = [paths objectAtIndex:0] ;
return [documentsDirectory stringByAppendingPathComponent:@"Your Database"] ;
}
-(void)InsertPurchase {
sqlite3_stmt *statement=nil;
NSString *path = [self GetDatabasePath];
NSString *query;
if(sqlite3_open([path UTF8String],&db) == SQLITE_OK)
{
query = [NSString stringWithFormat: @"Your insert query"];
if(sqlite3_prepare_v2(db, [query UTF8String], -1, &statement, NULL)
== SQLITE_OK)
{
sqlite3_step(statement);
}
sqlite3_finalize(statement);
}
sqlite3_close(db);
}
这可以是你的界面
@interface Database : NSObject {
sqlite3 *db;
}
这篇关于如何在Sqlite中插入记录?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文