//执行类似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;