1. #include<stdio.h>
2. #include<stdlib.h>
3. #include<string.h>
4. #include"sqlite3.h"
6. //
7. //typedefint(*sqlite3_callback)(
8. //void*data,/*Dataprovidedinthe4thargumentofsqlite3_exec()*/
9. //intncols,/*Thenumberofcolumnsinrow*/
10. //char**values,/*Anarrayofstringsrepresentingfieldsintherow*/
11. //char**headers/*Anarrayofstringsrepresentingcolumnnames*/
12. //);
13. intcallback(void*data,intncols,87); background-color:inherit; font-weight:bold">char**values,87); background-color:inherit; font-weight:bold">char**headers)
14. {
15. inti;
16. intlen=0;
17. intll=0;
18. for(i=0;i<ncols;i++)
19. {
20. if(strlen(headers[i])>len)
21. len=strlen(headers[i]);
22. }
24. ll=len-strlen(headers[i]);
25. while(ll)
26. fprintf(stdout,"");
27. --ll;
28. }
29. fprintf(stdout,"%s:%s\n",headers[i],values[i]);
30. "\n");
31. return0;
32. intsearch_by_callback(constchar*db_name,char*sql_cmd)
33. inti=0;
34. intj=0;
35. intnrow=0,ncolumn=0;
36. char**azResult;//二维数组存放结果
37. sqlite3*db=NULL;
38. char*zErrMsg=0;
39. intrc;
40. if(access(db_name,0)==-1)
41. fprintf(stderr,"%snotfound\n",db_name);
42. return-1;
43. rc=sqlite3_open(db_name,&db);
44. if(rc!=sqlITE_OK)
45. "%sopenFailed:%s\n",db_name,sqlite3_errmsg(db));
46. sqlite3_close(db);
47. return-1;
48. //查询数据
49. rc=sqlite3_exec(db,sql_cmd,callback,NULL,&zErrMsg);
50. if(rc!=sqlITE_OK)
51. fprintf(stderr,"%s%s:%s\n",sqlite3_errmsg(db));
52. if(zErrMsg)
53. "ErrMsg=%s\n",zErrMsg);
54. sqlite3_free(zErrMsg);
55. if(zErrMsg)
56. //关闭数据库
57. intsearch_by_table(char*sql_cmd)
58. inti=0;
59. intj=0;
60. //二维数组存放结果
61. sqlite3*db=NULL;
62. char*zErrMsg=0;
63. intrc;
64. intlen=0;
65. rc=sqlite3_open(db_name,&db);
66. sqlite3_close(db);
67. //查询数据
68. rc=sqlite3_get_table(db,&azResult,&nrow,&ncolumn,&zErrMsg);
69. sqlite3_free_table(azResult);
70. for(j=0;j<ncolumn;j++)
71. if(strlen(azResult[j])>len)
72. len=strlen(azResult[j]);
73. //从第0索引到第nColumn-1索引都是字段名称
74. //从第nColumn索引开始，后面都是字段值
75. for(i=0;i<nrow;i++)
76. intll=(len-strlen(azResult[j]));
77. printf("");
78. printf("%s:%s\n",azResult[j],azResult[(i+1)*ncolumn+j]);
79. printf("\n");
80. #if0
81. printf("%s",azResult[j]);
82. for(i=ncolumn;i<(nrow+1)*ncolumn;i++)
83. if(((i-ncolumn+1)%ncolumn)==0)
84. printf("%s\n",azResult[i]);
85. else
86. printf("%s",248); line-height:18px; margin:0px!important; padding:0px 3px 0px 10px!important; list-style-position:outside!important"> #endif
87. //与sqlite3_get_table对应，释放掉azResult的内存空间
88. intsearch_by_stmt( sqlite3_stmt*stmt=0;
89. intncolumn=0;
90. char*column_name;
91. intvtype,i;
92. rc=sqlite3_prepare_v2(db,-1,&stmt,0);
93. ncolumn=sqlite3_column_count(stmt);
94. while(sqlite3_step(stmt)==sqlITE_ROW)
95. for(i=0;i<ncolumn;i++)
96. vtype=sqlite3_column_type(stmt,i);
97. column_name=sqlite3_column_name(stmt,i);
98. switch(vtype)
99. casesqlITE_NULL:
100. "%s:null\n",column_name);
101. break;
102. casesqlITE_INTEGER:
103. "%s:%d\n",column_name,sqlite3_column_int(stmt,i));
104. break;
105. casesqlITE_FLOAT:
106. "%s:%f\n",sqlite3_column_double(stmt,i));
107. casesqlITE_BLOB:/*arguablyfallthrough...*/
108. "%s:BLOB\n",column_name);
109. casesqlITE_TEXT:
110. default:
111. "%s:ERROR[%s]\n",248); line-height:18px; margin:0px!important; padding:0px 3px 0px 10px!important; list-style-position:outside!important"> sqlite3_finalize(stmt);
112. //关闭数据库
113. return0;
114. intmain(intargc,87); background-color:inherit; font-weight:bold">char*argv[])
115. if(argc!=4)
116. "usage:%s[table/callback/stmt]<db_name><sql_cmd>\r\n",argv[0]);
117. if((strcmp(argv[1],"table")==0))
118. search_by_table(argv[2],argv[3]);
119. else"callback")==0))
120. search_by_callback(argv[2],248); line-height:18px; margin:0px!important; padding:0px 3px 0px 10px!important; list-style-position:outside!important"> search_by_stmt(argv[2],248); line-height:18px; margin:0px!important; padding:0px 3px 0px 10px!important; list-style-position:outside!important"> }

编译 gcc sqlite3_search.c sqlite3.c -o sqlite3_search -lpthread -ldl