code toolbox

파일 다운로드!:: SQL_Lite.zip 

 CppSQLite3DB dbConnection;

 try
 {
      dbConnection.open("UserList.db3");

      int nRows = dbConnection.execDML("insert into userinfo values ('한효주', '한국');");
      cout << nRows << " rows inserted" << endl;

     CppSQLite3Query q = dbConnection.execQuery("select * from userinfo;");

     for (int fld = 0; fld < q.numFields(); fld++)
    {
        cout << q.fieldName(fld) << "(" << q.fieldDataType(fld) << ")|";
    }
    cout << endl;

    while (!q.eof())
    {
       cout << q.fieldValue(0) << "|";
       cout << q.fieldValue(1) << "|" << endl;
       q.nextRow();
    }

   nRows = dbConnection.execDML("delete from userinfo where user_name = '한효주';");
   cout << nRows << " rows deleted" << endl;

 }
 catch (CppSQLite3Exception& e)
 {
      cerr << e.errorCode() << ":" << e.errorMessage() << endl;
 }

CppSQLite3DB m_DB;

char query[ 255 ];

try

{

m_DB.open( "c:\aaa.db" ); // 데이터 베이스 열기

m_DB.execDML( "create table Tcp(num int, SrcAddr char(16), DstAddr char(16), SrcPort int, DstPort int, TcpLen int, Time char(20)) " ); 

// 테이블 생성

sprintf( query, "insert tcp values( %d, 'aaa', 'bbb', 10, 20, 30, '%d시간' );", i, 30 ); // 입력 쿼리문 생성
m_DB.execDML( query ); // 쿼리 실행

}

데이터 읽기

CppSQLite3Query q = m_DB.execQuery( "select * from Tcp;" );

while( !q.eof() )

{

data[ 0 ] = const_cast< char* >( q.fieldValue( 0 ) );

data[ 1 ] = const_cast< char* >( q.fieldValue( 1 ) );

data[ 2 ] = const_cast< char* >( q.fieldValue( 2 ) );

data[ 3 ] = const_cast< char* >( q.fieldValue( 3 ) );

data[ 4 ] = const_cast< char* >( q.fieldValue( 4 ) );

data[ 5 ] = const_cast< char* >( q.fieldValue( 5 ) );

  data[ 6 ] = const_cast< char* >( q.fieldValue( 6 ) );
  q.nextRow();

}