SQLite3 示例学习

    
    示例一
    
    sqlite3 *db;
    char *zErrMsg = 0;
    int rc, colNumber = 0, j,i, row_count = 0;
    printf("sqlite3 info:\n libversion:%s\n souceid:%s\n vesion_num:%d\n",sqlite3_libversion(), sqlite3_sourceid(),
      sqlite3_libversion_number());
    
    sqlite3_stmt *pStmt = NULL;
    // 打开数据库文件
    rc = sqlite3_open("argv[1]", &db);
    if( rc ){
      fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
      sqlite3_close(db);
      return(1);
    }
    // 把一条SQL语句编译成字节码留给后面的执行函数
    rc = sqlite3_prepare(db, "SQLString", strlen("SQLString"), &pStmt, NULL);
    printf("rc =%d\n", rc);
    if(rc != SQLITE_OK){
        fprintf(stderr, "SQL error1: %s\n", zErrMsg);
        sqlite3_free(zErrMsg);
        return 1;
    }
  
    printf("pStmt=%p\n",pStmt);
    // 获取数据库有多少列
    ret = sqlite3_column_count(pStmt);
    prin