[sqlite] ver.3 사용 예제

#include <stdio.h>

#include <stdlib.h>

#include <string.h>

#include <sqlite3.h>

int main( int argc, char *argv[] )

{

    sqlite3 *database = NULL;

    sqlite3_stmt *statement = NULL;

    char *sql = "SELECT * FROM ? WHERE ? = ?";

    char *dbname = "";

    if ( SQLITE_OK != sqlite3_open( dbname, &database ) )

    {

        // error

    }

    if ( SQLITE_OK != sqlite3_prepare( &database, sql, strlen( sql ), &statement, NULL ) )

    {

        // error

    }

    if ( SQLITE_OK != sqlite3_bind_????( &statement, col_num, ???? ) )

    {

        // error

    }

    while ( SQLITE_DONE != sqlite3_step( statement ) )

    {

        printf( "%d : %s\n", sqlite3_column_????( statement, 0 ), sqlite3_column_????( statement, 1 ) );

    }

    sqlite3_reset( statement )

    sqlite3_finalize( statement )

    return 0;

}