如何将nsmutable数组添加到sqlite数据库表中 [英] How to add nsmutable array into sqlite database table
本文介绍了如何将nsmutable数组添加到sqlite数据库表中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何将nsmutablearray添加到sqlite数据库表中?任何人都可以帮我编码吗?
解决方案
使用的循环控制以对数组进行排序,并插入每个值
'p> 示例:强>
对(INT的ItemIndex = 0;的ItemIndex< ; [yourArray count]; itemIndex ++){
NSString * myname = [yourArray objectAtIndex:itemIndex];
//将myname插入数据库。
}
要检索,您可以使用以下代码示例
如果(sqlite3_open([路径UTF8字符串],&安培;数据库)== SQLITE_OK)
{
NSString * query = [NSString stringWithFormat:@从syncTable中选择名称,其中Crc =%d,crc]; const char * sql = [query UTF8String];
sqlite3_stmt *声明;
if(sqlite3_prepare(dataBase,sql,-1,& statement,NULL)== SQLITE_OK)
{
char * name;
unsigned int value;
while(sqlite3_step(statement)== SQLITE_ROW)
{
name =(char *)sqlite3_column_text(statement,0);
[yourArray addObject:[NSString stringWithUTF8String:name]];
}
sqlite3_finalize(statement);
}
}
How to add nsmutablearray into the sqlite database table?Can any one help me to code?
解决方案
Use looping Controls to sort the array and insert each values
Example:
for(int itemIndex = 0; itemIndex < [yourArray count];itemIndex++){
NSString *myname = [yourArray objectAtIndex:itemIndex];
//insert myname to database.
}
To retrieve, you can use the sample below code
if(sqlite3_open([path UTF8String], &dataBase) == SQLITE_OK)
{
NSString *query = [NSString stringWithFormat:@"select name from syncTable where Crc = %d",crc]; const char *sql = [query UTF8String];
sqlite3_stmt *statement;
if (sqlite3_prepare(dataBase, sql, -1, &statement, NULL) == SQLITE_OK)
{
char *name;
unsigned int value;
while(sqlite3_step(statement) == SQLITE_ROW)
{
name = (char *)sqlite3_column_text(statement, 0);
[yourArray addObject:[NSString stringWithUTF8String:name]];
}
sqlite3_finalize(statement);
}
}
这篇关于如何将nsmutable数组添加到sqlite数据库表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文