Sqlite

Function:

SQLITE_API int sqlite3_open(
const char *filename,/* Database filename (UTF-8) */
sqlite3 **ppDb /* OUT: SQLite db handle */
);

SQLITE_API int sqlite3_open16(
const void *filename,/* Database filename (UTF-16) */
sqlite3 **ppDb /* OUT: SQLite db handle */
);

SQLITE_API int sqlite3_open_v2(
const char *filename,/* Database filename (UTF-8) */
sqlite3 **ppDb,/* OUT: SQLite db handle */
int flags,/* Flags */
const char *zVfs /* Name of VFS module to use */
);

SQLITE_API int sqlite3_exec(
sqlite3*,/* An open database */
const char *sql,/* SQL to be evaluated */
int (*callback)(void*,int,char**,char**),/* Callback function */
void *,/* 1st argument to callback */
char **errmsg /* Error msg written here */
);

SQLITE_API int sqlite3_get_table(
sqlite3 *db,/* An open database */
const char *zSql,/* SQL to be evaluated */
char ***pazResult,/* Results of the query */
int *pnRow,/* Number of result rows written here */
int *pnColumn,/* Number of result columns written here */
char **pzErrmsg /* Error msg written here */
);

SQLITE_API void sqlite3_free_table(char **result);

Example:

sqlite3_get_table(DateBase,strSqlCmd,&dbResult,&nRow,&nColumn))
{
for (int i = 1; i <= nRow; i++)
{
for (int j = 0; j != nColumn; j++)

{

printf("%s",dbResult[i*nColumn + j]);

}
}
}

sqlite3_free_table(dbResult);

SQL:

Select b.AppName,b.Desc,b.ModulePath,b.Args,b.ClassName from syn_toollist b,syn_exelist a where b.AppName = a.AppName order by Level1 asc,Level2 asc,level3 asc

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!