C语言封装sqlite3_API

//执行类似insert,update,create,drop这些不需要结果的sql语句。

int executeNoQuery(sqlite3 *db,const char *sql)
 {
    sqlite3_stmt *pstmt = NULL;
 
     if(sqlite3_prepare_v2(db,sql,strlen(sql),&pstmt,NULL)  !=  SQLITE_OK)
     {
         if(pstmt != NULL)
             sqlite3_finalize(pstmt);
        fprintf(stderr,"%s\n",sqlite3_errmsg(db));
         return -1;
     }
     if(sqlite3_step(pstmt)  !=  SQLITE_DONE)
     {
         sqlite3_finalize(pstmt);
         fprintf(stderr,"%s\n",sqlite3_errmsg(db));
         return -1;
    }
     if(pstmt != NULL)
         sqlite3_finalize(pstmt);
     return 0;
 }

//执行select查询语句

void executeWithQuery(sqlite3 *db,char ***result,int *col,const char *sql)
  {
      int ret,row;