sqlite 使用

bind 的使用。

#include "sqlite3.h"
#include <stdlib.h>

int main( int argc, char **argv )
{
    char            *file = "test.db"; /* default to temp db */
    sqlite3         *db = NULL;
    sqlite3_stmt    *stmt = NULL;
    int             rc = 0;
    int             idx = -1;


    sqlite3_initialize( );
    rc = sqlite3_open_v2( file, &db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, NULL );
    if ( rc != SQLITE_OK) {
        sqlite3_close( db );
        exit( -1 );
    }

    char *data[]={
        "hello1",
        "hello2",
        "hello3",
        "hello4",
        "hello5",
        "hello6",
        "world7",
    };
    char *str[]={
        "str3",
        "str4",
        "str5",
        "str6",
        "str7",
        "str8",
        "str9",
    };
    rc = sqlite3_prepare_v2( db, "INSERT INTO tbl(data, str) VALUES (:data, :str )", -1, &stmt, NULL );
    if ( rc != SQLITE_OK) exit( -1 );
    int i;
    for(i = 0; i < 7; i++){
        idx = sqlite3_bind_parameter_index( stmt, ":data" );
        sqlite3_bind_text( stmt, idx, data[i], -1, SQLITE_STATIC );
        idx = sqlite3_bind_parameter_index( stmt, ":str" );
        sqlite3_bind_text( stmt, idx, str[i], -1, SQLITE_STATIC );
        rc = sqlite3_step( stmt );
        if (( rc != SQLITE_DONE )&&( rc != SQLITE_ROW )) exit ( -1 );
        sqlite3_reset(stmt);
    }
    sqlite3_finalize( stmt );





    sqlite3_close( db );
    sqlite3_shutdown( );
}