VC2005使用SQLite,适用于WIN32以及WINCE
首先,把编译SQLITE生成的DLL、LIB和sqlite3.h 放到项目的文件夹下,把项目=》属性=》链接器=》输入=》附加依赖项:输入SQLITE的lib文件名
- 一、创建MySQLite.cpp:
- #include "stdafx.h"
- #include "MySQLite.h"
- bool MySQLite::sqlite_connect(char *filename)
- {
- db=NULL;
- zErrMsg = 0;
- row = 0, column = 0;
- int rc;
- rc = sqlite3_open(filename, &db); //打开指定的数据库文件,如果不存在将创建一个同名的数据库文件
- if( rc )
- {
- strcpy(zErrMsg,sqlite3_errmsg(db));//保存错误信息
- sqlite3_close(db);
- return false;
- }
- return true;
- }
- bool MySQLite::sqlite_exec(char *sql)
- {
- int rc;
- rc=sqlite3_exec( db , sql , 0 , 0 , &zErrMsg );
- if(rc == SQLITE_OK)
- return true;
- return false;
- }
- void MySQLite::sqlite_search(char *search_sql)
- {
- sqlite3_get_table( db,search_sql,&azResult,&row,&column,&zErrMsg);
- }
- bool MySQLite::sqlite_disconnect()
- {
- //释放掉 azResult 的内存空间
- sqlite3_free_table( azResult );
- if(sqlite3_close(db)==SQLITE_OK) //关闭数据库
- return true;
- return false;
- }
- 二、创建MySQLite.h:
- #include <stdio.h>
- #include <stdlib.h>
- #include <string.h>
- #include "sqlite3.h"
- class MySQLite
- {
- private:
- sqlite3 *db;//数据库句柄
- char **azResult; //二维数组存放结果
- char *zErrMsg;//保存错误信息
- int row;
- int column;
- public:
- bool sqlite_connect(char *filename);//连接数据库
- bool sqlite_exec(char *sql);//执行SQL命令
- void sqlite_search(char *search_sql);//查询
- bool sqlite_disconnect();//断开数据库连接
- int GetTableRow(){return row;}//查询后,取得表“列”数
- int GetTableColumn(){return column;}//查询后,取得表“栏”数
- char *GetErrorMsg(){return zErrMsg;}//取得当前错误提示
- char *GetTableData(int x,int y){return *(azResult+x+y*column);}//查询后,取得表内某个单元值
- };
- 三、创建测试文件test.cpp:
- #include "stdafx.h"
- #include <iostream>
- #include "MySQLite.h"
- #define _DEBUG_
- using namespace std;
- int main( void )
- {
- bool result;
- MySQLite *sqlite=new MySQLite();
- result=sqlite->sqlite_connect("hellogv.db");
- if(!result) cout<<sqlite->GetErrorMsg()<<endl;
- result=sqlite->sqlite_exec("CREATE TABLE SensorData(ID INTEGER PRIMARY KEY,SensorID INTEGER,SiteNum INTEGER,Time VARCHAR(500),SensorParameterREAL);");
- if(!result) cout<<sqlite->GetErrorMsg()<<endl;
- result=sqlite->sqlite_exec("INSERT INTO \"SensorData\" VALUES(NULL , 1 , 1 , '200605011206', 18.9 );");
- if(!result) cout<<sqlite->GetErrorMsg()<<endl;
- result=sqlite->sqlite_exec("INSERT INTO \"SensorData\" VALUES(NULL , 23 , 45 , '200605011306', 16.4 );");
- if(!result) cout<<sqlite->GetErrorMsg()<<endl;
- sqlite->sqlite_search("SELECT * from SensorData");
- cout<<sqlite->GetTableColumn()<<" "<<sqlite->GetTableRow()<<endl;
- cout<<sqlite->GetTableData(0,0)<<endl;
- sqlite->sqlite_disconnect();
- return 0;
- }
作者:古梅飞动
公司:蜜团科技
出处:http://www.mitsofts.com/index.php
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。