sqlite Cコード(コメント付き)

// name： query.c
// This prog is used to test C/C++ API for sqlite3 .It is very simple,ha !
#include <stdio.h>
#include <stdlib.h>
#include "sqlite3.h" 
//#define _DEBUG_

int main( void )
{
	sqlite3 *db=NULL;
	char *zErrMsg = 0;
	char *dbPath = "/usr/tomcat6/webapps/sql/WEB-INF/classes/sq3.s3db";

	int rc;
	
	rc = sqlite3_open(dbPath, &db); //          ,                  
	if( rc )
	{
		fprintf(stderr, "Can't open database: %s
", sqlite3_errmsg(db));
		sqlite3_close(db);
		exit(1);
	}
	else 
	{
		printf("You have opened a sqlite3 database saved in %s successfully!
",dbPath);
	}
	

	//     ,      ，    ，
	//    SQLITE_OK   
	//    ：            ，    SQL     
	//      callback  ，     ，      callback  
	//           ，    zErrMsg  
	char *sql = "	CREATE TABLE SensorData(\
				 	ID INTEGER PRIMARY KEY,\
					SensorID INTEGER,\
				 	SiteNum INTEGER,\
				 	Time VARCHAR(12),\
				 	SensorParameter REAL\
				 	);" ;
	sqlite3_exec( db , sql , 0 , 0 , &zErrMsg );

	#ifdef _DEBUG_
        printf("zErrMsg = %s 
", zErrMsg);
    #endif
	
	//    	
	sql = "INSERT INTO \"SensorData\" VALUES(NULL , 1 , 1 , '200605011206', 18.9 );" ;
	sqlite3_exec( db , sql , 0 , 0 , &zErrMsg );
	
	sql = "INSERT INTO \"SensorData\" VALUES(NULL , 1 , 1 , '200605011306', 16.4 );" ;
	sqlite3_exec( db , sql , 0 , 0 , &zErrMsg );
	
	
		
	int nrow = 0, ncolumn = 0;
	char **azResult; //        

	//    
	/*
	int sqlite3_get_table(sqlite3*, const char *sql,char***result , int *nrow , int *ncolumn ,char **errmsg );
	result                 ，     ，    。
	nrow ,ncolumn                ，  ，         0
	*/
	sql = "SELECT * FROM SensorData ";
	sqlite3_get_table( db , sql , &azResult , &nrow , &ncolumn , &zErrMsg );

	int i = 0 ;
	printf( "row:%d column=%d 
" , nrow , ncolumn );
	printf( "
The result of querying is : 
" );
	
	for( i=0 ; i<( nrow + 1 ) * ncolumn ; i++ )
		printf( "azResult[%d] = %s
", i , azResult[i] );

	//   	 azResult      
	sqlite3_free_table( azResult );
		
	#ifdef _DEBUG_
        printf("zErrMsg = %s 
", zErrMsg);
    #endif

	sqlite3_close(db); //     
	return 0;
	
}