SQLite ½ÃÀÛ

SQLite´Â °¡º±°í ºü¸¥ ¿ÀǼҽº ÆÄÀÏ DBÀÌ´Ù.  ÃÖ±Ù¿¡ ¾ÆÀÌÆù ºÕÀÌ ÀϾ¼­ Àá½Ã ¾ÆÀÌÆù ÇÁ·Î±×·¡¹Ö Ã¥À» »ìÆì º¸´Ï SQLite´Ï »ç¿ëµÇ°í ÀÖ¾ú´Ù.

À©µµ CE ¸ð¹ÙÀÏ¿¡¼­ ´Ü¾îÀåÀ» ¸¸µé¶§ »ç¿ëÇϸé ÁÁ°Ú´Ù°í »ý°¢µÇ¾î SQLite¸¦ »ç¿ëÇØ º¸±â·Î Çß´Ù.

´Ù¿î·Îµå:
SQLite ´Ù¿î·Îµå:  Precompiled Binaries For Windows Ç׸ñ¿¡¼­ sqlite-3_6_22.zipÀ» ¹Þ´Â´Ù.
À©¾ÐÃàÀ» Ç®¸é sqlite3.exe ½ÇÇà ÆÄÀÏÀÌ ÀÖ´Ù. µ¥ÀÌÅÍ º£À̽º ½ÇÇà ÆÄÀÏÀÌ´Ù.
http://www.sqlite.org/download.html

CppSQLite :
3.0.8 ¹öÀüÀ» ´Ù¿î¹Þ¾Æ¼­ Common Æú´õ¸¸ ÇÁ·ÎÁ§Æ® Æú´õ·Î º¹»çÇÑ´Ù.
http://www.codeproject.com/database/CppSQLite.asp

<ÇÁ·ÎÁ§Æ® ¼³Á¤>

Common Æú´õ º¹»ç

¼Ò½º Ãß°¡: Common Æú´õÀÇ CppSQLite3.cpp, CppSQLite3.h

¶óÀ̺귯¸® Ãß°¡: sqlite3.lib

DLL º¹»ç: ½ÇÇà Æú´õ·Î º¹»ç

<¼Ò½º Ãß°¡>

ÆÄÀÏ DB »ç¿ë½Ã
const char* dbfile = "word.db";

¸Þ¸ð¸® DB »ç¿ë½Ã
const char* dbfile = ":memory:";

<SQLite ƯÁ¤>
-SQLite´Â ÆÄÀÏÇϳª°¡ Dtatabase ÇÏ´ÏÀÌ´Ù. Å×À̺íÀº ¿©·¯°³ µé¾î °¥¼ö ÀÖ´Ù.
-DB¸¦ ¿ÀÇÂÇÒ ¶§ ":memory: "ÀÌ¸é ¸Þ¸ð¸® DBÀÌ°í ÀÌ¿Ü¿¡´Â ÆÄÀÏ DBÀÌ´Ù.
-db.execDML¿¡¼­ ¸®ÅϵǴ °ªÀº ¿µÇâÀ» ¹ÞÀº row°³¼öÀÌ´Ù.

<SQLite Manager ¼³Ä¡>

FireFox ½ÇÇàÈÄ  https://addons.mozilla.org/en-US/firefox/addon/5817  ÆäÀÌÁö·Î À̵¿ÇÏ¿© SQLite Manager Ç÷¯±×ÀÎÀ» ¼³Ä¡ÇÑ´Ù.( MSÀÇ ÀÎÅÍ³Ý ÀͽºÇ÷ξ¼­´Â SQLite Manager ¼³Ä¡µµ ¾ÈµÇ°í ½ÇÇ൵ ¾ÈµÈ´Ù. )
SQLiteManagerÀÇ ½ÇÇàÀº FireFoxÀÇ ¸Þ´º-µµ±¸-SQLiteManager·Î ½ÇÇàÇÑ´Ù.

#include <stdio.h>

#include <iostream>

#include "Common/CppSQLite3.h"

 

#pragma comment(lib, "sqlite3.lib")

 

void main()

{

#if  1

    //ÆÄÀÏ DB »ç¿ë½Ã

    const char* dbfile = "customer.db";

#else

    //¸Þ¸ð¸® DB »ç¿ë½Ã

    const char* dbfile = ":memory:";

#endif

 

    int ret = 0;

    CppSQLite3DB    db;

 

    db.open(dbfile);

    // Å×ÀÌºí »ý¼º

    ret = db.execDML(" CREATE TABLE tbl_customer( NumIndex int NOT NULL, Name varchar(32), Age smallint );");

 

    // µ¥ÀÌÅÍ INSERT

    char query[256];

    sprintf_s(query, 256, "INSERT INTO tbl_customer( NumIndex, Name, Age ) Values( 1, 'Kim dong su', 20);" );

    ret = db.execDML(query);

    sprintf_s(query, 256, "INSERT INTO tbl_customer( NumIndex, Name, Age ) Values( 2, 'Kim tea hee', 30);" );

    ret = db.execDML(query);

 

    //µ¥ÀÌÅÍ SELECT

    CppSQLite3Query q = db.execQuery("SELECT NumIndex, Name, Age FROM tbl_customer");

    while (!q.eof())

    {

        std::cout << q.fieldValue(0) << " | ";

        std::cout << q.fieldValue(1) << " | ";

        std::cout << q.fieldValue(2) << " | " << std::endl;

        q.nextRow();

    }

 

    db.close();

}

[Âü°í or Æß]
http://www.jamsun2.com/zbxe/55061
http://alones.kr/tag/sqlite-manager