如何通过iphone编程插入多行数据到sqlite数据库(How to insert multiple row of data to sqlite database by iphone programming)

 我是iphone开发的新手。我想插入多个值到我的sqlite3数据库并在tableview中显示内容。我能够将单行数据插入到我的数据库并检索并显示数据，但我无法与插入多行数据有关。这里是我的代码... 
 
-(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);


}
 
 有没有其他方法可以将多行数据插入到我的表中，请帮助我。谢谢。 

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','xxx')";
        int result=sqlite3_prepare_v2(db, sql1, -1, &insert_MyObj_statement, NULL);
    }
    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.

原文：https://stackoverflow.com/questions/2200828