#include <stdlib.h>
#include <stdio.h>
#include <sqlite3.h>
int my_callback(void *param, int f_num, char **f_value, char **f_name)
{
int i;
for(i = 0; i <= (f_num + 1) / 2; i++)
{
printf("%s\t",*(f_name+i));
printf("%s\n",*(f_name+i+2));
}
}
void my_search(sqlite3 * db)
{
char sql[100];
char *errmsg;
int nrow,ncolumn;
char **azresult;
int id,ret = 0;
printf("输入id\n");
scanf("%d",&id);
printf("\n");
sprintf(sql,"select * from mytable where id like '%d%';",id);
ret = sqlite3_exec(db,sql,my_callback,NULL,&errmsg);
if(ret == SQLITE_OK)
{
printf("select error : %s\n",errmsg);
}
printf("input any character\n");
getchar();
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)