// name： query.c // This prog is used to test C/C++ API for <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3 .It is very simple,ha ! // Author : zieckey // data : 2006/11/18 #include <st<a href="https://www.jb51.cc/tag/dio/" target="_blank" class="keywords">dio</a>.h> #include <stdlib.h> #include "<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3.h" //#define _DEBUG_ int main( void ) { <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3 *db=NULL; char *zErrMsg = 0; char *dbPath = "/usr/tomcat6/webapps/<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>/WEB-INF/classes/sq3.s3db"; int rc; rc = <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3_open(dbPath,&db); //打开指定的<a href="https://www.jb51.cc/tag/shujuku/" target="_blank" class="keywords">数据库</a><a href="https://www.jb51.cc/tag/wenjian/" target="_blank" class="keywords">文件</a>,如果不存在将创建一个同名的<a href="https://www.jb51.cc/tag/shujuku/" target="_blank" class="keywords">数据库</a><a href="https://www.jb51.cc/tag/wenjian/" target="_blank" class="keywords">文件</a> if( rc ) { fprintf(stderr,"Can't open database: %s/n",<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3_errmsg(db)); <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3_close(db); exit(1); } else { printf("You have opened a <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3 database saved in %s successfully!/n",dbPath); } //创建一个表,如果该表存在，则不创建，并给出<a href="https://www.jb51.cc/tag/tishi/" target="_blank" class="keywords">提示</a>信息，存储在 zErrMsg 中 char *<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a> = " CREATE TABLE SensorData(/ ID INTEGER PRIMARY KEY,/ SensorID INTEGER,/ SiteNum INTEGER,/ Time VARCHAR(12),/ SensorParameter REAL/ );" ; <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3_exec( db,<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>,&zErrMsg ); #ifdef _DEBUG_ printf("zErrMsg = %s /n",zErrMsg); #endif //插入数据 <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a> = "INSERT INTO /"SensorData/" VALUES(NULL,1,'200605011206',18.9 );" ; <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3_exec( db,&zErrMsg ); <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a> = "INSERT INTO /"SensorData/" VALUES(NULL,'200605011306',16.4 );" ; <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3_exec( db,&zErrMsg ); int nrow = 0,ncolumn = 0; char **azResult; //二维数组存放结果 //<a href="https://www.jb51.cc/tag/chaxun/" target="_blank" class="keywords">查询</a>数据 /* int <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3_get_table(<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3*,const char *<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>,char***result,int *nrow,int *ncolumn,char **errmsg ); result中是以数组的形式存放你所<a href="https://www.jb51.cc/tag/chaxun/" target="_blank" class="keywords">查询</a>的数据，首先是表名，再是数据。 nrow,ncolumn分别为<a href="https://www.jb51.cc/tag/chaxun/" target="_blank" class="keywords">查询</a>语句返回的结果集的行数，列数，没有查到结果时返回0 */ <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a> = "SELECT * FROM SensorData "; <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3_get_table( db,&azResult,&nrow,&ncolumn,&zErrMsg ); int i = 0 ; printf( "row:%d column=%d /n",nrow,ncolumn ); printf( "/nThe result of querying is : /n" ); for( i=0 ; i<( nrow + 1 ) * ncolumn ; i++ ) printf( "azResult[%d] = %s/n",i,azResult[i] ); //释放掉 azResult 的内存空间 <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3_free_table( azResult ); #ifdef _DEBUG_ printf("zErrMsg = %s /n",zErrMsg); #endif <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite3_close(db); //<a href="https://www.jb51.cc/tag/guanbi/" target="_blank" class="keywords">关闭</a><a href="https://www.jb51.cc/tag/shujuku/" target="_blank" class="keywords">数据库</a> return 0; }