如何通过iphone编程将多行数据插入sqlite数据库 [英] How to insert multiple row of data to sqlite database by iphone programming

问题描述

我是iphone开发的新手。我想在我的sqlite3数据库中插入多个值并在tableview中显示内容。我能够将单行数据插入到我的数据库中并检索它并显示数据但是我我无法插入多行数据。这是我的代码......

I am new to iphone development.I want to insert multiple values into my sqlite3 database and display the content in the tableview.I am able to insert single row of data in to my database and retrieve it and display the data but i am not able to do with inserting multiple row of data.Here is my code...

-(void)initializeTableData{
sqlite3 *db=[DatabaseTestAppDelegate getNewDBConnection];
sqlite3_stmt *statement=nil;
sqlite3_stmt *statement1=nil;

if (insert_MyObj_statement == nil)
{
    const char *sql2="DELETE FROM user";
    sqlite3_prepare_v2(db, sql2, -1, &statement1, NULL);
    sqlite3_step(statement1);
    //const char *sql1 = "INSERT INTO user (id,name) VALUES ('0','ash'),('3','karna'),('2','kumar'),('5','siva')";
const char *sql1 = "INSERT INTO user (id,name) VALUES ('0','xxx')";
 int result=sqlite3_prepare_v2(db, sql1, -1, &insert_MyObj_statement, NULL);
    NSAssert1(result == SQLITE_OK, @"addMyObjectIntoDatabase: failed to prepare statement with err '%s'", sqlite3_errmsg(db));
}
 sqlite3_step(insert_MyObj_statement);

const char *sql="select * from user";
if(sqlite3_prepare_v2(db, sql, -1, &statement, NULL)!=SQLITE_OK)
    NSAssert1(0,@"error in preparing staement",sqlite3_errmsg(db));
else{
    while(sqlite3_step(statement)==SQLITE_ROW)
        [tableData addObject:[NSString stringWithFormat:@"%s",(char*)sqlite3_column_text(statement,1)]];
}
    sqlite3_finalize(statement);


}

还有其他方法可以插入多个我的表中有一行数据。请帮帮我。谢谢。

Is there any other way to insert multiple row of data in to my table .Please help me out.Thanks.

推荐答案

尝试使用 sprintf语句如下所示，

在变量i 的循环中使用此语句。

use this statement inside the loop with variable i.

sprintf(buffer,"INSERT INTO user (name) VALUES ('%s');",[[names objectAtIndex:i] UTF8String]);

这篇关于如何通过iphone编程将多行数据插入sqlite数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！