---

工程實(shí)例
http://hi.baidu.com/cokee/blog/item/7ac5bc013a5cb50a1d9583da.html

因 為項(xiàng)目中要用到嵌入式數(shù)據(jù)庫,，現(xiàn)在網(wǎng)上找了一些資料了解了一下嵌入式數(shù)據(jù)。在http://blog.csdn.net/love_study /archive/2009/04/07/4053644.aspx中講得蠻清楚,。綜合各自特點(diǎn),，最后決定選用SQLite。借鑒http: //www.codeproject.com/KB/database/CppSQLite.aspx,，自己寫了一個(gè)小例子,，實(shí)現(xiàn)了創(chuàng)建數(shù)據(jù)庫,，創(chuàng)建表， 添加記錄,，刪除記錄,，查詢記錄，修改記錄等功能,。
#include "sqlite3.h"
#include <iostream>
#include <time.h>
#pragma comment(lib, "sqlite3.lib")

const char* g_caDBName = "C:\\sqliteDB.db";
const char* g_caTabeName = "TB_Test";
sqlite3* g_pDB = NULL;
FILE* g_pFile = stdout;
char* g_caErrorMsg = NULL;

#define GROUP_NUM 100
char g_groupSqlStr[GROUP_NUM][256] = {0};

int Test1();   //測試創(chuàng)建一個(gè)新數(shù)據(jù)庫,，并向此數(shù)據(jù)庫添加表，對表中的記錄進(jìn)行增,，刪,，改，查,。

int main(int argc, char* argv[])
{
Test1();
system("pause");
return 0;
}

int Test1()
{
int ret = SQLITE_ERROR;
//創(chuàng)建數(shù)據(jù)庫
remove(g_caDBName);
ret = sqlite3_open(g_caDBName, &g_pDB);
if (!g_pDB)
{
fprintf(g_pFile, "創(chuàng)建數(shù)據(jù)庫失敗: %d\n", ret);;
return -1;
}
else
{
fprintf(g_pFile, "創(chuàng)建數(shù)據(jù)庫: %s 成功\n", g_caDBName);
}

char sqlStr[512];

//創(chuàng)建表
sprintf(sqlStr, "Create Table %s(fd_id int, fd_name char(20))", g_caTabeName);
ret = sqlite3_exec(g_pDB, sqlStr, NULL, NULL, &g_caErrorMsg);
if (ret != SQLITE_OK)
{
fprintf(g_pFile, "創(chuàng)建表失敗:%d\n", ret);
return -1;
}
else
{
fprintf(g_pFile, "創(chuàng)建表: %s 成功%\n", g_caTabeName);
}

//插入數(shù)據(jù)
int i = 0;
for(; i < GROUP_NUM; ++i)
{
sprintf(g_groupSqlStr[i], "Insert into %s values(%d, '%d')", g_caTabeName, i, i);
}
clock_t startTime = clock();
sqlite3_exec(g_pDB, "Begin Transaction;", NULL, NULL, &g_caErrorMsg);
for(i = 0; i < GROUP_NUM; ++i)
{
sqlite3_exec(g_pDB, g_groupSqlStr[i], NULL, NULL, &g_caErrorMsg);
}
sqlite3_exec(g_pDB, "Commit Trans;", NULL, NULL, &g_caErrorMsg);
clock_t endTime = clock();
fprintf(g_pFile, "插入%d條數(shù)據(jù),，花費(fèi)%d毫秒\n", GROUP_NUM, endTime - startTime);

//查詢數(shù)據(jù)條數(shù)
const char* pTail;
sqlite3_stmt* stmt;
sprintf(sqlStr, "select count(*) from %s", g_caTabeName);
ret = sqlite3_prepare(g_pDB, sqlStr, strlen(sqlStr), &stmt, &pTail);
if (ret != SQLITE_OK)
{
fprintf(g_pFile, "查詢記錄條數(shù)失敗");
return -1;
}
else
{
int recordCount = 0;
ret = sqlite3_step(stmt);
if (ret != SQLITE_ROW)
{
fprintf(g_pFile, "查詢記錄失敗: %d", ret);
return -1;
}

recordCount = sqlite3_column_int(stmt, 0);

fprintf(g_pFile, "共有%d條記錄\n", recordCount);
}

sqlite3_finalize(stmt);

//列出表中所有的數(shù)據(jù)
fprintf(g_pFile, "%10s%10s\n", "ID", "Name");
sprintf(sqlStr, "select FD_ID, FD_Name from %s", g_caTabeName);
ret = sqlite3_prepare(g_pDB, sqlStr, strlen(sqlStr), &stmt, &pTail);
if (ret != SQLITE_OK)
{
fprintf(g_pFile, "查詢記錄條數(shù)失敗");
return -1;
}
else
{
int id;
char name[256];

do
{
ret = sqlite3_step(stmt);
if (ret == SQLITE_DONE)
{
break;
}
else if(ret != SQLITE_ROW)
{   
fprintf(g_pFile, "查詢記錄失敗: %d", ret);
return -1;
}
id = sqlite3_column_int(stmt, 0);
strcpy(name, (const char*)sqlite3_column_text(stmt, 1));
fprintf(g_pFile, "%10d%10s\n", id, name);
} while(true);
}
sqlite3_finalize(stmt);

//修改數(shù)據(jù)
startTime = clock_t();
sprintf(sqlStr, "Update TB_Test Set FD_Name = 'New Name' where FD_ID > 40 and FD_ID < 80");
endTime = clock_t();
ret = sqlite3_exec(g_pDB, sqlStr, NULL, NULL, &g_caErrorMsg);
if (ret != SQLITE_OK)
{
fprintf(g_pFile, "修改失敗:%d\n", ret);
return -1;
}
int rowsEffect = sqlite3_changes(g_pDB);
fprintf(g_pFile, "修改了%d條數(shù)據(jù), 消耗%d毫秒\n", rowsEffect, endTime - startTime);

//刪除數(shù)據(jù)
startTime = clock_t();
sprintf(sqlStr, "Delete from TB_Test where FD_ID > 40 and FD_ID < 80");
endTime = clock_t();
ret = sqlite3_exec(g_pDB, sqlStr, NULL, NULL, &g_caErrorMsg);
if (ret != SQLITE_OK)
{
fprintf(g_pFile, "刪除失敗:%d\n", ret);
return -1;
}
rowsEffect = sqlite3_changes(g_pDB);
fprintf(g_pFile, "刪除了%d條數(shù)據(jù), 消耗%d毫秒\n", rowsEffect, endTime - startTime);


sqlite3_close(g_pDB);

return 0;
}

（#）