blob_read_e.c

来自「Sqlite3 数据库Blob格式读写程序（ARM版）」· C语言 代码 · 共 41 行

/* blob read */
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <sqlite3.h>

int main(int argc, char**argv)
{
    int ret = 0;
    int db_id = 0;
    int db_len = 0;
    int iloop = 0; 
    const void * name = NULL;  
    sqlite3_stmt * stmt = NULL; 
    sqlite3 * db = NULL;
    
    ret = sqlite3_open("test.db", &db);
    if (ret!= SQLITE_OK)
    {
    		printf("ERROR:: sqlite3_open() failure!\n");
    		return -1;
    }
    
    sqlite3_prepare( db, "SELECT * FROM TBL_TEST", -1, &stmt, NULL);
    while((ret = sqlite3_step(stmt)) == SQLITE_ROW)
    {
	      db_id = sqlite3_column_int(stmt, 0);
	      printf("blob row %d:: id is '%d'\n", iloop++, db_id);
	      
	      name = sqlite3_column_blob(stmt, 1);
	      db_len = sqlite3_column_bytes(stmt, 1);
	      printf("blob len = %d:: name is '%s'\n", db_len, (char*)name);
    }
    
    sqlite3_reset(stmt);
    sqlite3_finalize(stmt);
    sqlite3_close(db);
    
    return 0;
}